114

数据库对象:表,视图,索引,序列(基础1)-mb5a534461afa8e的博客-51CTO博客

 6 years ago
source link: http://blog.51cto.com/13566874/2069093
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
创建表:CREATETABLEemployee_xxx(idNUMBER(4),nameVARCHAR2(20),genderCHAR(1),birthDATE,salaryNUMBER(6,2),jobVARCHAR2(30),deptnoNUMBER(2))查看表结构DESCemployee删除表:DROPTABLEemployeeSQL语句是不区分大小写的,但是字符串的值(直接量)是区分大小

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK