SELECT * FROM TABLENAME PARTITION(PMONHTYEAR) EX: SELECT * FROM SALARY

How to fetch records from a partitioned table?

Question Posted / santosh kumar

Answer Posted / santosh kumar

SELECT * FROM TABLENAME PARTITION(PMONHTYEAR)
EX:

SELECT * FROM SALARY PARTITION(P0315)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a delimiter in sas?

1049

What are the possible values that can be stored in a boolean data field?

996

How do I turn a list into a table?

955

What is percent sign in sql?

1281

What do you mean by rowid?

975

Are subqueries faster than joins?

1014

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1094

How do I view tables in sql developer?

934

What are expressions?

1002

What does <> sql mean?

1078

What is sql data?

987

How to create a menu in sqlplus or pl/sql?

1117

How many types of literals are available in pl sql?

1110

how to create a new table in mysql? : Sql dba

983

What is data type in database?

986