Answer / eshwer

select * from emp where TO_CHAR(hiredate,'Q')=3;

'Q' Regrives the all the 4 quarters(1,2,3,4) details on
that we retrive the 3 quarter details

Please check it

Answer / rupesh kumar

select * from emp where rownum<=(select round((count(*)/4)
*3) from emp)
minus
select * from emp where rownum<=(select round((count(*)/4)
*2) from emp)

What are database links used for?

0 Answers  

---

define sql update statement ? : Sql dba

0 Answers  

---

need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 Answers  

---

What is %type in sql?

0 Answers  

---

can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?

2 Answers   Fujitsu,

---

What are sql triggers used for?

0 Answers  

---

How many types of relationship are there?

0 Answers  

---

what is HASH join?

2 Answers   Genpact, HCL,

---

Is sql a case sensitive language?

0 Answers  

---

What is not in sql?

0 Answers  

---

Explain the order of sql statement execution?

0 Answers  

---

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

---