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
What is a call statement? Explain with an example.
Explain the uses of control file.
how to select first 5 records from a table? : Sql dba
What are reports usually used for?
how to use 'mysql' to run sql statements? : Sql dba
How do I write a sql query in pgadmin 4?
Write a sql select query that only returns each name only once from a table?
What is the difference between the conventional and direct path loader? : aql loader
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
Can you load data into multiple tables at once? : aql loader
How does sql developer connect to oracle database?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
what is the difference between a local and a global temporary table? : Sql dba
How does cross join work in sql?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba