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 tables in sql?

1120

Why is %isopen always false for an implicit cursor?

1153

what happens if null values are involved in expressions? : Sql dba

1093

Does access use sql?

1101

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1175

What is a subquery in sql?

1091

Why do we use function in pl sql?

1114

what is a record in a database ? : Sql dba

1105

How do I run a sql query?

1083

What view means?

1025

What is an inner join sql?

1099

Explain what is table in a database?

1110

How do you update sql?

1039

How do I make my sql query run faster?

1018

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2613