alter table tambah coloumn

alter table nama_table alter column nama_kolom type tipe_data_baru;
alter table wage alter column wagename type varchar(60);

[+/-] Selengkapnya...

[+/-] Ringkasan...

Ubah Huruf depan Besar di Sebuah kolom

fendy=> begin;
BEGIN
fendy=> update nama_table set nama_kolom=initcap(nama_kolom);
UPDATE 1599999
fendy=> select empid,empname from emp order by empid;
fendy=> commit;
COMMIT
fendy=>

[+/-] Selengkapnya...

[+/-] Ringkasan...

dblink PostgreSql

--------------------------------------------------------------------------
--select dblink_connect('terang','dbname=terang user=bits password=506123');
select * from dblink('terang', 'select * from bp') as bp(bpid varchar,
bpgrpid varchar,
bpname varchar,
vatregdate date,
email varchar,
website varchar,
taxtype varchar,
indid varchar,
crcid varchar,
canvasid varchar,
srepid varchar,
areaid varchar,
prclvlid varchar,
anniversary date,
taxregno varchar,
vatregno varchar,
bankname varchar,
bankaccno varchar,
bankaccname varchar,
bpnote varchar,
purctopid varchar,
purcistaxed boolean,
purctaxinc boolean,
purctaxid varchar,
saletopid varchar,
saleistaxed boolean,
saletaxinc boolean,
saletaxid varchar,
collectorid varchar,
bpstatusid varchar,
active boolean,
_xt boolean) where bpid<>'CASH';



--isi ke bp

insert into bp select * from dblink('terang','select * from bp') as bp(bpid varchar,
bpgrpid varchar,
bpname varchar,
vatregdate date,
email varchar,
website varchar,
taxtype varchar,
indid varchar,
crcid varchar,
canvasid varchar,
srepid varchar,
areaid varchar,
prclvlid varchar,
anniversary date,
taxregno varchar,
vatregno varchar,
bankname varchar,
bankaccno varchar,
bankaccname varchar,
bpnote varchar,
purctopid varchar,
purcistaxed boolean,
purctaxinc boolean,
purctaxid varchar,
saletopid varchar,
saleistaxed boolean,
saletaxinc boolean,
saletaxid varchar,
collectorid varchar,
bpstatusid varchar,
active boolean,
_xt boolean) where bpid<>'CASH';

[+/-] Selengkapnya...

[+/-] Ringkasan...