Answer / nitinsharma06

select * from tabe_name partition (partition_name );

Answer / santosh kumar

SELECT * FROM TABLENAME PARTITION(PMONHTYEAR)
EX:

SELECT * FROM SALARY PARTITION(P0315)

What is fmtonly in sql?

1 Answers  

---

What does t sql mean?

1 Answers  

---

Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 Answers  

---

Can we use commit inside a trigger?

1 Answers  

---

What is rtm stands for?

1 Answers  

---

Why triggers are used?

1 Answers  

---

What is example of database?

1 Answers  

---

Which language is used in sql?

1 Answers  

---

what is difference b/w pravite procedures and public procedures?

3 Answers   Steria, Wipro, Zensar,

---

How is Oracle 10g helpful when compared to oracle 9i and what is grid computing

1 Answers   Flextronics,

---

What is autocommit sql?

1 Answers  

---

explain primary keys and auto increment fields in mysql : sql dba

1 Answers  

---