Find all employees in Dept “Marketing”.

Answer Posted / anil

select * from table_name where dept='Marketing'

Is This Answer Correct ?    10 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to get maxsal , minsal, ename department wise in single query

1134


What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

746


can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2684


what happened to the global index when I truncate the data in one of the partition?

1598


What is an oracle database table?

669






How to shutdown your 10g xe server from command line?

644


What is a proxy object?

667


Can we store images in oracle database?

645


How to define a variable to match a table column data type?

651


What are the differences between char and nchar in oracle?

683


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.

2043


What is an Oracle Instance?

765


What do you mean by merge in oracle and how can you merge two tables?

601


Why does Oracle not permit the use of PCTUSED with indexes?

2041


how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1610