Answer Posted / guneetinder singh
select ename from emp where deptname = 'Marketing'
ename = employee name.
deptname= department name
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How do I recompile a procedure in oracle?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How to create a new tablespace in oracle?
What is an oracle and why it is used?
What is Trigger in Oracle?
What is the difference between PFILE and SPFILE in Oracle?
What are the different editions of oracle?
How would you change old and new values in an insert, delete and update triggers?
Explain the function of optimizer in oracle?
Where do you use decode and case statements?
What is the difference between substr and instr?
What is an oracle user account?
Can we connect to ORACLE db using Windows Authentication?
What is a select query statement in oracle?
How can we create the complete backup of data in the oracle.