Answer / vsubbaiah

Select Distinct |fields * | from table name
where condition
group by column list
having grouped column
order by column

Answer / poovitha

select * from employee

Here,
employee refers "TABLE NAME"
* refers all records in the table

Answer / chandiran

select <column name> from <table name>

Answer / sarika

select * from tablename;

Answer / shree

select field1,field2,.........field n
from table nane

Answer / mohammed ashfaq

SELECT attr1,attr2..attrn
FROM TABLE1,TABLE2..TABLEn;
(IT IS SIMPLE SELECT)
(FOR COMPLEX SELECT)
SELECT attr1,attr2..attrn
FROM TABLE1,TABLE2..TABLEn
WHERE CONDITION;

Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?

1 Answers   IBM,

What happens to the current transaction if the session is killed?

0 Answers  

What exactly do quotation marks around the table name do?

0 Answers  

what is the uses of cusor

3 Answers   Perot Systems,

What is Hash Index?

1 Answers  

What is Trigger in Oracle?

0 Answers   MCN Solutions,

What is a Tablespace?

5 Answers  

i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table

3 Answers  

When do I need to use a semicolon vs a slash in oracle sql?

0 Answers  

Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL

1 Answers  

Is primary key = unique key,not null? If yes,please explain IF No,please explain

8 Answers   Genpact,

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

0 Answers   eicc,