Why is there a need for sqlcode and sqlerrm variables?
No Answer is Posted For this Question
Be the First to Post Answer
If we update a complex view, is base table will get update ?
2 Answers Ardee Technologies, HCL,
What is the cause of mutating table error and how can we solve it?
what is the stuff function and how does it differ from the replace function? : Sql dba
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 can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
what is inline command?
How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).
What is data control language?
What is sqlcommand?
What is hibernate and its relation to sql?
Can a commit statement be executed as part of a trigger?
how to run 'mysql' commands from a batch file? : Sql dba