Interested to Buy Any Domain ? << Click Here >> for more details...
How are Indexes Update ?
- 1 Answers
- 5299 Views
- I also Faced
- E-Mail Answers
Answer / orawhiz
Indexes are automatically maintained and used by ORACLE.
Changes to table data are automatically incorporated into
all relevant indexes.
| Is This Answer Correct ? | 4 Yes | 2 No |
How to compare dates in oracle sql?
Explain the use of full option in exp command.
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
Explain the use of indexes option in imp command.
How to create additional tablespaces for an new database?
What is clusters ?
What is the difference between 10g OEM and 11g OEM?
How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10
Explain what does a control file contain?
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
How to write an inner join with the where clause in oracle?
What are the ansi data types supported in oracle?
Oracle General 
