如何在Oracle 10g中选择perticuler列 [英] how to select perticuler column in oracle 10g

问题描述

先生/妈妈，

当我输入查询从tab_name选择*"时，查询将成功执行.但是，当我输入从tab_name中选择column_name"时，他将显示错误的无效标识符.我无法理解y这个问题的发生.所以请帮帮我.

预先对u进行存储.

Respected sir/mam,

When i enter a query "Select * from tab_name" then the query is execute successfully. But when i enter a "Select column_name from tab_name" then he shows a error invalid identifier. I cant understand y this problem is occur. So pls help me.

Tank u in advance.

推荐答案

检查您的列名是否有效.

列名不能为保留字，不能以字母开头，小于或等于三十个字符，只能由字母数字和特殊字符(

Check if your column name is valid.

Column names cannot be a reserved word, begin with a letter, be less than or equal to thirty characters, consist only of alphanumeric and the special characters (

_#)组成.

http://www.dba-oracle.com/t_ora_00904_string_invalid_identifier.htm [

_#).

http://www.dba-oracle.com/t_ora_00904_string_invalid_identifier.htm[^]

这篇关于如何在Oracle 10g中选择perticuler列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！