discuss about myisam index statistics collection. : Sql dba
what is the difference between implicit conversions and explicit conversions?
What is a CTE (Common Table Expression), and how is it different from a subquery?
How did you export data from database to excel file.
What are pl/sql cursors?
What are some predefined exceptions in pl/sql?
Name the operator which is used in the query for pattern matching?
What is the importance of sqlcode and sqlerrm?
Can you join views in sql?
What are the differences between Database Trigger and Integrity constraints ?
What is correlated sub-query?
Can we write ddl statements in functions?
suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??