select '이쁜가요??' 
 from dual

SELECT test
  FROM t
 WHERE 1 = 1
   AND tcol = tcol

 
-- TEST 용 
SELECT * FROM DUAL
 WHERE 1 = 2
 AND 2 = 2

 
-- TEST 용 
SELECT * FROM DUAL
 WHERE 1 = 2
   AND 2 = 2

select '그렇군요' 
 from dual
where 1=1;

SELECT * 
FROM GLOBLA_NAME

select '행복하세요'
from dual
where 1 = 1

 select '안녕하세요' from dual 

 select '이렇게인가요?' from dual 

select '행복하세요'
from dual 
where 1 = 1

 
SELECT * 
FROM DUAL

select '감사합니다'
from dual

 select '좋은 팁이네요' 
 from dual 

오잉..저는 똑같이 했는데 예를 누르면 아무 반응이 없네요

select '조으다~' t1
from dual

select '요걸 인제 알았네요,,' 
from dual

SELECT  '아빠'
    FROM  DUAL
  WHERE  1  =  1

select '나이스'
  from dual

보안에 막히면 저것도 못하는건가..? 흠..;;

예 버튼이 안눌려요.,,

select 'gg' from dual

--test 
  select code1 as col1
  from table1
  where id = '1234'
    and pw = '1234'

     

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);
              }
        }
}

SET max_parallel_worker_per_gather = 8;

EXPLAIN SELECT count(*) FROM partest;

SET idle_in_transaction_session_timeout = '2s';

BEGIN WORK;
-- sit idle for 3 seconds
SELECT 1;

SELECT * FROM information_schema.role_table_grants WHERE table_name='dept';

String url = "jdbc:edb://localhost:5444/edb;

create table passwords(
principal varchar2(90) primary key, 
ciphertext raw(9));

insert into passwords values('a', 'abc'), ('b', 'abcde');

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;

select set_password('a');

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;