How to fetch records from a partitioned table?

Question Posted / dev

2 Answers
6827 Views
HSBC, I also Faced
E-Mail Answers

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

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

5 Answers Target,

How to find string or key value using pl/sql code?

2 Answers Ramco,

What is a subquery in sql?

0 Answers

How to read xml file in oracle pl sql?

0 Answers

What are different types of sql commands?

0 Answers

What are the packages in pl sql?

0 Answers

If the base table structure is changed what will happen to join index????