Give the structure of the procedure ?
Answer / tulsi
PROCEDURE name (parameter list.....)
is
local variable declarations
BEGIN
Executable statements.
Exception.
exception handlers
end;
| Is This Answer Correct ? | 2 Yes | 1 No |
What is pls_integer in pl sql?
Is there any restriction on the use of union in embedded sql?
What is full join in sql?
While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?
What is a trigger in sql?
what are the advantages and disadvantages of views in a database? : Sql dba
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
Explain the rollback statement?
Is stored procedure faster than query?
What is user define exception and example
How many developers work on postgresql?
What are the differences between in and exists clause?
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)