s****s
发帖数: 42 | 1 I have already created several tables in Oracle.
How to display what tables I created?
What does command line look like?
How to change a column name if I found a typo after I created a table?
Thanks. |
l***r
发帖数: 459 | 2
select table_name from user_tables;
alter table drop column ;
alter table add ;
【在 s****s 的大作中提到】
: I have already created several tables in Oracle.
: How to display what tables I created?
: What does command line look like?
: How to change a column name if I found a typo after I created a table?
: Thanks.
|
c*****d
发帖数: 6045 | 3
in oracle latest version (maybe 9i), you can use
alter table rename column to
【在 l***r 的大作中提到】
:
: select table_name from user_tables;
: alter table drop column ;
: alter table add ;
|
