오라클클럽 게시글 SQL 이쁘게 등록하는 법.
SQL문을 포맷에 맞게(이쁘게) 등록하려면 Code() 버튼을 클릭하여 SQL문장을 작성 하시면 됩니다.
라고...
위에 나와 있는 설명대로 하면 들여쓰기가 깨져서 보입니다.
원인 분석 결과 공백 두칸(' ')이 한칸(' ')으로 바뀌어 저장되더라구요.
오라클클럽 게시글 SQL 이쁘게 등록하는 법.
1. 텍스트 에디터 프로그램을 연다.(노○패드, 워○패드, 울○라에디트, 아○로에디트, 에디트플○스 등)
2. SQL문장을 이쁘게 작성하신 뒤
3. SQL문장을 전체 바꾸기를 한다 (공백한칸 ==> 공백두칸)
4. 위에서 설명한 방법대로 태그를 추가하고 등록
SQL 뿐 아니라 실행계획등 줄맞춰 들여쓰기가 중요한 코드에 적용 가능함.
import java.sql.*; public class JEdb{ static Connection con = null; static{ try{ String url = "jdbc:edb://localhost:5444/edb"; String usr = "edb"; String pwd = "password"; Class.forName("com.edb.Driver"); con = DriverManager.getConnection(url, usr, pwd); }catch(Exception exp){ exp.printStackTrace(); } } public static void main(String argv[]) throws Exception{ try{ Statement stat = con.createStatement(); ResultSet rs = stat.executeQuery("SELECT EMPNO,ENAME,JOB,MGR,HIREDATE FROM EMP"); while(rs.next()){} stat.close(); conn.close(); }catch(Exception e){ System.out.println(e); } } }
empno ename job mgr hiredate ===== ===== ===== ===== ===== 7369 SMITH CLERK 7902 1980-12-17 7499 ALLEN SALESMAN 7698 1981-02-20 7521 WARD SALESMAN 7698 1981-02-22 7566 JONES MANAGER 7839 1981-04-02 7654 MARTIN SALESMAN 7698 1981-09-28 7698 BLAKE MANAGER 7839 1981-05-01 7782 CLARK MANAGER 7839 1981-06-09 7788 SCOTT ANALYST 7566 1987-04-19 7839 KING PRESIDENT 0 1981-11-17 7844 TURNER SALESMAN 7698 1981-09-08 7876 ADAMS CLERK 7788 1987-05-23 7900 JAMES CLERK 7698 1981-12-03 7902 FORD ANALYST 7566 1981-12-03 7934 MILLER CLERK 7782 1982-01-23
import java.sql.*; public class JdbcTest { public static void main(String argv[]) throws Exception{ String url = "jdbc:oracle:thin:@localhost:1521:orcl"; String usr = “scott"; String pwd = "welcome"; Class.forName("oracle.jdbc.driver.OracleDriver"); try { Connection conn = DriverManager.getConnection(url,usr,pwd); Statement stat = conn.createStatement(); ResultSet rs = stat.executeQuery("select * from student"); while(rs.next()){} stat.close(); conn.close(); } catch (Exception e){ System.out.println(e); } } }
import java.sql.*; public class JEdb { static Connection con = null; static{ try{ String url = “jdbc:edb://localhost:5444/edb”; String usr = “edb”; String pwd = “edb”; con = DriverManager.getConnection(url, usr, pwd); Class.forName(“com.edb.Driver”); }catch(Exception exp){ exp.printStackTrace(); } } public static void main(String argv[]) throws Exception{ try { Statement stat = con.createStatement(); ResultSet rs = stat.executeQuery("select * from student"); while(rs.next()){} stat.close(); conn.close(); } catch (Exception e){ System.out.println(e); } } }
create procedure set_password(username character varying) as typ integer := DBMS_CRYPTO.DES_CBC_PKCS5; key raw(128) := ‘my secret key’; iv raw(100) := ‘my initialization vector’; encrypted raw(2048); cleartext bytea; begin select ciphertext into cleartext from passwords where principal = username; encrypted := dbms_crypto.encrypt(cleartext, typ, key, iv); update passwords set ciphertext = encrypted where principal = username; end;
create function get_password(username varchar2) return raw as typ INTEGER := DBMS_CRYPTO.DES_CBC_PKCS5; key RAW(128) := ‘my secret key’; iv RAW(100) := ‘my initialization vector’; password RAW(2048); BEGIN select ciphertext into password from passwords where principal = username; return dbms_crypto.decrypt(password, typ, key, iv); END;