Answer / nitinsharma06

select * from tabe_name partition (partition_name );

Answer / santosh kumar

SELECT * FROM TABLENAME PARTITION(PMONHTYEAR)
EX:

SELECT * FROM SALARY PARTITION(P0315)

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  

---

What is the location of pre_defined_functions.

0 Answers  

---

Can we use having without group by in sql?

0 Answers  

---

Can %notfound return null after a fetch?

0 Answers  

---

Define SQL and state the differences between SQL and other conventional programming Languages?

0 Answers  

---

---

What are the different sql languages?

0 Answers  

---

What is bind reference and how can it be created?

0 Answers  

---

What is left join in sql?

0 Answers  

---

What are basic techniques of indexing?

0 Answers  

---

Types of cursors and explanation each of them ?

4 Answers   DELL,

---

What is the maximum number of triggers,can apply to a single table?

2 Answers  

---

Are sql database names case sensitive?

0 Answers  

---