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 the difference between function, procedure and package in pl/sql?

569

Is it possible for a table to have more than one foreign key?

589

How many developers work on postgresql?

574

Describe types of sql statements?

552

Is sql easier than java?

536

Do we need to create index on primary key?

473

What is a clob in sql?

575

Where do we use pl sql?

558

What is relationship? How many types of relationship are there?

599

How can we link a sql database to an existing android app?

552

What is a natural join sql?

519

What is pl sql in oracle?

594

What is trigger in pl sql?

568

Which type of cursor is used to execute the dml statement?

540

Is sql better than excel?

524