Answer Posted / suneelkumar

Hi guys..

rownum is virtual column we con't use max(rownum) i t will
give the error unknown colum...

so by using cursor we can count

What are the constraints available in sql?

995

---

What is time based sql injection?

901

---

Can a varchar be a primary key?

953

---

How can we make an if statement within a select statement?

958

---

what is a database lock ? : Sql dba

1092

---

How long does it take to learn pl sql?

1000

---

What is the difference between subquery and correlated query?

989

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

3925

---

Explain the select statement in sql?

1044

---

What is an example of translating a date into julian format?

1038

---

how to shut down the server with 'mysqladmin'? : Sql dba

955

---

how does a local variable is defined using t-sql? : Transact sql

948

---

Do ddl statements need commit?

922

---

How show all rows in sql?

974

---

What is foreign key and example?

886

---