Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
No Answer is Posted For this Question
Be the First to Post Answer
Which is faster view or stored procedure?
What is the syntax and use of the coalesce function?
How to get the 3rd column(i.e all the data along with the column name)in a table?
If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)
What is rowtype?
How do I debug a stored procedure?
what is bcp? When does it used? : Sql dba
What does (+) mean in sql joins?
How to trace the errors in pl/sql block code?
What is sql dialect?
I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu
How do I know if I have sql express or standard?
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)