본문 바로가기

개발하자

 (326)
top,blank,self aa.html ============================== bb.html ============================== top //현재창에 화면이 뜸 blank //새로운 윈도우창 self //현재 프레임이 바뀌는것 프레임명 //f2프레임에 화면이 뜸
프레임 나누기 aa.html ================== bb.html ================ bb.html문서입니다.
링크이동 검색엔진 네이버 야후 다음 네이버입니다. TOP 야후입니다. TOP 다음입니다. TOP
링크 연결1 http://www.naver.com">연결1 > 연결2
html 리스트 aa bb cc
최대값과 최소값 제외한 평균,총합 구하기(GREATEST,LEAST) WITH TE AS ( SELECT '9' A, '7' B, '1' C, '5' D, '4' E, '6' F, '7' G, '4' H FROM DUAL UNION ALL SELECT '1' A, '7' B, '8' C, '7' D, '4' E, '3' F, '9' G, '2' H FROM DUAL UNION ALL SELECT '5' A, '9' B, '5' C, '6' D, '6' E, '6' F, '5' G, '5' H FROM DUAL UNION ALL SELECT '9' A, '7' B, '4' C, '2' D, '2' E, '7' F, '3' G, '3' H FROM DUAL UNION ALL SELECT '1' A, '8' B, '3' C, '6' D, '9' E, '5' F, '7' G, '..
문자만 자르기(정규식함수 사용-REGEXP_SUBSTR) WITH T ( P_CODE , P_NM ) AS ( SELECT 'P0001', '사과(SP)' FROM DUAL UNION ALL SELECT 'P0002', '파인애플 1200*900' FROM DUAL UNION ALL SELECT 'P0003', '바나나 CL-100' FROM DUAL UNION ALL SELECT 'P0004', '오렌지ECE' FROM DUAL UNION ALL SELECT 'P0005', '참외 ZG' FROM DUAL )select * from t; sol) WITH T ( P_CODE , P_NM ) AS ( SELECT 'P0001', '사과(SP)' FROM DUAL UNION ALL SELECT 'P0002', '파인애플 1200*900' FROM DUAL UNI..
컬럼 가로세로 바꾸기 with my_table as( SELECT MAX(GUBUN) GUBUN, MAX(M) M, MAX(M2) M2, MAX(DIV) DIV, MAX(PER) PER FROM ( SELECT '멋쟁이' GUBUN, '' M, '' M2, '' DIV, '' PER FROM DUAL UNION ALL SELECT '' GUBUN, '3630' M, '' M2, '' DIV, '' PER FROM DUAL UNION ALL SELECT '' GUBUN, '' M, '2847' M2, '' DIV, '' PER FROM DUAL UNION ALL SELECT '' GUBUN, '' M, '' M2, '783' DIV, '' PER FROM DUAL UNION ALL SELECT '' GUBUN, '' M, ''..

티스토리툴바