What is sql profiling in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
What is Difference Between delete and Truncate?
what is oracle database ? : Sql dba
What is group by in sql?
what is the main difference between join and subqurey?
When do we use triggers?
What is trigger explain it?
How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id
How do you create an update query?
What is a sql*loader control file?
What is a call statement? Explain with an example.
What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.
What is the need of a partition key?