Explain the differences between cost-based optimizer and Rule-based optimizer ? Why DB2, Sybase is cost based and SQL, Oracle are Rule Based Optimisers ?
List all the employees who have atleast one person reporting to themList the employee details if and only if more than 10 employees are presently in department 10
Latest Answer: The DUAL table is owned by the user SYS and can be accessed by all users. It contains one column, DUMMY, and one row with the value X. The DUAL table is useful when you want to return a value once only: for instance, the value of a constant, pseudocolumn, ...
Latest Answer: Reverse -key index is index that reverse the data of the being indexed column. For example if the column value contains LOVELY, the reverse-key index will be YLEVOL.This index very much useful where users issues the select command with where clause such ...
Latest Answer: We can't select next value and current value from views. ...
Latest Answer: desc table_name ...
Latest Answer: here CNT is a column name SELECT CNT FROM table_nameWHERE MOD(CNT,CNT) = 0AND MOD(CNT,2) != 0AND MOD(CNT,3) != 0AND MOD(CNT,5) != 0AND MOD(CNT,7) != 0AND MOD(SQRT(CNT),ROUND(SQRT(CNT))) != 0ORDER BY CNT ...
What is Local Index and Global Index in Partition Table?What is Prefix Index and Nonprefix Index in table?
Latest Answer: subquery allowed that depends on no of values returned by sub queryyes :-) ...
What is output of this SQL where current value of sequence is 3?Select seq.curval,seq.Nextval,seq.Nextval from dual ? Give reason?
View page << Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>
Go Top
