• Need help with Oracle query

    how to display the third highest salary from an employees table thanks in advance

    Xaviervicky30 pointsBadges:
  • Oracle – Deleting a row from a complex view

    why we can delete a row from a complex view if it does not contains group by clause,group functions,distinct keywords,pseudocolumn

    Avej10 pointsBadges:
  • Oracle Forms 6i – Execute query

    Execute_query is not refreshing the data from a currently active block but Execute_query is refreshing a different block. I have given go_block pointing to one block. But execute_query is refershing a differnt block. Please suggest.

    Ammy5 pointsBadges:
  • Oracle 10g Reports not running

    Hi Gurus, We are trying to migrate from form and reports 4.5 to 10g and while migrating them we were able to find the way to work with forms 10g but not with reports 10g from within forms. can any one give me the procedure to make reports 10g to work within forms . with example please.

    Xaviervicky30 pointsBadges:
  • PL/SQL Insert

    Hi Experts, I am trying to do 2 INSERT stms on 2 tables consecutively n same transaction and my first insert is successful while doing the insert on second table which is completely carry same set of attibutes and values of 1st table + 1 additional static value attribute,it gives ORA :01400 error...

    Inprise610 pointsBadges:
  • number of week days

    How do i find out the number of weekdays in a date range in oracle.

    Prajakt5 pointsBadges:
  • Calling a SQL Server 05 Stored Procedure from Oracle

    Is it possible to call a SQL Server 2005 stored procedure from Oracle? If the sp is called get_item_desc and has one input parameter (item_id), what might this call look like? Any help most appreciated!

    Nikkipom795 pointsBadges:
  • Oracle Enterprise Manager login password error

    We have windows 2003 server and we are running 2 oracle databases in version 11g. We were successfully configured EM for one database and when we were tried for the other database we encountered configuration errors and we were able to sort by searching on "google", solution was "ocijdbc10 file has...

    PKSDBA5 pointsBadges:
  • INSTR ()

    Hi Experts, My test case s working fine for the INSTR() but the same if i use in implemenation its not raising the error giving below the pseudo code IF INSTR (v_lm,pcd,1,1) = 1 OR INSTR(vlm,pc,1,1) = 1 OR INSTR(vlm,pcn,1,1) = 1 THEN raise_application_error( err_pkg.nt_val, err_pkg.nt_val_msg ||...

    Inprise610 pointsBadges:
  • Oracle connectivity with Oracle Forms 6i

    I am a new Oracle Form6i user. i ve installed Oracle form 6i in d:\Orant. now i need to work on form builder. there when i go with the wizard then i browse the table name it ask me with username :scott password : tiger database: so i have the problem what database name should i enter there. can...

  • How to determine Receipting tables linked to PO Line

    What are the receipting tables linked to PO Line (Header, Shipment, Distributions)?

    Jherb335 pointsBadges:
  • Lotus Notes to Oracle

    i have a field (date)i want to insert date(field) in oracle table .i used"+doc.date(0)+"but date is not inserted in oracle table . how can it possible .pls suggest me.

    Oraclelotu10 pointsBadges:
  • oracle log for table update infimation

    I am a system Administrator, I am having Oracle 10g database server on windows 2000 server in my office LAN network front end is forms & reports 6i. in last 10days 1 user connected to oracle database other than regular forms 6i program and modified one table record column value by update. How can i...

    Mbv30 pointsBadges:
  • Bulk Collect loop and Cursor Loop

    Why there is such a huge performace difference between Collection loop and a cursor Loop? Why collection populated using Bulk collect is way faster? Detailed explaination will be helpful. Thanks

    Nikhildhar35 pointsBadges:
  • What should our next contest be on ITKnowledgeExchange.com?

    We want to kick off the new year with an exciting contest and want your input. We have done a variety of contests from the top 3 Knowledge Point earners winning prizes like an XBOX 360. Also we have had Amazon.com gift cards for the top 10 point earners who achieve over 500 Knowledge Points. I want...

    ITKE56,495 pointsBadges:
  • How to write a test case in PL/SQL

    Hi Experts, How to write a test case in PL/SQL to check whether the parameter of a procedure (eg email iddress) takes only lower case ,i did this way in my procedure If(emailadd) <> lower(emailadd)then raise_app_error_ But this can be checked n test case please guide me with pseudo code...

    Inprise610 pointsBadges:
  • BACKUP & RECOVERY for Oracle 9i

    How can i take a backup of my database through OEM ? PLZ reply ASAP

    NehaArya55 pointsBadges:
  • querying detail records

    how do I query a detail record in a master-detail Oracle 6i form

    Kobi5 pointsBadges:
  • Hyperion Planning Delivered Reports

    Straight off the shelf, what reports and forms come already configured for Hyperion Planning and Hyperion Planning ETL?

    Purple5 pointsBadges:
  • Clustering

    I am using Oracle 10g on Windows I would like create clustes for faster reterival. How can I create it(syntax) can you help me with an example. How does it effect the performance

    Vishwanathavn5 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