Answer Posted / rajesh venati

For SQL:-

SELECT SUBSTR(ENAME,1,1) FROM EMP;
--------------------------------------------------------------
For PL-SQL:-

DECLARE
CURSOR ECUR IS SELECT SUBSTR(ENAME,1,1) FROM EMP;
BEGIN
FOR V_ECUR IN ECUR LOOP
DBMS_OUTPUT.PUT_LINE(V_ECUR.ENAME);
END LOOP;
END;

How do you modify a column in sql?

975

---

What is a record in pl/sql?

1124

---

how do you login to mysql using unix shell? : Sql dba

1068

---

What is sql server and ase?

1006

---

Is subquery faster than join?

999

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1568

---

What programs use sql?

980

---

How do I run sql?

1148

---

What are sql ddl commands?

1073

---

Is it possible to update views?

946

---

what is the difference between a local and a global temporary table? : Sql dba

1045

---

Explain what is dbms?

1038

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

1058

---

Which join is like inner join?

1005

---

Does sql view stored data?

936

---