oracle数据库
一浅笑
初来乍到,请多关照
展开
-
ORACLE设置自增ID ,序列【最简单版】
创建序列:CREATE sequence 序列名 minvalue 1 maxvalue 9999999999999999999999999999 start with 2 increment by 2 cache 20 order;引用:ALTER TABLE 表名MODIFY ("ID" DEFAULT "序列名".nextval )...原创 2020-04-29 17:26:20 · 2702 阅读 · 1 评论 -
ORACLE 查询库下的所有表以及表中字段的详细信息
SELECT t1.Table_Name || chr(13) || t3.comments AS "表名称及说明", ROWNUM , t1.Column_Name AS "字段名称", t1.DATA_TYPE AS "数据类型", t1.DATA_LENGTH AS "长度", t1.NullAble AS "是否为空"...原创 2020-04-29 17:14:10 · 556 阅读 · 0 评论