Interested to Buy Any Domain ? << Click Here >> for more details...
I want to execute a piece of code before calling a procedure. How to achieve it?
- 1 Answers
- 4244 Views
- Oracle, I also Faced
- E-Mail Answers
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 the use of function in sql?
What is a database? Explain
what is innodb? : Sql dba
which operator is used in query for pattern matching? : Sql dba
What is the purpose of cursors in pl/sql?
Can we write ddl statements in functions?
How to revise and re-run the last sql command?
What is data control language?
Is sql a backend?
How does pl sql work?
What are the types of dbms?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
Is full outer join same as cross join?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
what is data manipulation language? : Sql dba
