Answer Posted / suresh ku patra

DECLARE
l_employee employees%ROWTYPE;
BEGIN
SELECT *
INTO l_employee
FROM employees
WHERE employee_id = 138;

DBMS_OUTPUT.put_line (
l_employee.last_name);
END;

What is type and rowtype in pl sql?

968

---

how can we destroy the cookie? : Sql dba

961

---

Is sql port 1433 encrypted?

974

---

What is dml statement?

902

---

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1066

---

how to include character strings in sql statements? : Sql dba

1001

---

How do I count duplicates in sql?

1033

---

What is a sql schema used for?

1031

---

What does sql stand for?

947

---

Are there any features that are decommissioned in 11g that are not present in 11g?

2069

---

how is exception handling handled in mysql? : Sql dba

1009

---

What is sql engine in oracle?

930

---

What is nvarchar in sql?

887

---

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

993

---

What is the default isolation level in sql server? : Transact sql

964

---