How to check if a column is nullable before setting to nullable?
Why is partition used in sql?
i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What is the location of pre_defined_functions.
What does (+) mean in sql joins?
What is pl sql block in dbms?
need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
what are the different tables present in mysql? : Sql dba
Is json a nosql?
How does cross join work in sql?
What are different functions in sql?
Can procedure in a package be overloaded?