전체 글164 오라클 SELECT ver3.0 CREATE OR REPLACE FUNCTION FN_DEV_SELECTSQL (tableName VARCHAR2, isComt VARCHAR2 DEFAULT 'Y', isTail VARCHAR2 DEFAULT 'A') RETURN VARCHAR2IS returnSql VARCHAR2(4000); enterStr VARCHAR2(4000); textHead VARCHAR2(4000); colName VARCHAR2(4000); colText VARCHAR2(4000); colType VARCHAR2(4000); inptText VARCHAR2(4000); tableText VARCHAR2(4000); whereText VARCHAR2(4000); .. 2025. 8. 25. 오라클 DELETE ver3.0 CREATE OR REPLACE FUNCTION FN_DEV_DELETESQL (tableName VARCHAR2) RETURN VARCHAR2IS returnSql VARCHAR2(4000); enterStr VARCHAR2(4000); textHead VARCHAR2(4000); colName VARCHAR2(4000); colText VARCHAR2(4000); colType VARCHAR2(4000); inptText VARCHAR2(4000); tableText VARCHAR2(4000); whereText VARCHAR2(4000); camelText VARCHAR2(4000);BEGIN enterStr := CHR(13) || .. 2025. 8. 25. 오라클 UPDATE ver3.0 CREATE OR REPLACE FUNCTION FN_DEV_UPDATESQL (tableName VARCHAR2, isComt VARCHAR2 DEFAULT 'Y', isTail VARCHAR2 DEFAULT 'A') RETURN VARCHAR2IS returnSql VARCHAR2(4000); enterStr VARCHAR2(4000); textHead VARCHAR2(4000); colName VARCHAR2(4000); colText VARCHAR2(4000); colType VARCHAR2(4000); inptText VARCHAR2(4000); tableText VARCHAR2(4000); whereText VARCHAR2(4000); .. 2025. 8. 25. 이전 1 2 3 4 ··· 55 다음