• 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?

    Himac225238430 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:

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