• IN PL/SQL how to declare and use ‘STATIC DATA TYPE like C’

    Hi All, Can anybody help me to declare a variable having the similar propery of 'STATIC DATA TYPE IN C'. Means declare a variable and initialize it inside the procedure and called the procedure recursively but each time it is initializing the variable. I want any mechanism in PL/SQL that will make...

    Oracle10g4developers5 pointsBadges:
  • How do I remove a filter in a report created using UNION

    Does anyone know how can I remove a filter in a report created using UNION?

    akaMzambo5 pointsBadges:
  • Is it possible to use ADDRDBDIRE to connect to Oracle database?

    Is it possible to connect to Oracle database from IBM i? How to do that (I have IP address user ID, password and SID)? Thank you.

    VadimR5 pointsBadges:
  • Slow connection to Oracle from AS/400 (OJDBC)

    I'm trying to connect to Oracle from AS/400 via OJDBC, but the connection is taking 30 seconds. The same is for connection to SQL Server. To connect MySQL is okay, it is simultaneously.

    migallego5 pointsBadges:
  • AIX 7 and ORACLE 11 Read CR/LF from database

    We have an Oracle 11 database with CR/LF in one of the table. We run query from two clients: AIX 5.3 with Oracle 9, we got the CR/LF. Second client - AIX 7.2 with Oracle 11, same query, the CR is deleted and we receive only LF.

    asherhaim5 pointsBadges:
  • Which is better: Oracle quality module or customized forms?

    Which is better and why in Oracle quality module or customized forms what are pro's and cons of each? If there's a scenario in which we would prefer one, how to we make the decision?

    sufi12315 pointsBadges:
  • How to update Oracle table with CSV file

    My CSV file has several columns. Now in my Oracle table, the ID automatically identifies a row. Is there for me to replace my values in that table with the CSV file values while keeping everything else the same? Would a SQL script work?

    ITKE828,760 pointsBadges:
  • Oracle Forms application behave as a web portal in a browser

    I am migrating an Oracle Forms 6i application to Forms 11g and I need it to: Scale as any web application with the browser Get the WMI title visible Expand to all the browser window Thanks in advance. Javier

    JavierG5 pointsBadges:
  • SC delete OracleServiceXE is not working for me

    I have removed Oracle from system, but when I try to install it again, I'm getting the error as an instance of Oracle already there please remove the files and re install again. I have delete all files, but I'm still getting same error. As suggested above, I have try to run sc delete...

    Reddy0075 pointsBadges:
  • Oracle SQL script to deactivate customers records with possible multiple debt some paid some not paid

    I want to write a Oracle SQL script that will only deactivate a customer record with no outstanding debt.

    lindadawes5 pointsBadges:
  • License the entire Oracle server, if we use IBM LPAR (uncapped) for hard partitioning?

    Do we have to license the entire Oracle server, if we use IBM LPAR (uncapped) for hard partitioning?

    himanshu115 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 CSV file into Oracle database through PL/SQL procedure

    Hi all, I have a CSV file and I have to insert its data into the Oracle database. Is it possible through creating procedure if yes then give me any solution, I need it urgently. Thanks in advance.

    mollarubia5 pointsBadges:
  • ORA-03127: no new operations allowed until the active operation ends

    Good Morning, Since oracle 10g and even after upgrading to oracle 11g , e keep getting an oracle error: ORA-03127: no new operations allowed until the active operation ends, in relation to a diferent db table, every time the error occurs. including db tables that have maintenunce every day. can...

    Costaf40 pointsBadges:
  • Oracle sub query

    I need to display the names of male and female programmers. I have name as a field in the programmer table and now depending on the sex I have to display the names separately. Can you help me out with the query?

    udayasri5 pointsBadges:
  • Copying from host machine to database Server directory

    I want to copy a file from my host machine (in this case the Windows 10 machine from the user) to a directory located in the database server (Linux) with a Oracle 10 forms. How can I do that?

    ricgomsa25 pointsBadges:
  • Why do we need Cassandra?

    Why do we need Cassandra if we have the Oracle data sets and what is advantage over Oracle?

    bbsdssd5 pointsBadges:
  • How I can do a row ID in SQL Server

    Hi, excuse me, I want to do some ask for you. How I can do a row ID in SQL Server because I need a row ID CE517DED-7A39-48B0-85BD-73B95018FACB. Because in Oracle I know than this is possible, but in SQL Server, I don't know. I hope you can help me please.

    LuisFer5 pointsBadges:
  • Error(10601,4): PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following:

    When I'm compiling a package, I'm getting below error. Error(10601,4): PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: begin end function pragma procedure. I'm using is Oracle 11g in SQL Developer.

    Vimalkv15 pointsBadges:
  • Sending an email alert to addresses in the database and getting a return email as notification

    Dear Sir/Madam, I have this PL/SQL Store Procedure that sends out email with query result in HTML table format to email addresses in my database but I want to be notified what was the data send to each customer email every time a email is send. Can anybody help me with how to get this done?

    ADagoseh25 pointsBadges:

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.

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

Following