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
- 5337 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 |
How do you concatenate in sql?
What is foreign key in sql with example?
i have some prob lem to tell me about my self in interview first round ...
What is aggregate function in sql?
what is 'mysqlcheck'? : Sql dba
In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;
What is the use of desc in sql?
how do you know if your mysql server is alive? : Sql dba
Can you have multiple SPs with the same name on a database?
Does normalization improve performance?
How do I run a script in sql developer?
How do you drop a trigger?
-
Oracle (3253) - 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)
