Why stored procedures are faster than query?
No Answer is Posted For this Question
Be the First to Post Answer
How to fetch the rows by dynamicaly passing table name through cursor?
Does view contain data?
What is the purpose of the partition table?
need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
what is the use of HASH, LIST partitions?
what is the difference between delete and truncate commands? : Sql dba
I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?
Why trigger is used in sql?
If we have n no of columns in a table, can we add new column in that table with not null constraint?
Can you sum a count in sql?
What is relationship? How many types of relationship are there?
Can you select everything, but 1 or 2 fields, without writer's cramp?
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)