not set

출처 : http://302.pe.kr/379 Oracle SQL Developer- Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Oracle Database. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling sol..

SELECT BIZ_ID , MIN(DECODE(RN, 1, PROD_MAIN_IMG)) AS IMG1 , MIN(DECODE(RN, 1, PROD_NM)) AS PROD_NM1 , MIN(DECODE(RN, 2, PROD_MAIN_IMG)) AS IMG2 , MIN(DECODE(RN, 2, PROD_NM)) AS PROD_NM2 , MIN(DECODE(RN, 3, PROD_MAIN_IMG)) AS IMG3 , MIN(DECODE(RN, 3, PROD_NM)) AS PROD_NM3 , MIN(DECODE(RN, 4, PROD_MAIN_IMG)) AS IMG4 , MIN(DECODE(RN, 4, PROD_NM)) AS PROD_NM4 , MIN(DECODE(RN, 5, PROD_MAIN_IMG)) AS I..

MERGE INTO TK2_PROD_TEST X USING ( SELECT PROD_ID , ADMIT_STT FROM TK2_PROD_20130630 WHERE UPD_DT < TO_DATE('20080101','YYYYMMDD') AND ADMIT_STT = '1' ) A ON (A.PROD_ID = X.PROD_ID) WHEN MATCHED THEN UPDATE SET X.ADMIT_STT = A.ADMIT_STT

UPDATE VOB_CUST_QNA X SET (X.DEF_RCV_PERNM) = ( SELECT A.DEF_RCV_PERNM FROM ( SELECT A.PK , A.ANS_NM AS DEF_RCV_PERNM FROM PRUNET_CUS_QNA A WHERE A.RCV_WINDOW = 'AS신청' AND A.ANS_NM IS NOT NULL ) A WHERE A.PK = X.DEF_QNA_SEQ ) WHERE X.DOC_CLS = '30' -- AND EXISTS ( SELECT 1 FROM ( SELECT A.PK FROM PRUNET_CUS_QNA A WHERE A.RCV_WINDOW = 'AS신청' AND A.ANS_NM IS NOT NULL ) Y WHERE Y.PK = X.DEF_QNA_SEQ..

--자신이 가진 테이블 권한 SELECT * FROM USER_TAB_PRIVS_RECD; --자신이 가진 객체 권한 select * from user_role_privs; --자신이 볼수 있는 테이블 목록 SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE='TABLE'; --자신에게 권한이 있는 모든 테이블SELECT table_name FROM ALL_tables ORDER BY TABLE_NAME;

프로시져를 PL-SQL 툴(오렌지,토드 등의 디자이너에서도) 아래와 같은 에러가 날때가 있다.분명 파라미터 갯수도 맞고 타입도 잘 맞는데 자꾸 end-of-file 을 만났다며 실행 자체가 안될경우에는 프로시져 실행시 주석을 없애자 아래와 같은 짜증나는 에러 메시지가 계속 나온다. 2012/09/25 15:29:47 >ORA-06550: 줄 7, 열10:PLS-00103: 심볼 "SP_XXXXXXXXXXXXXXXXXXXXXXX"를 만났습니다 다음 중 하나가 기대될 때: := . ( @ % ; immediate심볼이 ":=" 계속하기 위하여 " SP_XXXXXXXXXXXXXXXXXXXXXXX "로 치환되었습니다ORA-06550: 줄 16, 열3:PLS-00103: 심볼 "end-of-file"를 만났습니다..