what is a trigger in mysql? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
is it necessary to write group by and order by clause together
What is transaction control language (tcl)?
I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman
Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy
how to sort records in sql?
What is difference between pl and sql?
What type of join is sql join?
How can analyze query after generating explain plan ?
Is it possible to update views?
Can we use ddl statements in stored procedure?
What is the difference between row level and statement level trigger?
What is difference between % ROWTYPE and TYPE RECORD ?