How will you distinguish a global variable with a local variable in pl/sql?


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

Post New Answer

More SQL PLSQL Interview Questions

HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM

3 Answers  


Is there any restriction on the use of union in embedded sql?

0 Answers  


What is difference between % ROWTYPE and TYPE RECORD ?

2 Answers  


What is sql query optimization?

0 Answers  


What is the difference between left join and left outer join?

1 Answers  






If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  


3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,


what is the difference between $message and $$message? : Sql dba

0 Answers  


How can we overcome recursive triggers in SQL?

1 Answers   iFlex,


is it possible to pass an object or table to a procedure as an argument?

0 Answers  


What is trigger in pl sql?

0 Answers  


Is sql database free?

0 Answers  


Categories