when do u go for hash partitioning?
Answer / sathish
when ever we retrive the data according to the name based
(data type varchar2 )
Is This Answer Correct ? | 0 Yes | 0 No |
How to assign values to data fields in record variables?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
After update how do u know how many records got updated
How to name query output columns in oracle?
SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
Is a rollback possible to any savepoint?
How to convert numbers to characters in oracle?
What is a trigger and what are its types?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
primary key is foreign key for the same table?
What are the oracle built-in data types?