-
Maximum Limit for IN Operator
What is the maximum limit for IN operator on SQL?
-
NOCOPY mode
What is the purpose of NOCOPY mode in procedures?
-
Additional Conditions
How will you add additional conditions in SQL?
-
Enlarge Work Area Size
How to enlarge the size of work area in iSQL*plus?
-
SQL Buffer
Which command displays the SQL command in the SQL buffer, and then executes it?
-
How can you retrieve the random records from the table?
Hi Friends, One table having some many records but I want to retrieve under little-bit records randomly. If it is possible in SQL then send the reply ? So, I will wait for ur valuable answer...
Performance Tuning
What is mean by Performance Tuning? Explain with example.
How to validate a column, which takes only number and character value?
Is there any datatype in oracle to check whether a inserting value is at least a numeric and a character?
Need to find the list of employees who is from Finance department having 1200 pincode
Employee table has : Emp.Name, Emp.ID, Dep.ID & Location ID
Department Table has: Dep.ID, Dep. Name
Location table has: Location ID & Location Pincode
Need to find the list of employees who is from Finance department having 1200 pincodeIf we are creating trigger of delete type or update type than when the trigger will execute after delete or after update?
I dont knowplz give the ans. through my email
Ans