How to fetch records from a partitioned table?
Answers were Sorted based on User's Feedback
select * from tabe_name partition (partition_name );
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / santosh kumar
SELECT * FROM TABLENAME PARTITION(PMONHTYEAR)
EX:
SELECT * FROM SALARY PARTITION(P0315)
Is This Answer Correct ? | 1 Yes | 0 No |
Is hadoop a nosql?
Mention what is the plv (pl/vision) package offers?
i want to display 1 to 10 numbers using one select statement.
18 Answers HCL, Nyros, Oracle,
How to fetch the rows by dynamicaly passing table name through cursor?
How to add new employee details in an employee_details table with the following details
what is global temporary tables and how use that tables in pl/sql packages
can sql servers linked to other servers like oracle? : Sql dba
What are database links used for?
i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....
what is bdb (berkeleydb)? : Sql dba
What is sqlca in db2?
How does one use sql*loader to load images, sound clips and documents? : aql loader