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 are variables in pl sql?

1173

what is query cache in mysql? : Sql dba

1044

Does sql support programming?

1076

What is the trigger in sql?

966

Define SQL and state the differences between SQL and other conventional programming Languages?

1226

what are date and time intervals? : Sql dba

1065

Does mysql_real_escape_string prevent sql injection?

956

What is a schema sql?

1161

Can primary key be changed?

913

What are sql injection vulnerabilities?

989

what are the different type of sql's statements ? : Sql dba

929

Why do we go for stored procedures?

1065

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1102

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1032

Can sql developer connect to db2?

1058