Answer / nitinsharma06

select * from tabe_name partition (partition_name );

Answer / santosh kumar

SELECT * FROM TABLENAME PARTITION(PMONHTYEAR)
EX:

SELECT * FROM SALARY PARTITION(P0315)

select 10 from dual; y its showing all the rows with 10?

1 Answers  

---

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

4 Answers   KPIT,

---

Which command is used to delete a package?

0 Answers  

---

What are the types of queries in sql?

0 Answers  

---

write a query to find 4th max salary

7 Answers  

---

What is scope of pl sql developer in future?

0 Answers  

---

What does the file extension accdb stand for?

0 Answers  

---

What is the difference between a primary key and a unique key?

0 Answers  

---

Write a procedure to return the month and the number of developers joined in each month (cursor )

2 Answers   Tech Mahindra,

---

What is primary key and foreign key with example?

0 Answers  

---

select 1,col1,col2 from table1. output?

5 Answers   Ramco,

---