How do you copy a table in sql?
No Answer is Posted For this Question
Be the First to Post Answer
which will default fire first statement level trigger or row level trigger
2 Answers Cap Gemini, Data Vision,
What are the two types of cursors in pl sql?
Explain the the update statement in sql?
How to read/write files from pl/sql?
What is the unique index?
What is the difference between microsoft access and sql server?
What is trigger and how to use it in sql?
how to present a past time in hours, minutes and seconds? : Sql dba
What can I use instead of union in 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....
How do you write an index?
What is rtm stands for?
Oracle (3253)
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)