Interested to Buy Any Domain ? << Click Here >> for more details...
Give an example of any procedure.
- 5 Answers
- 17157 Views
- Accenture, iFlex, Wipro, I also Faced
- E-Mail Answers
Answer Posted / roopesh kumar
We can write a procedure with or w/o using parameters.
For procedure the simplest ex. could be like as
SQL> create or replace procedure tr ---calling procedure
2 as
3 begin
4 in_emp; -- Called procedure
5 end;
6 /
in this procedure i am calling another procedure inside
that.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
what are the different tables present in mysql? : Sql dba
what does it mean to have quoted_identifier on? : Sql dba
What are the events on which a database trigger can be based?
what are the authentication modes in sql server? : Sql dba
What are primary key and foreign key and how they work?
Why schema is used in sql?
Show how functions and procedures are called in a pl/sql block.
What is function and procedure?
What is a temporal table?
What are the 3 types of behavioral triggers?
What are the ddl commands?
What is a temporal data type?
What is bind variable in pl sql?
what is the difference between nested subquery and correlated subquery?
Why we use joins in sql?
