1) Synonyms
2) Co-related Subquery
3) Different Jobs in Plsql
4) Explain Plan
5) Wrap
6) Query Optimization Technique
7) Bulk Collect
8) Types of index
9) IF primary key is created then the index created ?
10) Foreign Key
11) Exception Handling
12) Difference Between Delete and Trunc
13) Procedure Overloading
14) Grant Revoke
15) Procedure Argument types.
16) Functions.
17) Joins
explain advantages of myisam over innodb? : Sql dba
how to get enames with comma seperated values by deptwise on emp table?
What is bitemporal narrowing?
What is the difference between drop and truncate commands?
need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
What is the left table in sql?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
What are the different operators available in sql?
What is view? Can we update view
What are aggregate functions in sql?
What are the three pl sql block types?
Does google use sql?