| Other SQL PLSQL Interview Questions |
|| Asked @
|what is the difference between implicit and explicit trigger
|How to call the function and Procedure in trigger?
|Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.
|Interchange the value of a column Gender in a table where
values are Male and Female. So, where the value is Male, it
should changed to Female and Female to Male.
|Where the Pre_defined_exceptions are stored ?
|Which one of the following is a reason that an INSERT
statement might cause an error instead of executing
1. The INSERT statement was attempting to insert a record
into a view that was created from more than one table.
2. The INSERT statement was attempting to insert a record
using a combination of constants and values from an
3. The INSERT statement was attempting to insert a record
with a non-NULL value into a table that has that column
defined as NULL.
4. The INSERT statement was attempting to insert a record
into a table by selecting a record from that same table.
5. The INSERT statement was attempting to insert a record
into a view rather than a table.
|select 1,col1,col2 from table1. output?
|Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)
|What will be the output for the below Query
Select 'High' from dual where null = null;
|suppose we have values like 1 5 7 in a colum.Now we want
numbers like(2 3 4 6) that exists between 1 5 7.How can we
do this using sql query??
|Main diff between varray and nested tablea
|What are the types of SQL Statement?
|For more SQL PLSQL Interview Questions Click Here |