Answer / suresh ramsing

select * from employees where employee_id='1381';

Answer / 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 are all the different normalizations? : Sql dba

0 Answers  

---

How do I run a pl sql program?

0 Answers  

---

what is an index? : Sql dba

0 Answers  

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

0 Answers  

---

what are the authentication modes in sql server? : Sql dba

0 Answers  

---

What is row_number () in sql?

0 Answers  

---

What is write ahead logging in sql server?

0 Answers  

---

how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 6

4 Answers   Hexaware,

---

what are the security recommendations while using mysql? : Sql dba

0 Answers  

---

What is a constraint. Types of constraints ?

5 Answers   Accenture, BirlaSoft,

---

How do I audit the sql sent to the server?

0 Answers  

---

What is the function that is used to transfer a pl/sql table log to a database table?

0 Answers  

---