Oracle Tag Directory

Browse Alphabetically:

Featured Oracle Questions

  • VB6 with Oracle 10g as database: Using add, edit, delete and search button with following fields: title, author, publisher, year, category

    How can I set up a library system with add, edit delete, search button  with following fields: title, author, publisher, year, category using VB6 and Oracle as database? Thanks

    jeremy275 pointsBadges:
  • Oracle 10g CONTINUE keyword for T-SQL stored procedure migration

    I'm looking to migrate a T-SQL stored procedure to PL/SQL but I'm constantly running into one particular issue. I noticed that there isn't a CONTINUE keyword for Oracle 10g. Is there a workaround for this? My friend told me to just upgrade but I can't do that right now.

    ITKE407,620 pointsBadges:
  • Install Oracle 11g R2 on Ubuntu

    Does anyone know how I can install Oracle 11g R2 on Ubuntu? I'm currently using a 32-bit operating system but this would be for a x86 version. Desktop is 64-bit too. Thanks for the help.

    ITKE407,620 pointsBadges:
  • Create first database in Oracle Database 11g Express

    Recently, I installed Oracle Database 11g Express on my Windows 7 machine. Also, I installed Oracle SQL Developer too. Now, I'm looking to create a database with two tables, followed by using SQL Developer to add / query data. But when I opened Developer, it's asking me to make a new connection (I...

    ITKE407,620 pointsBadges:
  • RAC patching: How to force sessions to connect to other node

    Hi experts, I have one query regarding applying a patch (interim,psu) in a 4 node RAC in rolling fashion. My question is while applying patch on one node I heard that we should down the instance and we will apply remaining nodes are up and running. At that time what happens about the running...

    sirajdba175 pointsBadges:
  • Running Oracle 10g form

    I can't get a form to run through the browser on my machine. I can compile ok, but when I run the form I get the "cant display page" error in IE. I have the listener running. What am I missing?

    Tdmcolumbus75 pointsBadges:
  • How to run Oracle 10g forms on browser

    Hello everyone, When I run form browser, it shows only Oracle forms. Please help me solve my problem.

    Scarletsys5 pointsBadges:
  • How to retrieve last record from given table without using rows function in Oracle

    I don't use rows function like row_num, rowid, rownumber. How can I do this in Oracle?

    Swatirupnar11808199210 pointsBadges:
  • Cannot download Oracle Express 11g

    I'm trying to download Oracle Express 11g but it keeps offering me only downloads for for Windows 32-bit and Linux 64-bit. Can I get it for Windows 64-bit? Thanks so much.

    ITKE407,620 pointsBadges:
  • Oracle 10g: Rename table column

    Hi experts! Does anyone happen to know how I can rename my table column in Oracle? Particularly Oracle 10g? Thanks so much.

    ITKE407,620 pointsBadges:
  • Searching Oracle 11g database for string in tables

    I'm trying to search my Oracle 11g database for a string in all of my columns and tables. Here's the query I'm using: BEGIN FOR t IN (SELECT table_name, column_name FROM all_tables) LOOP EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM '||t.table_name||' WHERE '||t.column_name||' = :1' INTO match_count...

    ITKE407,620 pointsBadges:
  • username and password is asking oracle 10g database

    i installed oracle 10g dba clint side in my pc, but username, password and string is asking pls help me sir/madam

    Unix5 pointsBadges:
  • Insert data into newly created Oracle 10g tables

    I have created a database for scenario. I have 6 tables created. I am having difficulty inserting the data.

    Ray30syed5 pointsBadges:
  • Error message when starting up Oracle 11g database on Windows Server 2008 R2

    I'm running Windows Server 2008 R2 and when I'm trying to startup Oracle 11g database, I keep getting this error: SQL> startup ORACLE instance started. Total System Global Area 3206836224 bytes Fixed Size 2180024 bytes Variable Size 1996491848 bytes Database Buffers 1191182336 bytes Redo Buffers...

    ITKE407,620 pointsBadges:
  • If I search with and FK ID_Entity on a big table, takes 0.05s to return 2000 rows, but if I search with the FK and a Varchar2(1) takes too long!

    I have a table with 3000000 rows. With a Select count(1) from  Conceptos where id_entidad = 1 Takes 0.05s to return the number 2000 But if I search Select count(1) from  Conceptos where id_entidad = 1 and Esta_Aprobado = 'S' Then it takes 7s to return the same number I hace index over Id Entidad...

    romaedu2005 pointsBadges:
  • How to uninstall OracleserviceXE

    I am trying to install a new version of Oracle 10g. I thought that I had uninstalled the previous version but whatever I do I get the message "OracleServiceXE is present on the system". How can I fix this please? Des

    Desjacks5 pointsBadges:
  • How to insert looping data in Oracle database using VB.NET?

    Dim cmd = New OracleCommand For i = 0 To DataGridView1.Rows.Count - 1 Sql = "INSERT INTO TM_EMPLOYEE_INFO (V_EMPLOYEE_NO, " Sql = Sql & "V_NAME_TRAINEE,N_GENDER,V_COMPANY) " Sql = Sql & " VALUES('" & DataGridView1.Rows(i).Cells(0).Value & "', " Sql = Sql & "'" &...

    ajpascual195 pointsBadges:
  • Oracle 11g on Google Chrome

    We had developed application on using Oracle Forms and Reports 11G with backend Oracle Database Standard Edition Release 11.1.0.6.0. Both are installed at windows 2008 server. It was purchased from Premier System Limited. When the developed application was deployed and run on Internet Explorer, it...

    ghauria15 pointsBadges:
  • Connecting oracle forms 6i with 10g XE database

    I would like to know from anyone out there how to cnfigure an oracle client with developer 6i to communicate with server with oracle 10g XE.

    Omuga5 pointsBadges:
  • ORA-01445: cannot select ROWID from a join view without a key-preserved table

    Hello, For the first time in my IT-life I've encountered following error message when I try to run query using ROWID on a view: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table I found something about key-preserved tables, but I'm not sure that my...

    LukyFox25 pointsBadges:

Browse Alphabetically:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following