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 difference between my sql and sql?
What is an exception in PL/SQL? What are the two types of exceptions?
How to add a column ‘salary’ to a table employee_details?
What company owns postgresql?
What is type and rowtype in pl sql?
How can you know that statistics should be updated?
What is recursive join in sql?
Can we use pl sql in sql server?
What is the most restrictive isolation level? : Transact sql
I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman
how many tupples can insert in 1 second in sql
What is sql injection vulnerability?
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)