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 have one table and column is c1 pk, c2 not null,c3 not
null and 200 row in it and i add c4 column and value, how
can is possible

Answer Posted / asraf

ALTER TABLE DUMMY1 ADD (C4 VARCHAR2(100) DEFAULT 0)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a call statement? Explain with an example.

996


Explain the uses of control file.

1041


how to select first 5 records from a table? : Sql dba

967


What are reports usually used for?

1017


how to use 'mysql' to run sql statements? : Sql dba

1040


How do I write a sql query in pgadmin 4?

968


Write a sql select query that only returns each name only once from a table?

1003


What is the difference between the conventional and direct path loader? : aql loader

1146


1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1589


Can you load data into multiple tables at once? : aql loader

1062


How does sql developer connect to oracle database?

991


what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

954


what is the difference between a local and a global temporary table? : Sql dba

1060


How does cross join work in sql?

1007


how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

964