Re: Declare a table as like MS SQL Server
Posted by:
Ra Nala
Date: January 04, 2018 01:03PM
Sorry Sir, here is the info.
create table rprt_def_war
(rprt_id int,
ser varchar (50),
model varchar (50),
p_nm varchar (50)
)
;
insert into rprt_def_war(ser,model,p_nm) values ('F',1,NULL)
insert into rprt_def_war(ser,model,p_nm) values ('F',2,NULL)
insert into rprt_def_war(ser,model,p_nm) values ('F',3,NULL)
insert into rprt_def_war(ser,model,p_nm) values ('F',4,NULL)
insert into rprt_def_war(ser,model,p_nm) values ('F',5,227)
insert into rprt_def_war(ser,model,p_nm) values ('F',6,NULL)
insert into rprt_def_war(ser,model,p_nm) values ('F',7,NULL)
insert into rprt_def_war(ser,model,p_nm) values ('F',7,121)
current results
rprt_id ser model p_nm
---------- ------ -------- -------
(null) F 1 (null)
(null) F 2 (null)
(null) F 3 (null)
(null) F 4 (null)
(null) F 5 227
(null) F 6 (null)
(null) F 7 (null)
(null) F 7 121
Expecting results
rprt_id ser model p_nm
---------- ------ -------- -------
(null) F 1 227
(null) F 2 227
(null) F 3 227
(null) F 4 227
(null) F 5 227
(null) F 6 121
(null) F 7 121
(null) F 7 121
Thanks