SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What is mutating table?

Saama Tech,

11 53751

How to call DDL statements from pl/sql?

5 27549

How to perform a loop through all tables in pl/sql?

MBT, Evosys,

4 10668




How to maintain the history of code changes of pl/sql?

2 10370

what are Dynamic SQL statements?

9 17031

Does it possible to pass object (or) table as an argument to a remote procedure?

TCS,

1 9378

What is pl/sql and what is it used for?

4 11182

what is constraining table?

2 9946




How pl/sql source code can be protected?

2 7595

What is the result, when NULL is compared with NULL?

TCS,

21 33351

What can be a size of a pl/sql block? Is there any limit?

2 9376

what are %TYPE and %ROWTYPE? what is the difference?

Sail, ICICI, Saama Tech,

7 38623

HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 4991

What are the advantages of VIEW?

5 28244

How many LONG columns are allowed in a table?

CTS,

6 17212


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

Can one improve the performance of sql*loader? : aql loader

6


What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

5


What is the usage of distinct keyword?

7


Compare sql & pl/sql

9


How does sql*loader handles newline characters in a record? : aql loader

7






Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

9


List and explain the different types of join clauses supported in ansi-standard sql?

6


In what condition is it good to disable a trigger?

10


Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

1464


i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

248


What is a null value?

8


What is a trigger in sql?

10


How can you get sql*loader to commit only at the end of the load file? : aql loader

7


What are the different datatypes available in PL/SQL?

18


How can the performance of a trigger be improved?

15