What is sql profiling in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between in and between in sql?
i have some prob lem to tell me about my self in interview first round ...
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.
what is the syntax used for partition in tsql? : Transact sql
Why do you partition data?
How can you know that statistics should be updated?
How many types of tables are there?
what is bcp? When is it used?
What are inner and outer joins examples of both?
How to set up sql*plus output format in oracle?
What is Temp Table and type of temp table?
i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75
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)