Full table scan without scan particular column (CLOB datatype column)
i want to select the table online_bank. this table having one of CLOB datatype column. i want to select all columns of the table except clob datatype column. but oracle server scan the full table including CLOB datatype column at the time of query execution. so it's taken long time to complete the execution of table. plz give me a solution to full table scan without scan the CLOB datatype column. how can avoid the CLOB datatype column at the time of scanning..?