Interested to Buy Any Domain ? << Click Here >> for more details...
What does “select count(*) from tab” result?
- 15 Answers
- 29081 Views
- IBM, Student, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shivashanker
it will display the total number of tables in the schema.
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / amit kumar jaswal
display count of all rows from relation
| Is This Answer Correct ? | 3 Yes | 7 No |
Answer / kamal kishore kashyap
display all the table which are currently in the schema.
| Is This Answer Correct ? | 0 Yes | 6 No |
Difference between IN and EXISTS
Difference between table function and pipelined function?
How insert into statements in sql?
How does cross join work in sql?
How to get the procedure's, function's name from a package if it is wrapped(both spec & body).
Explain constraints in sql?
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
Can we commit in trigger?
What are the different set operators available in sql?
How is Oracle 10g helpful when compared to oracle 9i and what is grid computing
What is pl sql block structure?
-
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)
