Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

When we give SELECT * FROM EMP; How does oracle respond?

Answer Posted / suresh

it will check for emp table(available or not).
1.if emp table available then it will retreive all the
colums from emp table..
2.if it is not available then it will give error..

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by stored procedures?

953


How do you remove duplicate records from a table?

887


Can we connect to postgresql using sql developer?

937


Is it possible to create startup or shutdown trigger for on-schema?

981


Can we use join in subquery?

1022


What is sql clause?

995


How do rank () and dense_rank () differ?

977


What is PL/SQL Records?

1116


How to get each name only once from an employee table?

1064


Why do we need pl sql?

937


What is oracle pl sql developer?

936


how can we optimize or increase the speed of a mysql select query? : Sql dba

889


Does sql*plus also have a pl/sql engine?

1039


what are the differences between char and varchar? : Sql dba

1004


what is the syntax used for partition in tsql? : Transact sql

960