DB스토리

분류구문설명본문출력 출력문 켜기 set serveroutput on 프로시져 procedure procedure 만들기 create or replace procedure 반복 for loop 구구단 출력(값 하나 입력 받아서 출력하는 구문)sav gugu2create or replace procedure gugu2(su number) as begin for i in 1..9 loop dbms_output.put_line(su || 'X' || i || '=' || su*i); end loop; end; / 출력 dbms_output.put_line exec dbms_output.put_line('test'); 선언declarebeginend;asbeginend; 변수 선언anonymous 블럭에서는dec..

범주 설명 파일명 스크립트 본문 find view fv select view_name from dba_views where view_name like upper('%&KEY%') find constraint columns cons_col select CONSTRAINT_NAME,TABLE_NAME,COLUMN_NAME from DBA_CONS_COLUMNS where owner='&OWNER' find constraint cons select CONSTRAINT_NAME,CONSTRAINT_TYPE,TABLE_NAME,R_CONSTRAINT_NAME from dba_constraints where owner='&OWNER' 권한 보기 sPriv select * from session_privs 권한 찾기..

1. user 생성a. 일반 접속만 되는 user conn / as sysdba;undefine UserName;create user &&UserName identified by "&Password" /select username from dba_users where username=upper('&UserName') /prompt Show Grant!!!! select grantee, privilege from dba_sys_privs where grantee=upper('&UserName') /undefine UserName; b. schema 유저(객체를 소유한 유저)- quota,create table,create index, create procedure,create view, etc conn /..

root에서 아래 부분 복사해서 붙이면 됨 rm -f /etc/init.d/oracle cat >> /etc/init.d/oracle/u01/app/oracle/product/10.2.0/db_1/log/Log.oracleStartAll.log su - oracle -c "/u01/app/oracle/product/10.2.0/db_1/bin/sqlplus / as sysdba