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 |
without using count(*) and rownum how can we count total record in a table
What language does oracle use?
How do I recompile a procedure in oracle?
What is a Sequence ?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables
Is a rollback possible to any savepoint?
How to login to the server without an instance?
why dont we assign not null constraint as table level constraint.
How to define an anonymous block?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
State some uses of redo log files?