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 a primary key called that is made up of more than one field?

1282

---

Explain select statements in sql?

999

---

Does a primary key have to be a number?

915

---

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

985

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3944

---

What is multiple partition?

919

---

how to use in conditions? : Sql dba

958

---

explain the options of myisamchk to improve the performance of a table. : Sql dba

950

---

How to take user input in pl sql?

1105

---

How do I tune a sql query?

933

---

how to check server status with 'mysqladmin'? : Sql dba

1012

---

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

1014

---

Is mariadb nosql?

989

---

Are there any features that are decommissioned in 11g that are not present in 11g?

2066

---

Explain the purpose of %type and %rowtype data types?

875

---