Why we use pl sql?
No Answer is Posted For this Question
Be the First to Post Answer
Can we use views in stored procedure?
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 an extent ? : Sql dba
Is it possible for a table to have more than one foreign key?
How to create an array in pl/sql?
How One can easily select all even, odd, or Nth rows from a table using SQL queries?
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.
What are its different types of dbms?
Which data type is a composite type?
What are the different types of tables in sql?
What does count (*) mean in sql?
What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.
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)