I want to execute a piece of code before calling a procedure. How to achieve it?
Answer Posted / 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 View All Answers
What is gpt format?
How does stored procedure reduce network traffic?
What are tuples in sql?
How many sql core licenses do I need?
What are the different tcl commands in sql?
Why use truncate instead of delete?
how can we find the number of rows in a table using mysql? : Sql dba
What are pl/sql cursor exceptions?
What is the execution plan in sql?
How do I send sql query results to excel?
What is rownum and rowid?
what is self join and what is the requirement of self join? : Sql dba
Which certification is best for sql?
How do I remove all records from a table?
What is sql prepared statement?