Interested to Buy Any Domain ? << Click Here >> for more details...
What are the two parts of a procedure ?
- 6 Answers
- 16292 Views
- Hi Caliber IT, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chakri
Syntax of procedure :
CREATE OR REPLACE PROCEDURE proce_name (Arg list)
IS
LOCAL VARIBLE DECLARATION
BEGIN
----------
----------
---------
END;
In the about syntax
Up to IS key word called as Procedure Header and
Remaining Part is called as Procedure Body.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / kirankumar.vangeti
create or replace procedure procedure_name as
Declare
/* Declarative section: variables, types, and local sub
programs */
Begin
/* Executable section: Procedural and sql statements go
here */
Exception
/* exception handling section: error handling statements go
here */
End;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / a.jyothsna
Procedure specification: create or replace procedure proc-nm
(agumentlist)
procedure body: is-------------end
| Is This Answer Correct ? | 2 Yes | 5 No |
How do I turn a list into a table?
What will happen after commit statement ?
Explain the savepoint statement.
What is record variable?
Is sqlite thread safe?
in table there r so many rows write a query which two rows r updated last two day befor?
What is the sql case statement?
how do you login to mysql using unix shell? : Sql dba
What is rtm stands for?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
Why plvtab is considered as the easiest way to access the pl/sql table?
What is the non-clustered index in sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
