What are the types of variable use in pl sql?
What is trigger point?
What is data abstraction in sql?
What are the two types of exceptions.
What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?
how to retrieve the top 2 salaried persons from a database?
Does truncate table reset auto increment?
oracle is compiler or interpretter,can any one tell me the answer?
How do you update a sql procedure?
IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????
how to include comments in sql statements? : Sql dba
how to check the 3rd max salary from an employee table?
Is delete faster than truncate?