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 a sub query?how will you calculate working days in a month using sub query?
what is a primary key? : Sql dba
What is the maximum number of triggers,can apply to a single table?
How does cross join work in sql?
Which constraints we can use while creating database in sql?
What is cursor in pl sql?
Explain what is rdbms?
How many scalar data types are supported in pl/sql?
What operators deal with null?
Is trigger a stored procedure?
How do you run a query?
what are the authentication modes in sql server? : Sql dba
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)