What is a call statement? Explain with an example.
No Answer is Posted For this Question
Be the First to Post Answer
Can we use the cursor's to create the collection in PL/SQL?
What are sql built in functions?
Explain the advantages and disadvantages of stored procedure?
How do I remove sql developer from windows 10?
How many types of triggers exist in pl/sql?
Can we use delete in merge statement?
Show the two pl/sql cursor exceptions.
What is percent sign in sql?
Which data type is a composite type?
Which function is used to return remainder in a division operator in sql?
What is Collation Sensitivity ? What are the various type ?
How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.
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)