invantive documentation
Invantive Support ForumsLog In / Sign Up

activitysectors_dml: Sample Activity sectors with insert, update and delete

insert update delete

  • Catalog: Dummy
  • Schema: Demo
  • Primary Keys: CODE_ATTR
  • Label: Activity sectors with insert, update and delete

Can retrieve data and change data using insert, update and delete.

Table Columns

The columns of the table activitysectors_dml are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
code_attr varchar2(2) fetched only when named
date_created datetime fetched only when named
description varchar2(240) fetched only when named
example_byte blob fetched only when named
example_decimal number fetched only when named
id number fetched only when named
parent_code_attr varchar2(1) fetched only when named
parent_description varchar2(240) fetched only when named
rownum number fetched only when named

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: