在表格中找到第3列(所有数据以及列名称) [英] find the 3rd column (all the data along with column name) in a table

问题描述

我必须找到表Person的第3列.我不知道列名.



预先谢谢您.

I have to find the 3rd column of a table Person. i dont know the column name.



thank you in advance

推荐答案

如果选择所有数据，然后移动到包含该数据的构造中的第三个列，则可以在第三个列中找到数据柱子.

此 [

If you select all the data, and move to the third colum in the construct that contains it, then you can find the data in the third column.

This[^] is apparently how you find column names. Note: I don''t use Oracle, I just know how to google.

正如我所说，这不是SQL和关系数据库的工作方式.您需要知道一列.但是，您可以了解表中有哪些列.

例如，看这个答案:
http://forums.sureshkumar.净/oracle-sql-server-sybase-others/22736-sql-query-find-column-names-table.html [ http://en.wikipedia.org/wiki/Metadata [ http://en.wikipedia.org/wiki/Database_schema [

As I say, this is not how SQL and relationship data bases work. You need to know a column. However, you can learn what columns are there in your table.

For example, look at this answer:
http://forums.sureshkumar.net/oracle-sql-server-sybase-others/22736-sql-query-find-column-names-table.html[^].

The idea is getting meta-data from the Oracle system table, in this example, all_tab_cols.

See also:
http://en.wikipedia.org/wiki/Metadata[^],
http://en.wikipedia.org/wiki/Database_schema[^].

—SA

这篇关于在表格中找到第3列(所有数据以及列名称)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！