• 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 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:
  • Oracle error ORA-01034 and ORA-27101

    I tired to connect but I'm not able to connect. I'm getting the following error: ORA-01034 - Oracle not available / ORA 27101 - shared memory realm. This is in Windows 7 with version Oracle 11g. I have started it up and mounted it but still not useful for me.

    HEMANT20165 pointsBadges:
  • Rename the Oracle 10g database user

    Hi. I want to rename the database user(username)without deleting the user and again creating in ORACLE 10g database??? plz, help me

    S1989082060 pointsBadges:
  • Can I clone a user in the same Oracle database?

    I have the need for a SQL query that will clone an Oracle user. For the source, I already have a user that has the necessary privileges. Would there be a way to clone the user but with a different username in the same database?

    ITKE828,840 pointsBadges:
  • How do I solve the ORA-00933: SQL command not properly ended error message?

    For the past few weeks, I've been using an OLEDB provider for ADO.NET connecting to an Oracle database. Currently in my loop, I'm doing this insert: insert into ps_tl_compleave_tbl values('2626899', 0, TO_DATE('01/01/2002', 'MM/DD/YYYY'), 'LTKN', 'LTKN', '52', TO_DATE('01/01/2002', 'MM/DD/YYYY'),...

    ITKE828,840 pointsBadges:
  • How to create multiple Oracle 11g databases

    Our department is currently using Oracle 11g and all of us are using it (including developers). But here's the issue - we can't buy several different licenses for each person. Would I be able to create one specific data for each person?

    ITKE828,840 pointsBadges:
  • Setting Oracle database to auto-commit

    Is there a way for me to find out if my Oracle database is set to auto-commit? If it is, how can I turn that off too? Thanks!

    ITKE828,840 pointsBadges:
  • Cannot connect to Oracle database: Oranos.dll is missing from my computer

    I've been trying to connect to my Oracle database but when this code is running (con = new OracleConnection(oradb);), it keeps giving me this error message: The program can't start because oraons.dll is missing from your computer. Try reinstalling the program to fix this problem. What should I do?...

    ITKE828,840 pointsBadges:
  • Deleting millions of records in Oracle database

    My Oracle database has roughly 2 billion (yes, I said billion) records. But we noticed that over 10 million of them are duplicates. How can we go about deleting those? Thanks!

    ITKE828,840 pointsBadges:
  • Getting all sequences in Oracle database

    Hi experts! Would there be an Oracle command I could run so I could get all of the sequences in my Oracle database? This is for Oracle 11g / Oracle Toad. Should I use the command line?

    ITKE828,840 pointsBadges:
  • Manual uninstall of Oracle

    For some reason (this only happens once in a while) but my Oracle database on Windows disappears. Because of this - I'm thinking of doing a manual uninstall. How can I do that?

    ITKE828,840 pointsBadges:
  • Insert table into existing Oracle column

    I noticed that whenever I try to add an existing to an existing column in Oracle, it's always down at the end of the table. Is there an Oracle command where I can tell it to put it in the table? Thank you.

    ITKE828,840 pointsBadges:
  • I would like to take a backup of Oracle Database by using unix scripts

    I would like to take a backup of Oracle Database by using Unix scripts. Is it possible? If yes, please provide the details.

    shamcpt5 pointsBadges:
  • Oracle Certification?

    Hi, I want to know, the total procedure for Oracle data base certification. Thanks

    Amin4rmOvexTechnology250 pointsBadges:
  • Connect remote Oracle database through PL/SQL Developer

    We have an Oracle database which connects to a remote IP address. Is there a way we connect to it through PL/SQL Developer? Thank you very much.

    ITKE828,840 pointsBadges:
  • Finding size of Oracle database

    We have a database in Oracle that we need to figure out the exact size of (it's currently on our disk). How can we do that? Is there a certain Oracle command? Thanks!

    ITKE828,840 pointsBadges:
  • Display all views in Oracle database

    On an Oracle database, can I display all the views that are currently set? Can I do this through SQL Developer?

    ITKE828,840 pointsBadges:
  • Connect Oracle database from Microsoft Excel application

    Is it possible for me to connect to an Oracle database from a Microsoft Excel application without a DNS? I tried to do it already but it keeps giving me an error saying: The driver was not found. What should I do here? What driver am I supposed to use?

    ITKE828,840 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...

    ITKE828,840 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