This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
create table p ( | |
id raw(16) default sys_guid() primary key, | |
name varchar2(10) not null | |
); | |
create table c ( | |
id raw(16) default sys_guid(), | |
parent_id raw(16) not null | |
constraint c_p_id_fk | |
references p, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
create table t ( | |
c date | |
); | |
insert into t (c) values (to_date('01.10.2019 06:45', 'mm-dd-yyyy hh24:mi')); | |
insert into t (c) values (to_date('01.10.2021 21:45', 'mm-dd-yyyy hh24:mi')); | |
select sysdate current_date, | |
to_date(to_char(sysdate, 'dd-mm-yyyy') || to_char(c, 'hh24') || to_char(c, 'mi'), 'dd-mm-yyyyhh24mi') new_date, | |
cast(to_date(to_char(sysdate, 'dd-mm-yyyy') || to_char(c, 'hh24') || to_char(c, 'mi'), 'dd-mm-yyyyhh24mi') as timestamp) - systimestamp diff, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select d.deptno, d.dname, e.ename, dc.country | |
from emp e | |
full join dept d | |
on e.deptno = d.deptno | |
left join dept_country dc | |
on e.deptno = dc.deptno | |
order by d.deptno, d.dname, e.ename; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select json_object( | |
'id' is department_id, | |
'name' is department_name, | |
'location' is ( | |
select json_object( | |
'id' is location_id, | |
'streetAddress' is street_address, | |
'postalCode' is postal_code, | |
'country' is ( | |
select json_object( |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
module.exports = { | |
user: 'hr', | |
password: 'oracle', | |
connectString: 'localhost:1521/orcl', | |
poolMax: 20, | |
poolMin: 20, | |
poolIncrement: 0 | |
}; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
module.exports = { | |
user: 'hr', | |
password: 'oracle', | |
connectString: 'localhost:1521/orcl', | |
poolMax: 20, | |
poolMin: 20, | |
poolIncrement: 0 | |
}; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
module.exports = { | |
user: 'hr', | |
password: 'oracle', | |
connectString: 'localhost:1521/orcl', | |
poolMax: 20, | |
poolMin: 20, | |
poolIncrement: 0 | |
}; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
module.exports = { | |
user: 'hr', | |
password: 'oracle', | |
connectString: 'localhost:1521/orcl', | |
poolMax: 20, | |
poolMin: 20, | |
poolIncrement: 0 | |
}; |