사용자 삭제 drop user 아이디 CASCADE; 사용자 생성 create user 아이디 identified by 비밀번호; 권한주기 grant connect,resource, DBA to 아이디; grant CREATE DATABASE LINK, CREATE PUBLIC DATABASE LINK, CREATE MATERIALIZED VIEW, CREATE PROCEDURE, CREATE PUBLIC SYNONYM, CREATE ROLE, CREATE SEQUENCE, CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREATE VIEW to 아이디;

CREATE TABLE [dbo].[tblcommon]( [SEQ] [int] IDENTITY(1,1) NOT NULL, [GUBUN] [varchar](30) NOT NULL, [TITLE] [varchar](150) NOT NULL, [DEPTH] [int] NOT NULL, [PARENT_SEQ] [int] NULL, [SORT] [int] NOT NULL, CONSTRAINT [PK_tblcommon] PRIMARY KEY CLUSTERED ([SEQ] ASC) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ..

select machine "hostname", username "username", osuser "OS User", program "Program", sid||','||serial# "ID", last_call_et "Last Activity", status from v$session where username is not null order by status desc, last_call_et desc;

select b.machine "hostname", b.username "username", b.osuser "OS User", b.program "Program", a.tablespace_name "TableSpace", row_wait_file# "File Number", row_wait_block# "Block Number", c.owner, c.segment_name, c.segment_type from dba_data_files a, v$session b, dba_extents c where b.row_wait_file# = a.file_id and c.file_id = row_wait_file# and row_wait_block# between c.block_id and c.block_id +..

MySql INSERT INTO CONTENT ( CREATED_DATE, TITLE, CONTENT, CONTENT_TYPE ) VALUES ( now(), #title#, #content#, #contentType# ) ]]> SELECT LAST_INSERT_ID() MSSQL INSERT INTO PRJ_INFO ( ... ) VALUES ( ... ) SELECT SCOPE_IDENTITY() Oracle SELECT message_id_seq.nextval FROM DUALINSERT INTO guestbook_message (message_id, guest_name, password, message) VALUES( #message_id#, #gName#, #pw#, #ms#)

ORACLE SELECT * FROM TABLE_NAME SAMPLE (3)SELECT * FROM (SELECT * FROM TABLE_NAME ORDER BY DBMS_RANDOM.VALUE)WHERE ROWNUM < 3 MSSQLSELECT TOP 3 * FROM TABLE_NAME ORDER BY NEWID() MYSQLSELECT * FROM TABLE_NAME ORDER BY RAND() LIMIT 0,3