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 t sql in sql server?
How to return multiple rows from the stored procedure?
In a distributed database system, can we execute two queries simultaneously?
What are packages in pl sql and also explain its advantages?
What are the different dcl commands in sql?
What is date functions?
What do you mean by table in sql?
using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.
what is unique key constraint? : Sql dba
Give the structure of the function ?
how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?
What is a merge query?
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)