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

Why left join is used in sql?

1015

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1049

What language is oracle sql developer?

1069

What is sql prepared statement?

1032

How do I run a script in sql developer?

995

How is pl sql different from sql?

1140

What is procedure and function?

1033

What is not null in sql?

1106

What is varchar used for?

1133

What does sign mean sql?

1177

What is the difference between a primary key and a unique key?

1101

What do you understand by pl/sql records?

1059

Is stored procedure faster than query?

1016

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

999

What do you mean by stored procedures? How do we use it?

1035