oracle SELECT COLUMN = DEFAULT_VALUE

 

 

 

 

 

 

 

SELECT data_default FROM user_tab_columns WHERE table_name ='TEST222' AND column_name = 'CODE'


CREATE TABLE "ZWF"."TEST222" 
   (	"CODE" VARCHAR2(100) default 20, 
	"NAME" VARCHAR2(100)
   );

INSERT INTO test222 VALUES('005129', 'zengwenfeng');
INSERT INTO test222 (name) VALUES('zengwenfeng111');

SELECT * FROM test222;

SELECT * FROM TEST222 WHERE code = (SELECT LONG_TO_CHAR('TEST222', 'CODE') FROM dual);

LONG_TO_CHAR   存储过程连接如下：

https://blog.csdn.net/spencer_tseng/article/details/110194610

 

我和师傅们做过的产品清单：

https://blog.csdn.net/spencer_tseng/category_7157384.html

 

 

做做笔记，不费心。缺省查询默认值问题。