Latest Answer: Tablespace : A tablespace is a logical structure on a Oracle database consisting of one or more datafiles. The objects are stored in a tablespace.Clusters: When two or more tables have a requirements of a same column and data in that column also is the ...
Latest Answer: char(size) max size upto 2000 min 1varchar2(size) max upto 4000 min 1 ...
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. ...
View page << Previous 2 3 4 5 [6] 7 8 9 Next >>
Go Top
