Tell me the diffrences between oracle 8 and oracle 8i versions. wat are the features added in 8i version. thank u
Latest Answer: When you try to execute procedure from procedure just write procedure name. If you are executing from SQL*Plus them write EXEC Thanks, Shailu ...
1. Queris for Nth maximum Nth row?2. In One table there are 5 fields. empno, ename, deptcd, managr_id, salary.Select the departments whoose sum of the salary greater than the sum of salaries of any department?3. When index will be usd in the Query?
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. ...
View page << Previous 1 2 3 4 [5] 6 7 Next >>

Go Top