Answer / krina

we can execute multiple sql statement inside the procedure

Answer / gourav joshi

hi,
For eg u want to insert 3 data at a same time so u can use
annonyoums block for eg emp_id,Name,Salary u want to insert
data in a table u can use this annoynomous blck

Begin
Insert into table name values(1, 'gourav',2000);
Insert into table name values(2, 'joshi',6000);
Insert into table name values(3, 'ram',4000);
end;

then execute

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

what is the command for user data type?

2 Answers  

---

How is a PL/SQL code compiled?

0 Answers  

---

how to create a table index in mysql? : Sql dba

0 Answers  

---

how can you create an empty table from an existing table? : Sql dba

0 Answers  

---

how to see the create table statement of an existing table? : Sql dba

0 Answers  

---

What does where 1 1 mean in sql?

0 Answers  

---

What is difference between sql and excel?

0 Answers  

---

What does the acronym acid stand for in database management?

0 Answers  

---

How do you create a db file?

0 Answers  

---

Why is pl sql needed?

0 Answers  

---

Is mariadb a nosql database?

0 Answers  

---