What is the difference between functions, procedures, and packages in pl/sql?
No Answer is Posted For this Question
Be the First to Post Answer
What is rowtype?
explain the difference between delete , truncate and drop commands? : Sql dba
What are sql functions? Describe in brief different types of sql functions?
What is the difference between python and sql?
A table has 150 records. How do you retrieve 100th row to 120th row from that table ?
what is a stored procedure? : Sql dba
what is sql? : Sql dba
Show how functions and procedures are called in a pl/sql block.
Store procedure will return a value?
declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?
How do I kill a query in postgresql?
Show code of a cursor for loop.
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)