How to fetch records from a partitioned table?

Answers were Sorted based on User's Feedback



How to fetch records from a partitioned table?..

Answer / nitinsharma06

select * from tabe_name partition (partition_name );

Is This Answer Correct ?    3 Yes 0 No

How to fetch records from a partitioned table?..

Answer / santosh kumar

SELECT * FROM TABLENAME PARTITION(PMONHTYEAR)
EX:

SELECT * FROM SALARY PARTITION(P0315)

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Is hadoop a nosql?

0 Answers  


Mention what is the plv (pl/vision) package offers?

0 Answers  


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?

3 Answers  


How to add new employee details in an employee_details table with the following details

0 Answers  






what is global temporary tables and how use that tables in pl/sql packages

1 Answers   Cap Gemini,


can sql servers linked to other servers like oracle? : Sql dba

0 Answers  


What are database links used for?

0 Answers  


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.....

8 Answers  


what is bdb (berkeleydb)? : Sql dba

0 Answers  


What is sqlca in db2?

0 Answers  


How does one use sql*loader to load images, sound clips and documents? : aql loader

0 Answers  


Categories