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;

How do I view a table in sql?

1009

---

Why partition by is used in sql?

1042

---

How to run sql statements with oracle sql developer?

1070

---

What is difference between db2 and sql?

1002

---

How to process query result in pl/sql?

1129

---

how to add a new column to an existing table in mysql? : Sql dba

1073

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2016

---

Explain the working of primary key?

1098

---

How do I access sql anywhere database?

970

---

Explain the uses of database trigger.

1115

---

What is the difference between union and union all command?

1091

---

What is memory optimized?

1088

---

What are pl/sql cursors?

1050

---

What is triggering circuit?

1067

---

Explian rowid, rownum? What are the psoducolumns we have?

1002

---