Why is partition used in sql?
No Answer is Posted For this Question
Be the First to Post Answer
Is sql a backend language?
What are analytic functions in sql?
What is sql basics?
What are the types of join and explain each?
Can a foreign key be a duplicate?
What are the basic sql commands?
How to prepare for oracle pl sql certification?
how to return query output in html format? : Sql dba
What are tuples in sql?
write a query find which rows of a table is updated on 2 days before?
What is mutating error in pl sql?
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....
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)