• BULK COLLECT and FORALL in PL/SQL

    How do I update multiple columns in a table using the BULK COLLECT... FORALL methods in PL/SQL.

    RangjungDorje20 pointsBadges:
  • Can a Pivot table be created in Oracle 10g?

    I am running a stored procedure on ORACLE 10g that truncates and repopulates a table (tbl_A) that contains 2 columns; a list of unique codes and monetary amounts. The number of codes may vary weekly. I would like to create a second table(tbl_B) that contains a column for each of the names being...

    CAJ5 pointsBadges:
  • I am getting ORA-01422: Exact fetch returns more than requested number of rows

    Hi experts, I am getting this error when I run my test case for my PL/SQL procedure, which has select and insert statements only. Not clear where I would have went wrong, Please guide me where should I check exactly. Its popping up with this error message which i caught in a exception piece after...

    Inprise610 pointsBadges:
  • ORA-06502: Character string buffer too small

    Hi guys, Here's my script I have created aggregate string function 'Tab_To_String' using this below script CREATE OR REPLACE TYPE t_varchar2_tab AS TABLE OF VARCHAR2(4000); CREATE OR REPLACE FUNCTION Tab_To_String (p_varchar2_tab IN t_varchar2_tab, p_delimiter IN VARCHAR2 DEFAULT ',') RETURN...

    Kruti123456789shah15 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 recover from ORA 01033 Oracle installation or shutdown in progress error

    After UPS failure my database failed and given ORA-01033 error. I stopped all Oracle services and copied ORA data file to another server, having same database name and SID. The old Oracle was in C Drive and new is in E Drive. I am getting the same error. Can I recover my data anyway. Please help....

    Gianmoor10 pointsBadges:
  • JDE world data archive at decommision

    Hi, Has anybody had to perform this task and got any tips? Especially in the UK to comply with HMRC and other retention requirements.

    SMOtty5 pointsBadges:
  • How do you get around an ORA-06550 error?

    I am making a program that will ask the user to enter a customer number. All of the customer numbers are numbers only. If the user enters in a customer number with a letter in it by mistake they will receive an ora-06550 error on that line number. How can I create an exception that will allow me to...

    Jonsorr20 pointsBadges:
  • Bulk Collect vs Cursor in Oracle

    Hi, I have to process some records in some work table. The no. of records in work table may vary from 100,000 to 4,000,000. To process records in this work table i have to loop through it 1 by 1. So please tell me which is the better option out of these two: 1. Create Cursor for this work table and...

    Nikhildhar35 pointsBadges:
  • Oracle SQL and compare date

    Hello! I need help. I want to compare two dates and count how many days its between them. Example: 2006-09-22 and 2006-10-06 results: 14 days Hope for help. Thanks!

    MissNew0 pointsBadges:
  • Formatting PL/SQL code in SQL Developer

    Hi experts, I would like to know some keyboard shortcuts and clever formatting on PL/SQL codes in SQL Developer. Please help me out with some hints for this. Thanks in advance.

    Inprise610 pointsBadges:
  • Install rwserver

    How I can install rwserver in normal Devsuit 10g 10.1.2.0.2?

    mahi019115 pointsBadges:
  • 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:

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