How do you optimize a query?
No Answer is Posted For this Question
Be the First to Post Answer
write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh
Explain Connect by Prior?
How many types of cursors are available in pl/sql?
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.
Whis is not false in primary key?
Can you rollback after commit?
what is msql? : Sql dba
What is dynamic SQl and how you will create and execute dynamic sql?
What is the meaning of disabling a trigger?
how many tables will create when we create table, what are they? : Sql dba
How to disable a trigger name update_salary?
Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..
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)