Answer / kart

select * from table where id is not null;

Answer / sumit

select id,name from table where id is not null;

Answer / ajit nayak

Delete from <tab_name>
where id is null;

how to extract a unit value from a date and time? : Sql dba

0 Answers  

---

I want to know the difference between A Record Type and a Table.

3 Answers   Thermotech,

---

how to install mysql? : Sql dba

0 Answers  

---

what is self join and how it works??

2 Answers   Infosys,

---

we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?

3 Answers   TCS,

---

---

What are pl sql data types?

0 Answers  

---

What is rowtype?

0 Answers  

---

How to execute OS(operating system) command from pl/sql?

3 Answers  

---

Why is stored procedure faster than query?

0 Answers  

---

What is insert command in sql?

0 Answers  

---

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

---

why we use nocopy?

2 Answers   Polaris,

---