Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2305

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

Mastek,

2457

How we can migrate the 6i report to 10g reports. What steps need to reuired?

ABC,

2 11331

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2325

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3049

After using set unused can we enable the column again to use? Please give me some answers....

Maveric,

1 4807

what is the difference between no rows returned and null returned?

2 5541

how to genarate random numbers in oracle for particular row?

3 7691

What is use of oracle?

Satyam,

2 5466

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

2493

i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash

2 10255

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1983

SQL> CREATE TABLE to_table 2 (col1 NUMBER); Table created. SQL> CREATE OR REPLACE TRIGGER statement_trigger 2 AFTER INSERT ON to_table 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('After Insert Statement Level'); 5 END; 6 / Trigger created. SQL> CREATE OR REPLACE TRIGGER row_trigger 2 AFTER INSERT ON to_table 3 FOR EACH ROW 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level'); 6 END; 7 / Trigger created. SQL> INSERT INTO TO_TABLE VALUES(1); After Insert Row Level After Insert Statement Level 1 row created. SQL> BEGIN 2 INSERT INTO TO_TABLE VALUES(2); 3 INSERT INTO TO_TABLE VALUES(3); 4 INSERT INTO TO_TABLE VALUES(4); 5 INSERT INTO TO_TABLE VALUES(5); 6 INSERT INTO TO_TABLE VALUES(6); 7 INSERT INTO TO_TABLE VALUES(7); 8 INSERT INTO TO_TABLE VALUES(8); 9 INSERT INTO TO_TABLE VALUES(9); 10 INSERT INTO TO_TABLE VALUES(0); 11 END; 12 / WAT LL BE THE O/P??? XPLAIN IT>>>>

Infosys,

1 4429

interview questions with answer for cts

Cognizant,

2578

What is the difference between alert log file and trace file ?

1 26824

Un-Answered Questions { Oracle }

In topology manager where the data are stored?

675

What is a proxy class?

1038

How to use windows user to connect to the server?

986

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2058

What is coalesce function?

1064

Is there any link between pr form(purchse requisition)and po form(purchase order)

2715

What is oracle sid?

947

Explain the different types of queries created in reports?

What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4613

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2257

How to create a temporary table in oracle?

1264

which one is currently in used software cmpanies.

2145

How do you bind variables in oracle?

978

How to assign a table row to a record variable?

1036

What is Trigger in Oracle?

1164

For More Un-Answered { Oracle } Questions Click Here