What is the difference between local variables and global variables?


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

Post New Answer

More SQL PLSQL Interview Questions

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

0 Answers  


what is definer rights invoke rights?

1 Answers  


what is the purpose of update command in oracle?

7 Answers   MBT,


how to see the create table statement of an existing table? : Sql dba

0 Answers  


what is the difference between stored procedure and packaged procedure

1 Answers   Google, Infosys,






i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,


i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

14 Answers   iGate, Wipro,


What is a dynamic query?

0 Answers  


how instead of triger is helpful for mutating tables errors handlling ?

2 Answers   Oracle,


explain what is mysql? : Sql dba

0 Answers  


how to show all tables with 'mysql'? : Sql dba

0 Answers  


What is the difference between function, procedure and package in pl/sql?

0 Answers  


Categories