Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Assignment 1(SET A)
create table patient(p_no int primary key, address varchar(50),p_name varchar(20)); create table bed(bed_no int primary key, room_no int, description varchar (30)); ---one to one relationship create table patients(p_no int primary key, p_name varchar(20), address varchar (50), patient_bed int references bed(bed_no)); insert into patient values(1,'koregaon park','vinayak'); insert into patient values(2,'wagholi','dheeraj'); insert into bed values(11,'106','single bed'); select * from patient; select * from bed;
run
|
edit
|
history
|
help
0
pgsql trigger 01 - Ovocie
Christmas Tree Generator
Assignment 1(SET A)
loggin_trigger-audit
test 16721723
pgsql trigger 01 - Ovocie
CALCULATOR USING PL/PGSQL FUNCTIONS
remove properties from jsonb using function jsonb_set of PostgreSQL
Dashes in numbers
project 1