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

How to test for null values?

691

how to rename an existing column in a table? : Sql dba

593

when MSQL8.0 is in market

1680

what are the differences between binary and varbinary? : Sql dba

626

What is execute immediate?

634

What is oracle sql called?

587

What is null in pl/sql?

701

How is pl sql different from sql?

634

What are the two types of periodical indexes?

581

What is sql and db2?

622

Should I use mbr or gpt?

631

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

675

Which language is used in sql?

614

Explain unique key in sql.

651

What packages are available to pl/sql developers?

712