How many types of index are there?
No Answer is Posted For this Question
Be the First to Post Answer
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.
what is definer rights invoke rights?
What is clause?
What is %type in pl sql?
What is the difference between SQL table and the PLSQL table?
Do we need commit after truncate?
What is execute immediate?
How many unique keys can a table have?
How to use distinct and count in sql query? Explain
Why schema is used in sql?
How to select all records from the table?
Write a sql select query that only returns each name only once from a table?
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)