mirror of
https://github.com/KevinMidboe/linguist.git
synced 2025-10-29 09:40:21 +00:00
22 lines
371 B
SQL
22 lines
371 B
SQL
|
|
CREATE TABLE x AS SELECT * FROM DUAL;
|
|
|
|
CREATE TABLE y (
|
|
col1 NUMBER NOT NULL ,
|
|
col2 VARCHAR2(200),
|
|
col3 DATE,
|
|
col4 TIMESTAMP WITH TIME ZONE NOT NULL
|
|
);
|
|
|
|
|
|
CREATE USER username IDENTIFIED BY password;
|
|
|
|
GRANT CONNECT, RESOURCE TO username;
|
|
|
|
|
|
GRANT CREATE TYPE TO username;
|
|
GRANT CREATE PROCEDURE TO username;
|
|
GRANT CREATE TABLE TO username;
|
|
GRANT CREATE VIEW TO username;
|
|
|