alter table your_schema.your_table_name modify 
(userid varchar2(11));

alter table
   table_name
add
   (
   column1_name column1_datatype column1_constraint, 
   column2_name column2_datatype column2_constraint,
   column3_name column3_datatype column3_constraint
   );

CREATE TABLE table_name
(column1 datatype null/not null,
column2 datatype null/not null,
...
CONSTRAINT fk_column
  FOREIGN KEY (column1, column2, ... column_n)
  REFERENCES parent_table (column1, column2, ... column_n)
);

ALTER TABLE dbobjects.dining_plan
    drop CONSTRAINT dining_plan_pk;

ALTER TABLE dbobjects.dining_plan ADD
  CONSTRAINT dining_plan_pk
  PRIMARY KEY (id)
;

ALTER TABLE dbobjects.dining_plan_options ADD
    CONSTRAINT fk_dining_plan_option
    FOREIGN    KEY (planid)
    REFERENCES dbobjects.dining_plan(id)
;

alter table
   table_name
rename to
   new_table_name;

alter table plan_watchlist rename author to name 

alter table schema.table_name modify(my_column varchar2(200))

GRANT SELECT,INSERT,UPDATE,DELETE ON $schema.table_name TO webuser;

DROP TYPE my_schema.my_own_type;
CREATE OR REPLACE TYPE my_schema.my_own_type AS TABLE OF NUMBER;

CREATE REPLACE FUNCTION my_schema.fn_convertstringtotable (P_STR in varchar2) return my_own_type
AS
    V_str LONG DEFAULT P_STR || ',';
    V_No NUMBER;
    V_Data my_own_type := my_own_type();
    BEGIN
        LOOP
        V_No:=INSTR(V_str, ',');
        EXIT WHEN (NVL(V_No, 0)=0);
        V_Data.EXTEND;
        V_Data(V_Data.COUNT) :=LTRIM(RTRIM(SUBSTR(V_Str, 1, V_No -1)));
        V_Str:=SUBSTR(V_Str, V_No+1);
        END LOOP;
        RETURN V_Data;
    END;
    /

SELECT COUNT(*) FROM MV_DATA
WHERE ID IN(
    select * from table (
        select fn_convertstringtotable(leaf_data_list) as ID 
        from my_data_sample where id='1'
    )
)

desc role_tab_privs; 
select * from role_tab_privs; 
select * from all_tables;
select * from all_objects;

su - postgres  -- to become the postgres user
pg_ctl status  -- to see if postgres is running
createdb test  -- create a database called 'test'
psql test      -- start an sql session in the test database
create table my_first_table (testing varchar);   -- create a table
insert into my_first_table (testing) values ( 'Hello World' );
select * from my_first_table; -- show everything in the table
delete from my_first_table;  -- delete everything in the table
drop table my_first_table;   -- destroy the table
\q             -- quit the sql session
dropdb test    -- destroy the database called 'test'
exit           -- stop being the postgres user
\list -- list all databases
\dt -- list all tables
\du -- list all users

postgres=# alter role webuser with createdb;
postgres=# alter role admin with superuser;

pg_dump -h localhost -p 5432 -U django -W -t $some_table_name mysite > output.sql

psql -h localhost -p 5432 -U django -d mysite -f symbol.sql 

 sudo -u postgres createdb -E utf8 -O $db_user $db_name

select max(id) from channel_blog_post;
select nextval('channel_blog_post_id_seq');
select setval('channel_blog_post_id_seq',
  (select max(id) from channel_blog_post)+1);

jdbc:postgresql://192.168.1.7:5432/$db_name

select * from instance.tbl_name
where some_clauses
order by some_condition
WITH UR
fetch first 100 rows only;

insert into instance.tbl_name
select 1000 -- new assigned id
  ,column_1
  ,column_2
  ,column_3
  from instance.tbl_name
  where id=$value;

insert into instance.tbl_name
(col_1, col_2, col_3)
select 1000,
,CLOB(col_2), CLOB(col_3)
from instance.tbl_name
where id=$value;