Interested to Buy Any Domain ? << Click Here >> for more details...
Fetch an entire row from the employees table for a specific
employee ID:
- 2 Answers
- 5279 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
select * from employees where employee_id='1381';
| Is This Answer Correct ? | 4 Yes | 0 No |
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;
| Is This Answer Correct ? | 3 Yes | 2 No |
Can we use ddl statements in stored procedure?
Is sql open source?
What is parameter substitution in sql?
What is the use of count (*) in sql?
How does stored procedure reduce network traffic?
Is sql similar to python?
Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?
Is mariadb a nosql database?
Can we create clustered index without primary key?
What is snowflake sql?
find the third highest salary?
How do you take the union of two tables in sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
