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 is myisam table stored? : Sql dba

1099


how tsql statements can be written and submitted to the database engine? : Transact sql

1037


Which command is used to call a stored procedure?

1055


what are the 'mysql' command line options? : Sql dba

1137


What is sql deadlock?

1221


What is procedure in pl sql?

1092


Which table is left in left join?

1067


Can we use ddl commands in pl sql?

1235


What is sap sql?

1030


Does truncate free space?

1067


what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1129


How do you delete duplicates in sql query using rowid?

989


What is sql and how does it work?

1252


What is the purpose of my sql?

1016


What is trigger in pl sql?

1052