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.

Show how functions and procedures are called in a pl/sql block.

1041

---

What is audit logout in sql profiler?

977

---

Explain character-manipulation functions?

1067

---

What is rank () in sql?

882

---

explain the advantages and disadvantages of stored procedure? : Sql dba

956

---

What is cartesian join in sql?

1028

---

Why use stored procedures?

1018

---

What do you understand by pl/sql packages?

1018

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

988

---

Which is the correct statement about truncate and delete?

1034

---

What is oracle pl sql developer?

933

---

Explain the purpose of %type and %rowtype data types with the example?

926

---

what is an index? : Sql dba

930

---

What is function and procedure?

984

---

How do I save a sql query?

961

---