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
What is Data Dictionary Cache in Oracle?
How much memory your 10g xe server is using?
What is the usage of merge statement?
How to create a testing table in oracle?
How is it different from a normal table?
Where do we use decode and case statements?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
What are the varoius components of physical database structure of oracle database?
What is the difference between translate and replace in oracle?
Why does Oracle not permit the use of PCTUSED with indexes?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
State the various uses of dbcc command?
What is Reduced List of Values?
What is a nested table?