select * from tabe_name partition (partition

How to fetch records from a partitioned table?

Question Posted / nitinsharma06

Answer Posted / nitinsharma06

select * from tabe_name partition (partition_name );

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between jpql and sql?

1102

What are the benefits of pl/sql packages?

1109

what are wild cards used in database for pattern matching ? : Sql dba

1150

What is function and procedure?

1038

What are the parts of a sql statement?

1097

What are types of joins?

969

What is a join?

1076

What is the difference between truncate and drop statements?

1198

What is sqlerrd?

971

Can we join 3 tables in sql?

1053

How do I add a database to sql?

1135

What does seeding a database mean?

975

What is the difference between partitioning and sharding?

1015

How does stored procedure reduce network traffic?

1017

What is sql integrity?

1165