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...

i can create a view with two columns from emp table,, later
i need to add one more emp column to existing view.. what is
query

similarly add one more column to existing primary key
constraint.. please give me the solutions

Answer Posted / deepu

ALTER VIEW = CREATE OR REPLACE VIEW

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the types of exception?

1139


What are the various oracle database objects?

1139


How to create a table interactively?

1078


What is a system tablespace and when it is created?

968


Explain the use of owner option in exp command.

1039


What is background process in Oracle?

1097


How to update values in a table in oracle?

1010


Can we write insert statement in function in oracle?

1077


In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2333


what is the difference between data migration and production migration.

2337


What happens if the update subquery returns multiple rows?

1110


What is the oracle implicit cursor?

1052


How to lock and unlock a user account in oracle?

1096


What do you mean by redo log file mirroring?

1022


Explain view?

1024