select 10 from dual; y its showing all the rows with 10?
Answer / honey
1.
As we know that Implicitly Cursor 'SQL' is opened.
when it is pin pointing the 1st row in the dual, cursor
found that one record exists.
2.
since there are no conditions (i.e., where,group by,..),
directly 'select' clause will be executed.
3.
Internally Oracle identifies numbers, so 10 number will be
displayed.
Is This Answer Correct ? | 1 Yes | 3 No |
Does truncate need commit?
What are the different tcl commands in sql?
Explain unique key in sql.
Which is faster view or stored procedure?
How can check sql version from command line?
What is the trigger in sql?
How delete a row in sql?
What do we need to check in database testing?
declare v_count number(8,3); 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); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; 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 regards..sarao....
Is progress software supports to ( pl/sql )?
Can we rollback truncate?
what are the different tables present in mysql? : Sql dba