How can multiply values of a column? OR How can multiply value
of a row of a column using a single query in SQL?
Answer / amit shukla
SELECT EXP (SUM (LN (COLUMN_NAME) FROM TABLE.
| Is This Answer Correct ? | 3 Yes | 5 No |
Differentiate between pl/sql and sql?
Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?
wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010
What is the basic structure of PL/SQL ?
What is rtm stands for?
What is the file extension for sql database?
What is the use of nvl function?
write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35
Why procedure is used in sql?
what are the advantages of cursors than procedures?
Write a query to find the names of users that begin with "um" in sql?
what are %TYPE and %ROWTYPE? what is the difference?
7 Answers ICICI, Saama Tech, Sail,
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)