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;

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

Do prepared statements prevent sql injection?

0 Answers  

---

What is materialized view in sql?

0 Answers  

---

What is a column in a table?

0 Answers  

---

What is nosql vs sql?

0 Answers  

---

i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???

3 Answers   Scope International,

---

Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index

2 Answers   Polaris,

---

What is the difference between view and stored procedure?

0 Answers  

---

How can u find column name from a table which have max value in a row.( not max value)

5 Answers  

---

how can stop the sequence with mention the max value and with out mention the max value

1 Answers   Zensar,

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

0 Answers  

---

What is an alias command?

0 Answers  

---