Find all employees in Dept “Marketing”.
Answers were Sorted based on User's Feedback
Answer / guneetinder singh
select ename from emp where deptname = 'Marketing'
ename = employee name.
deptname= department name
Is This Answer Correct ? | 4 Yes | 0 No |
How to create a new view in oracle?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What is Undo Management Advisor in Oracle?
Why cursor variables are easier to use than cursors?
What do you mean by merge in oracle and how can you merge two tables?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How to end the current transaction in oracle?
Describe the types of sub query?
How to invoke the data pump import utility?
what is unique key?
14 Answers Amazon, Cap Gemini, Infosys, Wipro,
How to define a sub function?
How many categories of data types?