Which is better stored procedure or query?
No Answer is Posted For this Question
Be the First to Post Answer
Explain the rollback statement?
How many types of privileges are available in sql?
Why do we create stored procedures & functions in pl/sql and how are they different?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
Explain the purpose of %type and %rowtype data types with the example?
HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.
What is scalar function?
What are different types of functions in sql?
SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows
What is record type in pl sql?
What is sql indexing?
what is meant by nl2br()? : Sql dba
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)