CREATE TABLE cust_details (
cust_id NUMBER,
cust_name VARCHAR2(100),
cust_address VARCHAR2(255),
cust_account_number NUMBER INVISIBLE
);
desc cust_details;
SET COLINVISIBLE ON
desc cust_details;
insert into cust_details values(1,'SCOTT','500,1A,california');
insert into cust_details(cust_id,cust_name,cust_address,cust_account_number)
values(2,'JAMES','101,1A,Atlantic,08201',1234123412341234);
SELECT
*
FROM
cust_details;
SELECT
cust_id,
cust_name,
cust_address,
cust_account_number
FROM
cust_details;
update cust_details set cust_account_number = -9999
where cust_account_number is null;
alter table cust_details modify cust_account_number visible;
desc cust_details;
alter table cust_details modify cust_account_number invisible;
desc cust_details;
SELECT
column_id,
column_name,
hidden_column
FROM
user_tab_cols
WHERE
table_name = 'CUST_DETAILS'
ORDER BY
column_id;
Very useful bro..Thanks a lot...
ReplyDeleteI like ur way of teaching.... Very nice to see ur vedios
ReplyDeleteIam so thrilled because of finding your alluring website here.Actually i was searching for Oracle PPM Cloud.Your blog is so astounding and informative too..Iam very happy to find such a creative blog. Iam also find another one by mistake while am searching the same topicOracle Fusion HCM.Thank you soo much.
ReplyDelete