What do you understand by exception handling in pl/sql?
What is lexical units in pl sql?
How many types of primary keys are there?
What are the sql commands?
Why schema is used in sql?
Why do we use joins?
What pl/sql package consists of?
Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F
What is query execution plan in sql?
In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;
What is view explain with example?
Can you have multiple SPs with the same name on a database?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba