describe transaction-safe table types in mysql : sql dba
No Answer is Posted For this Question
Be the First to Post Answer
What is dba in sql? : SQL DBA
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
How to select all records from the table?
Is there a way to automate sql execution from the command-line, batch job or shell script?
If the base table structure is changed what will happen to join index????
What are different types of sql?
What is t-sql? : Transact sql
What are the types of triggers 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....
what are the advantages of using stored procedures? : Sql dba
What type of database is sql?
What is ON DELETE CASCADE?
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)