1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

How to fetch records from a partitioned table?

Question Posted / dev

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

what is data integrity? : Sql dba

0 Answers  

how to start mysql server? : Sql dba

0 Answers  

what is unique key constraint? : Sql dba

0 Answers  

How to look at the current sql*plus system settings?

0 Answers  

I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On

6 Answers   DELL, HCL, Oracle,




what is meant by databases

4 Answers  

what are all the different types of indexes? : Sql dba

0 Answers  

How do you define a foreign key?

0 Answers  

How do I run a pl sql program?

0 Answers  

What are the advantages of normalization?

0 Answers  

can we use out parameter in a function?Give an example.

4 Answers   Logica CMG, TCS,

Why sql query is slow?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories