-
-
-
-
SQL and PLSQL
What is the difference between SQL & PLSQL?
-
Maximum PK's and PI's
How many Primary keys and Primary Indexes can we create on a table.How many Foreign keys and Secondary indexes can we create on a table.How many maximum columns can we create in a table
-
Average Department Salary
How to Get the employee details whose salary is less than the average salary of the department.
-
ALTER Row
We are UPDATING a field in SQL and ALTER the row also. After giving the COMMIT command the system is crashed. What will happen to the commands given, whether it will UPDATE and ALTER the table or not?
-
Replace Alternate Character in a String
SQL query to replace every alternate character in a string to capital.
Input string:- govardhana
I need output as gOvArDhAnA
And vice versa i.e, GOVARDHANA and required output as GoVaRdHaNa
Provide 2 separate queries for above scenarios
-
There is a string 120000 12 0 .125 , how you will find the position of the decimal place?
INSTR('120000 12 0 .125',1,'.')output 13
-
-
-
Which datatype is used for storing graphics and images?
LONG RAW data type is used for storing BLOB's (binary large objects).
-
-
-
-
-
-
-
-
Oracle SQL Interview Questions
Ans