How to separate all the field names of a table with commas

This article mainly explains "how to get all the field names of a table with comma division". The explanation in this article is simple and clear and easy to learn and understand. let's study and learn how to use comma division to get all the field names of a table.

Since the beginning of Oracle 9i, it has been possible to change from the parent node to the current through the SYS_CONNECT_BY_PATH function

The row content is displayed in the form of "path" or a list of hierarchical elements.

Get all the field names of a table, separated by commas.

Select max (substr (SYS_CONNECT_BY_PATH (COLUMN_NAME,','), 2) col from

Select COLUMN_NAME,column_id from user_tab_columns where table_name='& table name')

Start with column_id=1

Connect by column_id=rownum

Thank you for your reading, the above is the content of "how to get all the field names of a table by comma division". After the study of this article, I believe you have a deeper understanding of how to achieve a comma division to get all the field names of a table, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!