| Other SQL PLSQL Interview Questions |
|| Asked @
|What does “select count(1) from tab” result?
|after tell procedure whole code he asked can i write the
same way in a function
|how to insert values like 10:10:00,30:25:00 etc.into table
after insert how can i sum the above insert values to get
the result as 40:35:00
|consider a table which contain 4 columns,ename,eno,sal and
deptno, from this table i want to know ename who having
maximum salary in deptno 10 and 20.
|How to execute OS(operating system) command from pl/sql?
|using subquery how can i calculate working days in a month?
|take one table is t1 and in that column name is f1
f1 column values are
i want display the values asc and desc in a single output.
sample output is
and f1.d is
|what is the differnce between procedure and function?
in both dml operations can work and in procedure through out
parameter you can return value ,then what is the differce?
|what is d diff between grant,commit,rollback n savepoint
|what is the different between unique+not null & primary key,
|How the execution will be done in exceptions?
sql gurus, here is my question 4 u.
i wanna use triggers for sending reminder mail to all users
who are registered to the site. if any one knws the code plz
send me ans here : firstname.lastname@example.org
|For more SQL PLSQL Interview Questions Click Here |