Basic oracle questions. - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Basic oracle questions.

Basic oracle questions.# Database - 数据库

s*s2005-04-11 07:04

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*r2005-04-11 07:04

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.