随笔分类 -  pgsql

摘要：方式一： 1 SELECT a.attnum, 2 a.attname AS field, 3 t.typname AS type, 4 a.attlen AS length, 5 a.atttypmod AS lengthvar, 6 a.attnotnull AS notnull, 7 b.de 阅读全文

摘要：1.普通打字符串值用当引号 例： V_DYN_SQL := 'SELECT EMP,DEPTNO,''xiaoli'' chenhu from emp'; 2.带字符串值的动态引号 例： v_chenhu = 'xiaoli'; V_DYN_SQL := 'SELECT EMP,DEPTNO, '' 阅读全文