1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

List the built-in routines for the controlling canvas views during run-time?

 1 2948

What is an Alert?

Genpact,

1 3789

What are the display styles of an alert?

 1 3336

Can you attach an alert to a field?

 2 3511

What built-in is used for showing the alert during run-time?

 1 3263

What is the remove on exit property?

 1 2698

How many windows in a form can have console?

 1 4810

Can you have more than one content canvas view attached with a window?

TCS,

2 5218

What are the different window events activated at runtimes?

 1 2857

What are different types of modules available in oracle form?

 2 8852

What are the default extensions of the files careated by forms modules?

 1 3217

What are the default extentions of the files created by menu module?

 1 2880

What are the default extension of the files created by library module?

 1 2911

What is a master detail relationship?

 1 3623

What is coordination Event?

 1 3256

Un-Answered Questions { Oracle }

How many types of synonyms in Oracle?

596

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

1988

Explain self joins in oracle?

560

is there a tool to trace queries, like profiler for sql server?

602

What is the difference between formal parameters and actual parameters?

543




> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

1569

What does dba stand for database?

294

Differentiate between function and procedure in oracle.

561

Explain database link?

665

Mention what is the function of cache fusion in oracle rac?

1

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

1646

How many types of km's? And you what are the type's km are used in your project?

286

If you are working Microsoft excel, which type of file you used .excel or .csv?

279

What is flexfileds and use of flexfileds in odi?

290

What is an anonymous block?

623

For More Un-Answered { Oracle } Questions Click Here