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
- 4221 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 sql scripting?
What is varchar sql?
What is the least restrictive isolation level? : Transact sql
What is sql engine in oracle?
How do you update a value in sql?
How does rowid help in running a query faster?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
How can you load microsoft excel data into oracle? : aql loader
What are the different parts of a package?
What is the use of procedures?
What is primary key secondary key alternate key candidate key?
What are variables in pl sql?
What is a full join?
How to run pl/sql statements in sql*plus?
Can we connect to postgresql using sql developer?
