Answer Posted / murali

Answers given above are correct except one

For PL-SQL:-

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

Note: column alias name must be given.

how to concatenate two character strings? : Sql dba

550

---

What port does sql server use?

504

---

What are the types of queries in sql?

516

---

What is primary key sql?

538

---

How does one load ebcdic data? : aql loader

643

---

---

What is a primary key called that is made up of more than one field?

789

---

Why do we create stored procedures & functions in pl/sql and how are they different?

500

---

Is sql port 1433 encrypted?

572

---

How do I order by ascending in sql?

535

---

What are the popular database management systems in the it industry?

561

---

explain what is mysql? : Sql dba

598

---

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

1063

---

how many columns can be used for creating index? : Sql dba

516

---

How many times can we commit in a loop?

564

---

What is normalization sql?

509

---