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 |
How we can update the view?
What is the Difference between Procedure and Function.Can we call a Function in a DML?
What do you think about pl/sql?
Why does sql need a server?
mail-id table contains two columns(email_id,userid) it contains different types of mail-ids,and no of users. here username length is differ na,(ex- tamil@yahoo.com,joshua@hotmail.com like) now i want to fetch the email-ids only starting from '@' (ex-@gmail.com,@yahoo.com,@hotmail.com
what is sql optimization
What is vector point function?
What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.
What is not null in sql?
how can you create an empty table from an existing table? : Sql dba
How many types of keys are there in sql?
Explain the rollback statement?
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)