how to include character strings in sql statements? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
Is sql easier than java?
How to add Foreign key in a table after the creation of the table?
Which data dictionary views have the information on the triggers that are available in the database?
What is trigger in pl sql with examples?
what is a database transaction? : Sql dba
What is a pdo connection?
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....
How do I tune a sql query?
what is the sql query to display current date? : Sql dba
pl/sql testing means what ...... explain process how to find pl/sql bugs
What is pivot query?
How do I find duplicates in sql?
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)