Oracle AllOther Interview Questions
Questions Answers Views Company eMail

what is the difference between oracle 81,91,11i

Oracle, i2,

2 12699

How client makes connection with server in client/server architecture?

CA,

1 1411

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 2134

For web applications from which version of Oracle is suitable?

1 2398

What are the main diff. between oracle 7.3 and oracle 8i?

1 2264

What is the Symbol use for Inner Join

Oracle, TCS,

1 9165

How do you use trigger to create mutating state of table

TCS,

2 3654

When the procedures or packagess become invalidate

TCS,

3 3991

what is the difference between TRUNCATE and DELETE command in SQL

Saama Tech, TCS, ICICI, SkyTech,

23 43269

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

4 4578

Explain the difference between a hot backup and a cold backup and the benefits associated with each

1 2174

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

1 1690

How do you switch from an init.ora file to a spfile?

HCL, Wipro,

1 2225

Explain the difference between a data block, an extent and a segment.

Accenture, IBM,

1 5537

Give two examples of how you might determine the structure of the table DEPT.

2 2276


Post New Oracle AllOther Questions


Un-Answered Questions { Oracle AllOther }

3. Steps in UAT?

733


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

703


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

639


what are the tools used for oracle 10g in real time.

878


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

612


How would you determine who has added a row to a table?

713


key flexfield structure

602


I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

799


if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

563


CREATE OR REPLACE procedure XXPROC_OPENINT(errbuf OUT VARCHAR2, retcode OUT VARCHAR2) AS --Cursor Declaration cursor inv_cur IS SELECT INVI.INVOICE_ID ,INVI.INVOICE_TYPE_LOOKUP_CODE ,INVI.INVOICE_DATE ,INVI.VENDOR_ID ,INVI.VENDOR_SITE_ID ,INVI.INVOICE_AMOUNT ,INVI.INVOICE_CURRENCY_CODE ,INVI.STATUS ,INVI.GROUP_ID ,INVI.SOURCE ,INVI.ORG_ID ,INVI.DESCRIPTION ,INVI.CREATION_DATE ,INVI.CREATED_BY ,INVL.INVOICE_ID ,INVL.LINE_NUMBER ,INVL.LINE_TYPE_LOOKUP_CODE ,INVL.DESCRIPTION ,INVL.ORG_ID ,INVL.INVENTORY_ITEM_ID ,INVL.ACCOUNTING_DATE ,INVL.AMOUNT ,INVL.CREATION_DATE ,INVL.CREATED_BY ,INVL.PO_HEADER_ID ,INVL.PO_LINE_LOCATION_ID ,INVL.ITEM_DESCRIPTION FROM XXAP_INVOICES_INTERFACE_STG INVI ,AP_INVOICE_LINES_INTERFACE_STG INVL WHERE INVI.INVOICE_ID=INVL.INVOICE_ID AND INVI.ORG_ID=INVL.ORG_ID; l_currency_code varchar2(25); l_flag varchar2(2); l_error_msg varchar2(100); l_err_msg varchar2(100); l_err_flag varchar2(10); l_count number(9) default 0; BEGIN for rec_cur in inv_cur loop l_count:=l_count+1; --Currency Code Validation BEGIN SELECT currency_code INTO l_currency_code FROM FND_CURRENCIES WHERE currency_code ='USD'; EXCEPTION WHEN others THEN l_flag:='E'; l_error_msg:='Currency Code Does not Exists'; fnd_file.put_line(fnd_file.log,'Inserting Data Into The Interface Table'||'-'||l_count||' '||l_error_msg); END; IF l_flag!='E' THEN fnd_file.put_line(fnd_file.log,'Inserting Data Into The Interface Table'); INSERT INTO AP_INVOICES_INTERFACE( INVOICE_ID ,INVOICE_TYPE_LOOKUP_CODE ,INVOICE_DATE ,VENDOR_ID ,VENDOR_SITE_ID ,INVOICE_AMOUNT ,INVOICE_CURRENCY_CODE ,STATUS ,GROUP_ID ,SOURCE ,ORG_ID ,DESCRIPTION ,CREATION_DATE ,CREATED_BY) VALUES (rec_cur.INVOICE_ID ,rec_cur.INVOICE_TYPE_LOOKUP_CODE ,rec_cur.INVOICE_DATE ,rec_cur.VENDOR_ID ,rec_cur.VENDOR_SITE_ID ,rec_cur.INVOICE_AMOUNT ,rec_cur.INVOICE_CURRENCY_CODE ,rec_cur.STATUS ,rec_cur.GROUP_ID ,rec_cur.SOURCE ,rec_cur.ORG_ID ,rec_cur.DESCRIPTION ,rec_cur.CREATION_DATE ,rec_cur.CREATED_BY); INSERT INTO ap_invoice_lines_interface ( INVOICE_ID ,LINE_NUMBER ,LINE_TYPE_LOOKUP_CODE ,DESCRIPTION ,ORG_ID ,INVENTORY_ITEM_ID ,ACCOUNTING_DATE ,AMOUNT ,CREATION_DATE ,CREATED_BY ,PO_HEADER_ID ,PO_LINE_LOCATION_ID,ITEM_DESCRIPTION) VALUES (rec_cur.INVOICE_ID ,rec_cur.LINE_NUMBER ,rec_cur.LINE_TYPE_LOOKUP_CODE ,rec_cur.DESCRIPTION ,rec_cur.ORG_ID ,rec_cur.INVENTORY_ITEM_ID ,rec_cur.ACCOUNTING_DATE ,rec_cur.AMOUNT ,rec_cur.CREATION_DATE ,rec_cur.CREATED_BY ,rec_cur.PO_HEADER_ID ,rec_cur.PO_LINE_LOCATION_ID ,rec_cur.ITEM_DESCRIPTION); END IF; l_flag:=NULL; l_err_MSG:=NULL; END LOOP; COMMIT; END XXPROC_OPENINT; / PLS-00402: alias required in SELECT list of cursor to avoid duplicate column names

799


Could you please let me know the interfaces in OM / FA??

693


can we use lexical perameter in oracle plsql if yes how

804


i want to know about the javaBean.what is its purpose and how it can use in Forms.

624


1. What is PO rate variance gain and loss?

1057


Can we modify approve purchase order?if yes what is navigation?

531