Sign Up Login


  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 nested table in pl sql?

0 Answers  

What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

1 Answers  

explain the difference between delete , truncate and drop commands? : Sql dba

0 Answers  

How to create your own reports in sql developer?

0 Answers  

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

0 Answers  




Do foreign keys improve performance?

0 Answers  

How is use pl and sql?

0 Answers  

What is scalar function in sql?

0 Answers  

What is difference between Procedures and Functions ?

6 Answers   Hi Caliber IT,

How does sql store data?

0 Answers  

..........refers to the disk mirroring

2 Answers   iFlex,

How do I run sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories