Constraints in Nested table

In my previous blog “Working With Nested Table Oracle ” I explained how to work with nested tables. Here we can also define Constraints to the nested table. According to the previous blog “Working With Nested Table Oracle,” we have Table:=... Read more

Working With Nested Table Oracle

Nested table is awesome feature of Oracle. You can create table inside a table, Which means one column can be treated as a table. Nested tables are faster than the parent child table relationship. Steps : CREATE TYPE emp_table_type AS... Read more

Get the time when was the Record was inserted

Hey Guys, Some times we need to show the posted time or you can say when the data is inserted into the table. The idea of showing date in this format came from the social site post time display schemes... Read more