Answer Posted / ramu

select top(100) salary from table1 where salary not
in(select top(99) salary from table1)

Can pl sql procedure have a return statement?

1025

---

define sql insert statement ? : Sql dba

1019

---

What are the ddl commands?

1005

---

Define implicit and explicit cursors.

1140

---

Explain ttitle and btitle.

1116

---

What is a scalar value in sql?

1070

---

How do you modify a column in sql?

992

---

Which is faster view or stored procedure?

940

---

What is record type in pl sql?

984

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1201

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1116

---

Is sql a backend language?

1090

---

Can we create view in stored procedure?

955

---

how to convert character strings to numeric values? : Sql dba

1102

---

Explain exception handling in pl/sql?

1033

---