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

Difference between truncate, delete and drop commands?

730

What are the types of optimization?

688

Is drop table faster than truncate?

740

what is a database lock ? : Sql dba

781

What is cross join example?

736

How do I run a pl sql procedure in sql developer?

691

What is parameter substitution in sql?

752

what is the difference between cluster and non cluster index? : Sql dba

730

What is loop in pl sql?

762

how is myisam table stored? : Sql dba

782

How do you break a loop in pl sql?

727

Is there a way to automate sql execution from the command-line, batch job or shell script?

746

What are different types of queries in sql?

732

What do you think about pl/sql?

701

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1156