oracle10R2 썸네일형 리스트형 10g Administration Workshop II 한글판 더보기 PLP10g Fundamentals 1.11 PL/SQL 블록 구조 SQL> accept g_one prompt 'Enter the first ename:' variable g_compensation number; declare v_onesal number; begin select sal into v_onesal from emp where ename = UPPER('&g_one'); :g_compensation := v_onesal ; end; / print g_compensation 문제) 이름을 넣으면 직업이 출력되게 위의 프로그램을 수정하시요 !! 1.21 Dbms_output SQL> set serveroutput on SQL> ed p1.sql declare v_name varchar(20); begin select ename i.. 더보기 Oracle Database 10g : Data Warehousing Fundamentals 더보기 OCM Oracle Database 10g : Security 더보기 OCM Oracle Database 10g : Data Modeling 더보기 Oracle Database 10g：Parallelism and Scalability 더보기 Oracle Database 10g：Advanced (Database and Grids) Oracle Database 10g：Advanced (Database and Grids) 더보기 Oracle Database 10g：Implementing Audit Vault & Database Vault Oracle Database 10g：Implementing Audit Vault Oracle Database 10g：Implementing Database Vault 더보기 Oracle Database 10g：SQL Tuning Workshop 더보기 Oracle Database 10g : RAC Basic Concepts & Architec / Deployment Workshop Oracle Database 10g : RAC Basic Concepts & Architec Oracle Database 10g：RAC Deployment Workshop 더보기 Oracle Database 10g：Backup and Recovery Oracle Database 10g：Backup and Recovery 더보기 Oracle Database 10g：ASM 더보기 Oracle Database 10g：Managing Oracle on Linux for System Admin 더보기 Oracle Database 10g：RAC for Administrators 더보기 Oracle Enterprise Manager 10g Grid Control 더보기 Oracle Database 10g：Develop PL／SQL Program Units Oracle Database 10g：Develop PL／SQL Program Units 더보기 Oracle Database 10g：Advanced PL／SQL Oracle Database 10g：Advanced PL／SQL 더보기 Oracle Database 10g：PL／SQL Fundamentals 더보기 Oracle Database 10g：SQL and PL／SQL New Features 더보기 이전 1 2 3 다음