1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

I want to execute a piece of code before calling a procedure. How to achieve it?

Question Posted / k.prasanna


I want to execute a piece of code before calling a procedure. How to achieve it?..

Answer / abhisekh

we can call a procedure using 2 ways
1.using exec <procedure>
2.using anonymous block< begin <procedure> end;
now coming to ur questions answer. crate a anonymous block and add the statements u wanted to execute first then call the procedure.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what are the disadvantages of mysql? : Sql dba

0 Answers  

what are different types of collation sensitivity? : Sql dba

0 Answers  

What is on delete restrict?

0 Answers  

How do you modify a trigger?

0 Answers  

Differentiate between % rowtype and type record.

0 Answers  




Explain unique key in sql.

0 Answers  

What is a memo field?

0 Answers  

What is set transaction?

0 Answers  

What are records give examples?

0 Answers  

How do you sort in sql?

0 Answers  

Can you alter start with clause?

1 Answers   TCS,

What is the difference between local and global temporary table?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories