All field names in the corresponding table of Oracle query can exclude unwanted fields

Time:2020-1-23

Because the length of Oracle varchar type is limited to 4000, the following methods only support query field splicing with length less than or equal to 4000

The first method

select wm_concat(column_name)
from user_tab_cols
Where table_name = upper ('t1plcbase ') -- table name
--Field name you don't want to query
and column_name not in ('RNWPAYTODATE', 'ANUINFORMTODATE', 'APPLYSTATUS');

The second method

select Listagg(column_name, ',') WITHIN GROUP(ORDER BY column_name)
from user_tab_cols
Where table_name = upper ('t1plcbase ') -- table name
--Field name you don't want to query
and column_name not in ('RNWPAYTODATE', 'ANUINFORMTODATE', 'APPLYSTATUS');

Pay attention to me if you like

All field names in the corresponding table of Oracle query can exclude unwanted fields

Recommended Today

Notes on tensorflow 2 deep learning (I) tensorflow Foundation

This series of notes records the process of learning tensorflow2, mainly based on https://github.com/dragen1860/Deep-Learning-with-TensorFlow-book Learning First of all, it needs to be clear that tensorflow is a scientific computing library for deep learning algorithm, and the internal data is stored in theTensor objectAll operations (OPS) are also based on tensor objects. data type Fundamentals in […]