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 tables for odbc connection testing?

1087

---

How view is different from a table?

1017

---

Can we write insert statement in function in oracle?

1070

---

Explain the use of analyse option in exp command.

1110

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2237

---

What is oracle analytical function?

1111

---

How to convert characters to times in oracle?

1004

---

What are the different pseudo commands? Explain in general?

1058

---

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

1006

---

What is a cursor and what are the steps need to be taken?

1184

---

How to display employee records who gets more salary than the average salary in the department?

1039

---

Explain the use of rows option in exp command.

1070

---

Explain rename?

959

---

What is integrity and what is constraint??Explain with example

2258

---

What is enter substitution variable in oracle?

1028

---