Give an example of any procedure.
- 5 Answers
- 14885 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
Explain polymorphism in pl/sql.
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
How many triggers can be applied on a table?
What is a join?
How many commands are there in sql?
Can you join a table to itself?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
What does <> sql mean?
What is out parameter used for eventhough return statement can also be used in pl/sql?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
What is pl/sql table? Why it is used?
Which are sql * plus commands?
What is normalization in a database?
What is the primary use of normalization?
How do I turn a list into a table?
