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

How many types of keys are there in sql?

1039


Which is better stored procedure or query?

957


What is the use of %rowtype?

1041


What is a data definition language?

1133


Which software is used for pl sql programming?

990


What is case function?

1042


Which join is like inner join?

1028


Which one is better subquery or joins?

1062


Which certification is best for sql?

990


What is scalar function?

1054


Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1227


What is a primary key sql?

1044


how can we repair a mysql table? : Sql dba

981


What is localdb mssqllocaldb?

1068


What are the benefits of triggers?

1172