How do you optimize a stored procedure query?
No Answer is Posted For this Question
Be the First to Post Answer
What is a constraint. Types of constraints ?
5 Answers Accenture, BirlaSoft,
How to get list of all tables from a database?
Which version of sql do I have?
What are sql ddl commands?
From an Employee table, how will you display the record which has a maximum salary?
29 Answers Cap Gemini, Exilant, Synechron,
How to get employee name from employee table which is the fiveth highest salary of the table
What is difference between procedure and trigger?
Why does sql need a server?
How to get the procedure's, function's name from a package if it is wrapped(both spec & body).
Is left join inner or outer?
Can we rollback delete command?
ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.
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)