Which is better trigger or stored procedure?
No Answer is Posted For this Question
Be the First to Post Answer
What is a mutating table
Difference between inline query and stored procedure?
what is query cache in mysql? : Sql dba
How do you handle exceptions. Give the syntax for it?
What is pl sql block structure?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
What are sql functions? Describe in brief different types of sql functions?
Explain Connect by Prior?
What are the Diff B/W Cursor and REF Cursor
What is #table in sql?
How do I view a sql trace file?
How do I sort a table 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)