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 / gayathri
Alter table tablename ADD(columnname (data_type) notnull)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is %s in sql?
How do I run pl sql in sql developer?
What are triggers in sql?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
Can procedure in package be overloaded?
What is the maximum number of columns in sql table?
What does truncate mean in sql?
How many joins can you have in sql?
What is the difference between explicit and implicit cursors in oracle?
what is a trigger in mysql? Define different types of trigger. : Sql dba
What is the starting oracle error number? What is meant by forward declaration in functions?
what is schema? : Sql dba
How do I view a view in sql?
What are the 3 types of behavioral triggers?
What found sql?