|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions 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? ... How to check intact, state of a particular index, what are the impacts of invalid index? How to recover it? Read Answers (1) | Asked by : reddy 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. ... 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 : select * from user_indexes where status ='Invalid'you can specify index_name in the same query to look for a particular INDEX. ... 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? Read Answers (6) | Asked by : DEBPROSAD BANERJEE Provide names of classes that are used in database connection using Oracle,Access database, and MSDE Provide names of classes that are used in database connection using Oracle,Access database, and MSDE View Question | Asked by : Annitta Latest Answer : Index are reference to data in tables's columns on what they are based. Index work exactly in way like we have book's index describing its chapters and what page # chapter can be found.They only contain reference to the data. There are two types on ... Read Answers (1) | Asked by : Iniyavan Explain how Oracle 9i offers a comprehensive high performance infrastructure for e-business. What infrastructure here means? View Question | Asked by : raj
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
