create table merchant
(
CUST_MOBILE_NO varchar2(1000),
CUST_ACCOUNT_NO varchar2(1000),
MERCHANTID varchar2(1000),
TERMINALID varchar2(1000)
);
Insert into merchant (CUST_MOBILE_NO,CUST_ACCOUNT_NO,MERCHANTID,TERMINALID) values ('+9112345678','214950360774','528541','956241');
create table temp
(
CUST_MOBILE_NO varchar2(1000),
CUST_ACCOUNT_NO varchar2(1000),
MERCHANTID varchar2(1000),
TERMINALID varchar2(1000)
);
Please help to select a record from merchant table and insert additional null record and valid record in temp table
select * from temp;
Desired result
CUST_MOBILE_NO CUST_ACCOUNT_NO MERCHANTID TERMINALID
+9112345678 214950360774 528541 956241
+9112345678 214950360774 null null
Please help