호주 멜번스토리

SQL>select * from v$session; SQL> desc v$session; 이름 널? 유형 ----------------------------------------- -------- ---------------- SADDR RAW(8) SID NUMBER SERIAL# NUMBER AUDSID NUMBER PADDR RAW(8) USER# NUMBER USERNAME VARCHAR2(30) COMMAND NUMBER OWNERID NUMBER TADDR VARCHAR2(16) LOCKWAIT VARCHAR2(16) STATUS VARCHAR2(8) SERVER VARCHAR2(9) SCHEMA# NUMBER SCHEMANAME VARCHAR2(30) OSUSER VARCHAR2(30) PR..

SQL> desc dba_users; 이름 널? 유형 ----------------------------------------- -------- -------------- USERNAME NOT NULL VARCHAR2(30) USER_ID NOT NULL NUMBER PASSWORD VARCHAR2(30) ACCOUNT_STATUS NOT NULL VARCHAR2(32) LOCK_DATE DATE EXPIRY_DATE DATE DEFAULT_TABLESPACE NOT NULL VARCHAR2(30) TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30) CREATED NOT NULL DATE PROFILE NOT NULL VARCHAR2(30) INITIAL_RSRC_CONSUME..

SQL>SELECT * FROM DBA_USERS; SQL>CREATE USER USER_ID IDENTIFIED BY PASSWD DEFAULT TABLESPACE TBS_CLUB TEMPORARY TABLESPACE TEMP; /* CONNECTION 등 기본적인 권한을 부여함 */ SQL>GRANT CONNECT, RESOURCE TO UEBPP; SQL>ALTER USER USER_ID IDENTIFIED BY PASSWD DEFAULT TABLESPACE TBS_CLUB2 TEMPORARY TABLESPACE TEMP;

#krsead001457712[/oracle/OraHome1/bin] lsnrctl LSNRCTL for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Production on 15-FEB-2001 10:53:28 (c) Copyright 1998 Oracle Corporation. All rights reserved. Welcome to LSNRCTL, type "help" for information. LSNRCTL> help The following operations are available An asterisk (*) denotes a modifier or extended command: start stop status services version reloa..

Using Command-Line Keywords Keywords are optionally separated by commas. They are entered in any order. Keywords are followed by valid arguments. For example: SQLLDR CONTROL=foo.ctl, LOG=bar.log, BAD=baz.bad, DATA=etc.dat USERID=scott/tiger, ERRORS=999, LOAD=2000, DISCARD=toss.dis, DISCARDMAX=5 최초 insert할 때 control file ============================== LOAD DATA badfile apt.bad insert into table t..

Data Dictionary Views Available Through Heterogeneous Services This appendix lists the data dictionary views that are supported through heterogeneous services mapping: ALL_CATALOG ALL_COL_COMMENTS ALL_COL_PRIVS ALL_COL_PRIVS_MADE ALL_COL_PRIVS_RECD ALL_CONSTRAINTS ALL_CONS_COLUMNS ALL_DB_LINKS ALL_DEF_AUDIT_OPTS ALL_DEPENDENCIES ALL_ERRORS ALL_INDEXES ALL_IND_COLUMNS ALL_OBJECTS ALL_SEQUENCES AL..

ALTER TABLE xxxx ADD (CONSTRAINT xxxx_PK PRIMARY KEY(PHYNO) USING INDEX TABLESPACE IDX_TBS STORAGE(INITIAL 50K NEXT 5K PCTINCREASE 0 MINEXTENTS 10 MAXEXTENTS UNLIMITED)); 확인 select table_name , constraint_name , constraint_type from all_constraints where table_name = 'BBTB_CNT' 날리기 ALTER TABLE bbtb_cnt drop CONSTRAINT SYS_C001193 ; 또는 alter table bbtb_cnt add primary key (bbsno, phyno);

MySQL 주의점 -*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*- 원본사이트: http://www.devshed.com/Server_Side/MySQL/Join/ * MySQL Table Joins *(o) By W.J. Gilmore *(o)| July 06, 1999 (o)| | 번역 : 원주희(lolol@shinan.hongik.ac.kr) ======================================================================= [영어실력이 너무 부족하다보니 잘못된 부분이 있을 수도 있습니다. 고쳐야할 부분이 있으면 꼭 메일을 보내주세요.] ◆◆ 소개하기 SQL(Structured..