Answer Posted / 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

Why is %isopen always false for an implicit cursor?

1086

---

What are the possible values that can be stored in a boolean data field?

984

---

What are the different types of triggers?

1116

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1074

---

What are the different operators available in sql?

987

---

what are the difference between clustered and a non-clustered index? : Sql dba

1013

---

How exception handling is done in advance pl/sql?

965

---

How does an execution block start and end in pl sql?

927

---

What is data abstraction in sql?

1011

---

What is integrity in sql?

1023

---

What is over () in sql?

931

---

Can we connect to postgresql using sql developer?

982

---

What is data modelling in sql?

1002

---

what are all the common sql function? : Sql dba

1045

---

Is pl sql different from sql?

968

---