• How to insert multiple rows with a single INSERT in Oracle?

    How to insert multiple rows with a single INSERT in Oracle? I don't want to write 5 INSERT statements for this to insert 5 rows. Instead I prefer to execute this in one single statement. It would be great to know the solution. Thanks Suresh

    JANNUSURESH5 pointsBadges:
  • UPK 3.5.1 error

    ERROR System.ApplicationException: Invalid entry This is the error I get when I try to install UPK 3.5.1.

    progana10 pointsBadges:
  • Connect the D2K

    I am using Oracle 10g. I installed D2K 6i. After installing D2K, I wanted to connect it with the database. I had given my username, password and server name and it is showing 12154 error. What should I do? Just send me a step by step process how to resolve it. I am using xp2. Software/Hardware...

    anurrag20 pointsBadges:
  • Execution of Oracle 11g wrapped procedure gives ora-00900 error

    Hi, I have a procedure which I wrapped using the oracle 11g wrap utility. If I execute the wrapped procedure using JDBC I am getting an error of 0RA-00900 invalid SQL statement. The procedure is having basic SQL statements only. The same procedure if i wrap using Oracle 9i and execute using JDBC it...

    askmsc15 pointsBadges:
  • My Oracle forms 6i Form is exiting automatically

    Dear friends, My problem is...after compiling, my Oracle Forms 6i form is exiting automatically. How can I solve this problem?

    Himac225238435 pointsBadges:
  • Clear button

    Hi friends, I had created one form contains 2 table details(emp,dept), I saw the details from 2 table by entering empno but I want to clear those text fields.

    siva975005 pointsBadges:
  • Numeric value error

    How to solve this Error ORA-06502: PL/SQL: numeric or value error: character string buffer too small.

    avk86510 pointsBadges:
  • How to sort a resultset from a ‘group by’ statement

    I have written a query like this: select to_char(order_date,'mon-yyyy') "months", sum(nob) "number of bags" from p_in where order_date between '1-apr-11 and '31-mar-12' group by to_char(order_date,'mon-yyyy') The above query returns me a resultset which gives me number of bags sold in every month,...

    hussain22juzer500 pointsBadges:
  • Stop Oracle database using by other application

    I have Oracle 9i database & want to stop other people from using it and use other applications like SQL Developer & Toad.

    Waris10 pointsBadges:
  • Open IT Forum: IT’s role in customer service

    One of ITKnowledgeExchange's bloggers is working on a series about customer service in the enterprise, and how it can be improved. From the IT side, do you have any experiences or suggestions for improving how companies do customer service? We'll take horror stories as well! Help a fellow IT...

    MelanieYarbrough6,345 pointsBadges:
  • User input

    How do I get the user input, so I can use it on my query on Oracle Reports Builder 6? The report will be executed on a client desktop. Im using autosearch, and just found this : Report.GetAutoSearchDescriptionLines(Memo1.Lines);which get me the whole search description, including the user input for...

    italoportinho15 pointsBadges:
  • Hyperion planning

    Can anyone help me to figure out the difference  between substitution variable and dynamic user variable?

    ankit46855 pointsBadges:
  • Evidence of RMAN backup run

    If I run any RMAN backup, does Oracle provide a historical means, a table entry or database view which is evidence that an RMAN backup was run on a certain date?

    Miki5 pointsBadges:
  • RMAN duplicate

    1) Will be there any problem if there are two RMAN duplicates going (from two different auxiliary host) at the same time against the same source database? 2) How is the overhead incurred in the source DB during the RMAN duplication?

    aZGwiIw10 pointsBadges:
  • Inserting parent and child tables at a time

    Is there any way to insert parent and child tables data with select statement? On record in parent table and n number of records in child table. Please let me know if possible.

    Ammu35 pointsBadges:
  • Oracle Virtualisation

    Hi All, I am getting confused between Oracle VM and VirtualBox... I know that Oracle VM is a type 1 hypervisor which is a bare metal installation one and VirtualBox works on host and guest Operating systems. I have installed Oracle VM Server on my 32GB Ram server it was a bare metal installation,...

    database1235 pointsBadges:
  • Oracle application is installed in VMware in 2003

    Oracle application 12.1.1 is install in 2003 through VMware working properly. When I am trying to access application through Windows 7 (Windows 7 is install in C drive and 2003 is in E drive) its not working but the  application is working in 2003 through VMware but not working in Windows 7. I...

    oracleappsvmwarfe5 pointsBadges:
  • Date field validation

    Hi friends, I need a help from your side...I have developed one form in Oracle 6i. The problem is Date fields date format should take automatically (example 12jan2013 it has to take 12-jan-2013 automatically). Could you please tell me how to do it?

    formsandreports5 pointsBadges:
  • Run Oracle Procedure in SSRS dataset

    Have an Oracle stored procedure that needs to run to repopulate a table. Do not need data from sp, have a separate dataset to pull from refreshed table. What I need is a way to run the sp that is acceptable to SSRS inside or outside of dataset.

    redusn19505 pointsBadges:
  • Code coverage tool suggestion for PL/SQL

    Hello, we will use a code coverage tool for PL/SQL and have been looking for the best tool. I am wondering if you people can suggest any tool. Would you please write the reason why you selected it?  Sector is financial, if it helps and it doesn't matter if its open source or not. Thank you.

    merkancam5 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.

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