SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What is mutating table?

Saama Tech,

11 53396

How to call DDL statements from pl/sql?

5 27304

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

MBT, Evosys,

4 10436




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

2 10195

what are Dynamic SQL statements?

9 16766

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

TCS,

1 9136

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

4 11055

what is constraining table?

2 9799




How pl/sql source code can be protected?

2 7483

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

TCS,

21 32846

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

2 9238

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

Sail, ICICI, Saama Tech,

7 38246

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 4915

What are the advantages of VIEW?

5 28091

How many LONG columns are allowed in a table?

CTS,

6 16901


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

what is single byte over head in oracle..?

1289


what is try_catch block in procedure

545


How consistent is the view of the data between and within multiple sessions, transactions or statements ?

978


when MSQL8.0 is in market

967


Could you please provide oca (oracle 10g) dumps for my certification ?

3487






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

1423


1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

1187


If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

2960


What are local and global Indexes and where they are useful.

227


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

1853


How do you use collections in procedure to return the resultset?

1169


What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?

1253


What are code pages ?

1098


- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

561


i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

2295