logo
Redian新闻
>未名空间
>Database - 数据库
>
Basic oracle questions.
avatar
Basic oracle questions.# Database - 数据库
s*s
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.
avatar
l*r
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.
avatar
c*d
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 ;
相关阅读
www.boobooke.com 里面有大量数据库教学视频，免费观看和下载Access Security Problemshould all category/subcategory name be different in a database?HELP: 如何实现 一个简单的QueryDoes T-SQL have bit shift function?DB jobs急问：如何恢复被删除的数据？请教关于下面这个sql code地解释请推荐一下书什么数据库中文支持比较好啊有没有简便的方法把mdb的表头列出来？select 跟 set 的区别？请问isolation level "read comitted"和"serializable"的区别。oracle database rollback问题Pls recommend some freeware for exporting database from oracle to mysqlquestion about import xml to sql tableMySQL concat 使用一问Access question. Pls help.ThxAny ways to recover oracle user password?我也问一个sql querry的问题
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章，不代表同意其说法或描述，仅为提供更多信息，也不构成任何建议。文章信息的合法性及真实性由其作者负责，与Redian.news及其运营公司无关。欢迎投稿，如发现稿件侵权，或作者不愿在本网发表文章，请版权拥有者通知本网处理。