Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax of ALTER command?
- 8 Answers
- 13762 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sridevi
alter table <table name> modify (columnname newdatatype
(size))
| Is This Answer Correct ? | 18 Yes | 4 No |
Answer / sridevi
alter table <tablename> add column(col.name(size))
| Is This Answer Correct ? | 17 Yes | 8 No |
Answer / rajini
alter table tablename add(colname datatype,colname1
datatype...);
alter table tablename modify(colname datatype,colname1
datatype..);
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / guest
alter table tablename add(col1 datatype,col2 datatype...);
alter table tablenamemodify(col1 datatype,col2 datatype..);
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / guest
alter table <table name> modify(column definition...);
alter table <table name> add(column definitions...);
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / suri
alter table tablename add(colname datatype,colname1
datatype...);
alter table tablename modify(colname datatype,colname1
datatype..);
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / sandeep
alter table <table_name> add column <Data type of the column>;
| Is This Answer Correct ? | 2 Yes | 3 No |
How to use "startup" command to start default instance?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6
What is background process in Oracle?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL
write a query that displays every Friday in a year with date?
how to i write the query 'NISHI' TO N I S H I
4 Answers Attra, Metric Stream,
Explain what are synonyms used for?
Can we create index on views?
19 Answers CTS, Syntel, TCS,
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
How to create a server parameter file?
How to create index-by table in oracle?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Oracle General 
