Explain the purpose of %type and %rowtype data types with the example?
No Answer is Posted For this Question
Be the First to Post Answer
what is a cursor? : Sql dba
Can a table contain multiple foreign key’s?
In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop
what is self join and what is the requirement of self join? : Sql dba
What is Difference between StoredProcedure and function?
what is schema? : Sql dba
What is the limitation on the block size of pl/sql?
Why functions are used in sql?
i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject
How does rowid help in running a query faster?
what is Complex index. how to create it?
what is indexing, searching and user interface?
Oracle (3253)
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)