Answer Posted / hari k

set serveroutput on;
declare
cursor c1 is select substr(name1,1,1) from tab1;
v_string tab1.name1%type;
begin
open c1;
loop
fetch c1 into v_string ;
exit when c1%notfound;
dbms_output.put_line(v_string);
end loop;
end;

What is primary key and foreign key?

717

---

Why select is used in sql?

691

---

How can triggers be used for the table auditing?

753

---

What is a left inner join?

709

---

What is an exception in pl/sql?

725

---

---

How many rows can sqlite handle?

780

---

What does the file extension accdb stand for?

707

---

How many unique keys can a table have?

738

---

Define sql delete statement.

744

---

what is a tablespace? : Sql dba

766

---

explain access control lists. : Sql dba

716

---

How to create an array in pl/sql?

771

---

What is the difference between function, procedure and package in pl/sql?

763

---

What is application trigger?

733

---

What is compute?

734

---