| Other SQL PLSQL Interview Questions |
|| Asked @
|Can we relate two different tables from two different users
|| ||4 |
|if we give update table_name set column_name= default.
what will happen?
its given in pl sql block.what will hapen?
|Which one of the following pairs of aggregate functions do
you use with character fields?
1. COUNT(field) and MAX(field)
2. AVG(field) and COUNT(field)
3. MIN(field) and SUM(field)
4. AVG(field) and MAX(field)
5. COUNT(field) and SUM(field)
|what is autonomouse transaction?
|Types of optimization?
|Types of joins?
|What cursor type do you use to retrieve multiple recordsets?
v_sal scott.emp.sal%type := '&P_sal';
cursor cur_name is select sal from scott.emp where sal
between (v_sal-100) and (v_sal +1000);
v_count :=nvl(sql%rowcount ,0);
if v_count = 0 then
dbms_output.put_line('no records are fetch in the given sal
dbms_output.put_line('There is/are '||to_char(v_count)||
' salaries are selected in the given range ');
in the above programm .....for any sal range ....always it
shows the following message..
no records are fetch in the given sal range
please find the mistake and share with me...with thansk and
|what is the difference between implicit conversions and
|| ||2 |
|What is the difference between SQL and PLSQL
|How to get the 3rd column(i.e all the data along with the
column name)in a table?
|What is the difference between sql/pl-sql/embeded sql?
|| ||3 |
|For more SQL PLSQL Interview Questions Click Here |