Explian rowid, rownum? What are the psoducolumns we have?
No Answer is Posted For this Question
Be the First to Post Answer
how many columns can be used for creating index? : Sql dba
What are the subsets of sql?
What is sql query limit?
What is a unique key and primary key and foreign key?
Can we use join in subquery?
Can we create index on primary key?
what is a composite key ? : Sql dba
Explain spool.
what is global temporary tables and how use that tables in pl/sql packages
What type of database is cloud sql?
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
What are types of exception?
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)