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;

what are the default admin accounts in Oracle 10g ?

1024

---

Explain about integrity constraint?

1181

---

What are dml statements in oracle?

1132

---

Please explain drop constraint oracle?

1160

---

What is merge statement used for?

1076

---

In oracle there is column command, how will you explain that?

1140

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

2058

---

What are the differences between primary key and unique key?

1065

---

What are the ansi data types supported in oracle?

992

---

How to concatenate two text values in oracle?

1159

---

What is null value in oracle?

1161

---

How to lock and unlock a user account in oracle?

1163

---

Can we use bind variables in oracle stored procedure?

987

---

How to rebuild an index in oracle?

1070

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2374

---