dmcghan

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,

dmcghan

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,

dmcghan

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;

dmcghan

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(

dmcghan

module.exports = {
  user: 'hr',
  password: 'oracle',
  connectString: 'localhost:1521/orcl',
  poolMax: 20,
  poolMin: 20,
  poolIncrement: 0
};

dmcghan

module.exports = {
  user: 'hr',
  password: 'oracle',
  connectString: 'localhost:1521/orcl',
  poolMax: 20,
  poolMin: 20,
  poolIncrement: 0
};

dmcghan

module.exports = {
  user: 'hr',
  password: 'oracle',
  connectString: 'localhost:1521/orcl',
  poolMax: 20,
  poolMin: 20,
  poolIncrement: 0
};

dmcghan

module.exports = {
  user: 'hr',
  password: 'oracle',
  connectString: 'localhost:1521/orcl',
  poolMax: 20,
  poolMin: 20,
  poolIncrement: 0
};