select * from tabe_name partition (partition

How to fetch records from a partitioned table?

Question Posted / nitinsharma06

Answer Posted / nitinsharma06

select * from tabe_name partition (partition_name );

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

discuss about myisam key cache. : Sql dba

569

How to assign sql query results to pl sql variables?

517

What operating systems are supported by oracle sql developer?

530

How can I tell if sql is running?

596

How to connect a sql*plus session to an oracle server?

627

How to install oracle sql developer?

579

what is the difference between sql and t-sql? : Transact sql

613

explain advantages of myisam over innodb? : Sql dba

611

how to create a test table in your mysql server? : Sql dba

504

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3116

Is foreign key mandatory?

563

Explain what is a subquery ?

663

What is sql*loader and what is it used for? : aql loader

628

what is blob? : Sql dba

564

What are different clauses used in sql?

598