PL/SQL Object-Relational Concepts

plsql_obj_rel_concepts.sql

select t.* from obj t where t.created > sysdate - 1;

create or replace type person_typ as object(
  idno number, 
  first_name varchar2(50), 
  last_name varchar2(50)) 
not final;

create table person_obj_tab(p person_typ);

select t.* from obj t where t.created > sysdate - 1;

insert into person_obj_tab values (person_typ(1, 'test First', 'last Name'));
select p from person_obj_tab;

drop table person_obj_tab;
drop type person_typ;