VIEWS

Manipulating View

DMLLanguage and views INSERT UPDATE DELETE Views can be selected select * from views   INSERT INTO VIEWS Views can be inserted into but they must have a primary key on that table. All the constrainsts that are needed must be available on that table as a caution, only insert into one table at a […]

Manipulating View Read More »

INVISIBLE COLUMNS

Invisible columns can be useful during application migrations. Making new columns invisible means they won’t be seen by any existing applications, but can still be referenced by any new applications, making the online migration of applications much simpler.   create table tab1 ( id number, description varchar2(50) invisible ); Example 2 CREATE TABLE TBL_EMPLOYEE2( EMPLOYEE_NUMBER

INVISIBLE COLUMNS Read More »

Scroll to Top