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


Oracle Interview Questions
Questions Answers Views Company eMail

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the smae block level ?

 2 3950

Can we use GO-BLOCK package in a pre-field trigger ?

 2 5478

Is a Keystartup trigger fires as result of a operator pressing a key explicitly ?

 1 2688

How can you execute the user defined triggers in forms 3.0 ?

 2 6465

When does an on-lock trigger fire ?

 1 12266

What is Post-Block?

 1 4197

What is the difference between keystartup and pre-form ?

 1 3783

What is a Package Procedure ?

 1 2982

What are the different types of Package Procedure ?

 1 4658

What is the difference between restricted and unrestricted package procedure ?

 3 6608

Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?

 1 4757

What SYNCHRONIZE procedure does ?

 1 3557

What are the unrestricted procedures used to change the popup screen position during run time ?

 1 3069

What Enter package procedure does ?

 1 3478

What ERASE package procedure does ?

 1 3044

Un-Answered Questions { Oracle }

How to best split csv strings in oracle 9i?

606

What are materialized views & where do we use them? What is a materialized view log?

1

What is a user role in oracle?

625

Which profile required to access Models in Designer tool?

396

What is responsibility and how u attach How to create user and how u attach with responsibility.

1627




How to convert character types to numeric types?

588

Will you be able to store pictures in the database?explain.

546

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1268

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

1824

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1296

What is the variable?

334

What is the usage of merge statement?

687

Which directory will you copy your new reports, what would be its extension (.rdf or .rex)?

1

Explain the use of full option in exp command.

599

What are the system variables can be set by users? Explain them

1

For More Un-Answered { Oracle } Questions Click Here