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

How many types of tables supported by oracle?

1118


How can we find out the current date and time in oracle?

1129


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

1136


Is primary key indexed by default in oracle?

1046


Is it possible to insert comments into sql statements return in the data model editor ?

2635


How to create a single index for multiple columns?

1078


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

1141


What is the quickest way to fetch the data from a table?

1100


State the difference between a primary key and foreign key?

994


What is a read only transaction in oracle?

1078


Explain the function of optimizer in oracle?

1196


How to assign a table row to a record variable?

1090


What is columnar storage what is the advantage?

1119


How to define a cusotmer as a supplier in ORACLE R12

2301


What is oracle sid?

999