What are packages in pl sql and also explain its advantages?
No Answer is Posted For this Question
Be the First to Post Answer
Why does sql need a server?
What are the packages in pl sql?
Explain the update statement in sql
Which table is left in left join?
Write a query to display the current date in sql?
Do we need to rebuild index after truncate?
what is rdbms? : Sql dba
how can we destroy the cookie? : Sql dba
What are the types of operators available in sql?
The select into statement is most often used to create backup copies of tables or for archiving records?
What is update query?
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
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)