how do you tune the slow running queries in oracle db , explain the methodology
No Answer is Posted For this Question
Be the First to Post Answer
what is a cursor? : Sql dba
difference between table level constraint and column level and advantages of table level constraint
What are the default Oracle triggers??
What is parallel hint?
What are keys in sql?
Which sql most popular?
Explain what is sql*plus?
What's the procedure?
Can a view be mutating? If yes, then how?
Explain the usage of WHERE CURRENT OF clause in cursors ?
how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?
How to take user input in pl sql?
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)