Hi,
I have a requirement where we need to find out Total storage size of row in oracle table.
I am not sure how to get total size.
Some times table can have 30 columns or 100 columns.
Any help regarding this would be helpful.
Requirement can be Find size of row where TERM_ID = 1532 from below scripts.
sample Table scripts are as below.
CREATE TABLE TERMS_DETAILS_TABLE
( TERM_ID NUMBER(15,0) NOT NULL ENABLE,
DESCRIPTION VARCHAR2(720 BYTE),
NAME VARCHAR2(45 BYTE) NOT NULL ENABLE,
LANGUAGE VARCHAR2(12 BYTE) NOT NULL ENABLE,
SOURCE_LANG VARCHAR2(12 BYTE) NOT NULL ENABLE,
LAST_UPDATE_DATE DATE NOT NULL ENABLE,
CREATION_DATE DATE NOT NULL ENABLE,
CREATED_BY NUMBER(15,0) NOT NULL ENABLE,
LAST_UPDATED_BY NUMBER(15,0) NOT NULL ENABLE,
LAST_UPDATE_LOGIN NUMBER(15,0)
) ;
Insert into TERMS_DETAILS_TABLE (TERM_ID,DESCRIPTION,NAME,LANGUAGE,SOURCE_LANG,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values (370,'ZUuIcTPcJuwMRIVKxNroSHNbEDmWtCCIYBhXlPTRZPhdHirLTNBCaFpeXgfVWRkivekDXpcWcZRapEnY','5CWM6JX1K3AEW8L3NLUV6AVH6','US','US',to_date('22-11-2016 07:27:13','DD-MM-YYYY HH24:MI:SS'),to_date('26-02-2003 00:00:00','DD-MM-YYYY HH24:MI:SS'),196,12754,4983866);
Insert into TERMS_DETAILS_TABLE (TERM_ID,DESCRIPTION,NAME,LANGUAGE,SOURCE_LANG,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values (369,'QnZTIrmwiMtIhDAUtSgfXUivmTcPKcCoUEoeJWfdrdLEscrWryFMYVUDGCiSUolCRinqagylwsjQwZSe','IXBQEVUALW5MQO9Z0NFK8DVUC','US','US',to_date('22-11-2016 07:25:05','DD-MM-YYYY HH24:MI:SS'),to_date('26-02-2003 00:00:00','DD-MM-YYYY HH24:MI:SS'),196,12754,4983866);
Insert into TERMS_DETAILS_TABLE (TERM_ID,DESCRIPTION,NAME,LANGUAGE,SOURCE_LANG,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values (1532,'RicjyWsbGXxeLRgIMyvTIpHnqodVvmhYkLCTKddYGlUlxetIqejFPZSHWFFuJazrjAxWuJgSjPFFUBwh','Z60ZPBVUXXYSVUP7KIY9CMMIA','US','US',to_date('17-11-2016 13:35:36','DD-MM-YYYY HH24:MI:SS'),to_date('11-02-2016 13:35:36','DD-MM-YYYY HH24:MI:SS'),3316,3316,4976494);
Insert into TERMS_DETAILS_TABLE (TERM_ID,DESCRIPTION,NAME,LANGUAGE,SOURCE_LANG,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values (1531,'TMbLMzgHQHNTDdPplSHsoabaupLkbOpqSgFVZfyAIKpymwIViNxJbYINCmvnOVxjoSpdIOptcxqbXjwc','QJ9C0VWHQEL65FT3KJK3O87YJ','US','US',to_date('17-11-2016 13:35:25','DD-MM-YYYY HH24:MI:SS'),to_date('11-02-2016 13:35:25','DD-MM-YYYY HH24:MI:SS'),3316,3316,4976494);
Insert into TERMS_DETAILS_TABLE (TERM_ID,DESCRIPTION,NAME,LANGUAGE,SOURCE_LANG,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values (1530,'DJtDmxDUSBJoBwjwdfcvKyPLLokyHEqFvprBSBEGTzSJKZqGdTWhhLnOxdCuBuaOqApTxnDxevFVXFRo','IQHHUAXJ92CQQENDE1Z51N2IT','US','US',to_date('17-11-2016 13:35:14','DD-MM-YYYY HH24:MI:SS'),to_date('11-02-2016 13:35:14','DD-MM-YYYY HH24:MI:SS'),3316,3316,4976494);
Insert into TERMS_DETAILS_TABLE (TERM_ID,DESCRIPTION,NAME,LANGUAGE,SOURCE_LANG,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values (1529,'IHgpPeUtStvUweVKAHdIMtDIOcDEQFDGkikRYuHJulotSYHeCjdjyUxXjjugjXzDcglVYdTutSCeRKnR','GAUP9A2ZUIP6E9ONIW68QXXL3','US','US',to_date('17-11-2016 13:35:02','DD-MM-YYYY HH24:MI:SS'),to_date('11-02-2016 13:35:02','DD-MM-YYYY HH24:MI:SS'),3316,3316,4976494);
Insert into TERMS_DETAILS_TABLE (TERM_ID,DESCRIPTION,NAME,LANGUAGE,SOURCE_LANG,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values (1528,'LgoPZAdUSfxISHMWRZPqBaYwBgOQfkovQjvJYdXuLidrkfQKrRVTlMNNMCgFlSPjOsRqkkRdIsimGpGt','T9U11C7SCJJ7L9WUGXSX11KWB','US','US',to_date('17-11-2016 13:34:51','DD-MM-YYYY HH24:MI:SS'),to_date('11-02-2016 13:34:51','DD-MM-YYYY HH24:MI:SS'),3316,3316,4976494);
Insert into TERMS_DETAILS_TABLE (TERM_ID,DESCRIPTION,NAME,LANGUAGE,SOURCE_LANG,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values (1527,'xjkQwCIdmcOJvneabvhVQhnzKDFrBUGKmQVhVXMBUgAgXvDjnPHWXutHnpIxXOoYskrRLqbwbiCodrjx','9E0FFK44KABE7MU9PLVXKDC30','US','US',to_date('17-11-2016 13:34:39','DD-MM-YYYY HH24:MI:SS'),to_date('11-02-2016 13:34:39','DD-MM-YYYY HH24:MI:SS'),3316,3316,4976494);
Insert into TERMS_DETAILS_TABLE (TERM_ID,DESCRIPTION,NAME,LANGUAGE,SOURCE_LANG,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values (1526,'TNOYOzSZGefsmAZNQsyimfgPyJLAlcFGDXWlNGyzOXJxrBKsaAXPWPNRWZZAbYgJBCeAHYMfPHgdhqHY','OZZ5Z5I92HSRXG4TI0GJPPNDT','US','US',to_date('17-11-2016 13:34:28','DD-MM-YYYY HH24:MI:SS'),to_date('11-02-2016 13:34:28','DD-MM-YYYY HH24:MI:SS'),3316,3316,4976494);
Insert into TERMS_DETAILS_TABLE (TERM_ID,DESCRIPTION,NAME,LANGUAGE,SOURCE_LANG,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values (1525,'JiQIsTYZxwmpefIQZoxyaWXqHDtEGUqgIqJUrFjzyQplEVwpvdcHNfORlKNyoPGFmwKVlrPYEnkfrTfD','YMX8F920FLK9NTCS7ZKADJ3WD','US','US',to_date('17-11-2016 13:34:17','DD-MM-YYYY HH24:MI:SS'),to_date('11-02-2016 13:34:17','DD-MM-YYYY HH24:MI:SS'),3316,3316,4976494);
Insert into TERMS_DETAILS_TABLE (TERM_ID,DESCRIPTION,NAME,LANGUAGE,SOURCE_LANG,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values (1524,'hWLTAFyuAWTfUpElNzHpNLNAQMmFyuVTgYSoUFznSdAFhUKRnrUFftExiyYyzUNhvlTpvEYfdIvugYSD','422RDHXM38KSB2WDC63X6A7F3','US','US',to_date('17-11-2016 13:34:05','DD-MM-YYYY HH24:MI:SS'),to_date('11-02-2016 13:34:05','DD-MM-YYYY HH24:MI:SS'),3316,3316,4976494);
Insert into TERMS_DETAILS_TABLE (TERM_ID,DESCRIPTION,NAME,LANGUAGE,SOURCE_LANG,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values (1523,'DHKenaROXrmUZNUNPUvdZixQzQzMRXBmGidnuevScGJVSstscqYGGQUDYKqFxSAdZQHUsQgsaEyrbrJb','037GPCQ0B6NKY1OTUF5EOKBQE','US','US',to_date('17-11-2016 13:33:54','DD-MM-YYYY HH24:MI:SS'),to_date('11-02-2016 13:33:54','DD-MM-YYYY HH24:MI:SS'),3316,3316,4976494);
Insert into TERMS_DETAILS_TABLE (TERM_ID,DESCRIPTION,NAME,LANGUAGE,SOURCE_LANG,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values (1522,'HYSYnVpesTsrxwwCWQpKJakCvWyiHdefiJdkoqISjAMpMduwUnCkRteCuQGuzUKbdWcmmEVGQBzVDfyP','BPE3T825YU7AC3JQFW0X250J3','US','US',to_date('17-11-2016 13:33:42','DD-MM-YYYY HH24:MI:SS'),to_date('11-02-2016 13:33:42','DD-MM-YYYY HH24:MI:SS'),3316,3316,4976494);
Insert into TERMS_DETAILS_TABLE (TERM_ID,DESCRIPTION,NAME,LANGUAGE,SOURCE_LANG,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values (1521,'KATYXJicZkfoKStNWpbziQClpBGVZdSFQZTWdsECGIaxWPTnrbVmvBBABZuwmAiqKzLnKyQdxBxEfVZh','KZSQUEEWUT5Y3G4IR8ESDLV1E','US','US',to_date('17-11-2016 13:33:31','DD-MM-YYYY HH24:MI:SS'),to_date('11-02-2016 13:33:31','DD-MM-YYYY HH24:MI:SS'),3316,3316,4976494);
Insert into TERMS_DETAILS_TABLE (TERM_ID,DESCRIPTION,NAME,LANGUAGE,SOURCE_LANG,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values (1520,'ccHVeUFSzOTQsmtRIllhNjRocSrbWbheCCSRUnJKNeEDkJuFnimtEqVFvywBvmxCQlhNZCbVQpkxsLuQ','MNGRXEADWK2HKUP0GB60VYN8C','US','US',to_date('17-11-2016 13:33:19','DD-MM-YYYY HH24:MI:SS'),to_date('11-02-2016 13:33:19','DD-MM-YYYY HH24:MI:SS'),3316,3316,4976494);
Insert into TERMS_DETAILS_TABLE (TERM_ID,DESCRIPTION,NAME,LANGUAGE,SOURCE_LANG,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values (1519,'BdUbRDkxAOSPaGMdQlRJMWbDXWqxCQWwbQcNqizQAAdAJozgaBHFhWTYzLYUUGtcfvdQpMuQmuKWKajy','VILE4ZMF7LCT68PP1K1Z7SPQZ','US','US',to_date('17-11-2016 13:33:08','DD-MM-YYYY HH24:MI:SS'),to_date('11-02-2016 13:33:08','DD-MM-YYYY HH24:MI:SS'),3316,3316,4976494);
Insert into TERMS_DETAILS_TABLE (TERM_ID,DESCRIPTION,NAME,LANGUAGE,SOURCE_LANG,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values (1518,'YyCknpUbbBhKpttfwGRyAtxNwRbsxDXYJbFHwOEHxKbeGowiBbUKUhLUQdcktszlcmRlIxmtRsdGitvx','DGTPNZIZDCJ90BROTD1YQ6DR2','US','US',to_date('17-11-2016 13:30:35','DD-MM-YYYY HH24:MI:SS'),to_date('11-02-2016 13:30:35','DD-MM-YYYY HH24:MI:SS'),3316,3316,4976494);
Insert into TERMS_DETAILS_TABLE (TERM_ID,DESCRIPTION,NAME,LANGUAGE,SOURCE_LANG,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values (1517,'twCRkisZEhrpGDsZxtQOlibSUxRCaHSJZfCdasLhUJbPBeTOltVTbXQNuUULpLjeMtThwDHRCrenNvhG','V6GX2UW28TMLX7ZOCG81HQDF1','US','US',to_date('17-11-2016 13:30:23','DD-MM-YYYY HH24:MI:SS'),to_date('11-02-2016 13:30:23','DD-MM-YYYY HH24:MI:SS'),3316,3316,4976494);
Insert into TERMS_DETAILS_TABLE (TERM_ID,DESCRIPTION,NAME,LANGUAGE,SOURCE_LANG,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values (1516,'rmWCejXTzWoQEuLhCuxyiagokzGpSyTlGrNUvHyMQIyAySyFmblvVOubmdrxirEGOClzCJtTCwygtftW','6JV3QGCZ5L1CWFKCWL8ZNHQI7','US','US',to_date('17-11-2016 13:30:12','DD-MM-YYYY HH24:MI:SS'),to_date('11-02-2016 13:30:12','DD-MM-YYYY HH24:MI:SS'),3316,3316,4976494);
Insert into TERMS_DETAILS_TABLE (TERM_ID,DESCRIPTION,NAME,LANGUAGE,SOURCE_LANG,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values (1515,'bsloMNMtUFRdyDSeKjAAcsYpXjcPtnyNVdmvFRzjICcANLxNgyhVXRLzcOEGBKHqiDYEUSNSmdBpDWCD','RO35HWCZT5LCE7Z8NA4E8PCU9','US','US',to_date('17-11-2016 13:30:00','DD-MM-YYYY HH24:MI:SS'),to_date('11-02-2016 13:30:00','DD-MM-YYYY HH24:MI:SS'),3316,3316,4976494);
commit;
Regards,
Mahesh