What is a pragma statement?

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

difference between SQL and C

1 Answers   Indus Software Technologies,

i want to display 1 to 10 numbers using one select statement.

18 Answers   Oracle, Nyros, HCL,

How well can multiple sessions access the same data simultaneously ?

1 Answers   Oracle,

What does “select count(1) from tab” result?

9 Answers   IBM,

Is it possible to access the current value in a session before accessing next value?

1 Answers  

Which are the different case manipulation functions in sql?

0 Answers  

Explain the difference between rename and alias?

0 Answers  

What is the benefit of foreign key?

0 Answers  

Does sql view stored data?

0 Answers  

How to execute OS(operating system) command from pl/sql?

3 Answers  

What is the primary key?

0 Answers  

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,