Answer Posted / ajit nayak

DECLARE
V_NAME VARCHAR2(9);
V_LEN NUMBER;
V_POS VARCHAR2(10) := NULL;
BEGIN
V_NAME := '&ENTERNAME';
FOR I IN 1..LENGTH(V_NAME)
LOOP
V_POS := SUBSTR(V_NAME,I,1);
DBMS_OUTPUT.PUT_LINE(V_POS||CHR(10));
END LOOP;
END;

How to create a stored procedure in oracle?

573

---

How to create a testing table in oracle?

543

---

Explain database link?

660

---

How many types of cluster table in Oracle?

571

---

what is difference between sql plus and sql*plus? (not sql and sql plus).

3342

---

---

Explain oracle insert into command?

626

---

How to use existing values in update statements using oracle?

545

---

How to estimate disk space needed for an export job?

558

---

What is a trace file and how is it created in oracle?

548

---

Can we insert data in view oracle?

531

---

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1579

---

How to filter out duplications in the returning rows using oracle?

635

---

How to define a record variable to store a table row?

575

---

what is Single Byte Overhead...?

2058

---

What is the data pump import utility?

577

---