Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the legal responsibility to pursue copyright.
Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/41513537
Experiment: Use PL/SQL developer software to get the text form of table name and column name
Operation Process:
Example 1: Getting the text of the user table name in a "comma" format
Use Scott to log in to PL/SQL Developer, find the tables option in the All Objects box, right-click to see the "Copy Comma separated" option, click to get the "comma", "Delimited" text, click Options such as:
Open a text editor and perform the paste operation as shown in:
You can look at the tables that Scott owns, such as:
Comparing the above two graphs, we know that the user's table name is extracted in text form and separated by commas.
Example 2: Get the text of column name in "comma" format
To a user, click the "Copy Comma separated" option in the Column drop-down menu for a table, such as:
Under the text editor, perform the paste operation, such as:
You can look at the column names under the bonus table under the Scott user, such as:
Comparing the above two graphs, we know that the columns of a user's table are extracted in text form and separated by commas.
Example 3: Get the text format of a user table name without a comma format
Use the PL/SQL developer software to query out the owning table, then select, right-click to complete the "copy" operation, such as:
Paste into a text editor, such as:
Summary:
Using the PL/SQL developer software, click the "Copy Comma separated" option to complete the text format for table or column names, separated by commas.
Although the operation is very simple, in the case of the user table is not many, a few table columns may not be used, but if the production system, a user may have two hundred or three hundred tables, or a large table has seventy or eighty fields, when the extraction, you will find using "Copy comma separated" How convenient it will be to get the text.
Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the legal responsibility to pursue copyright.
Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/41513537
PL/SQL Developer_ How to quickly get the text form of a table name or column name