Latest Answer: select from where mod(,2)0 ...
Latest Answer: select * from user_indexes where status ='Invalid'you can specify index_name in the same query to look for a particular INDEX. ...
Latest Answer: Index will only help you in searching the data but unique index will provide uniqueness to the indexed column. But in both the cases NULL values are allowed to insert. ...
Latest Answer: The ROLLUP is an extension to the GROUP BY caluse. the rollup operator can be used by report writes to extract statistics and summary information from results sets. the rollup operator creates groupings by moving in one directon, from right ot left, ...
Latest Answer: Snapshot and materialized view are almost same same but with one difference.You can say that materialized view =snapshot + query rewrite functionalityquery rewrite functionality:In materialized view you can enable or disable query rewrite option. ...
If we create a table having a column of BLOB data type then how we have to insert and retrieve the data?
Latest Answer: In the above code '-2' specifies that the only two digits before the decinmal points needs rounding up.and '+2' would mean two digits after the decimal point. ...
How to check intact, state of a particular index, what are the impacts of invalid index? How to recover it?
Give the count for each daemon when 150 sessions are connected to database provided only 200 concurrent sessions are allowed in that database ?
Latest Answer: hello dual is a table which is created by oracle along with the data dictionary. It consists of exactly one column whose name is dummy and one record. The value of that record is X. sql> desc dualName Null? ...
View page << Previous 2 3 4 5 [6] 7 8 Next >>
Go Top
