<small id='DnhxA'></small><noframes id='DnhxA'>

  • <legend id='DnhxA'><style id='DnhxA'><dir id='DnhxA'><q id='DnhxA'></q></dir></style></legend>

      <bdo id='DnhxA'></bdo><ul id='DnhxA'></ul>
  • <i id='DnhxA'><tr id='DnhxA'><dt id='DnhxA'><q id='DnhxA'><span id='DnhxA'><b id='DnhxA'><form id='DnhxA'><ins id='DnhxA'></ins><ul id='DnhxA'></ul><sub id='DnhxA'></sub></form><legend id='DnhxA'></legend><bdo id='DnhxA'><pre id='DnhxA'><center id='DnhxA'></center></pre></bdo></b><th id='DnhxA'></th></span></q></dt></tr></i><div id='DnhxA'><tfoot id='DnhxA'></tfoot><dl id='DnhxA'><fieldset id='DnhxA'></fieldset></dl></div>

        <tfoot id='DnhxA'></tfoot>

        ORA 00904 错误:无效标识符

        时间:2023-09-18

        1. <tfoot id='PNd79'></tfoot>
          1. <i id='PNd79'><tr id='PNd79'><dt id='PNd79'><q id='PNd79'><span id='PNd79'><b id='PNd79'><form id='PNd79'><ins id='PNd79'></ins><ul id='PNd79'></ul><sub id='PNd79'></sub></form><legend id='PNd79'></legend><bdo id='PNd79'><pre id='PNd79'><center id='PNd79'></center></pre></bdo></b><th id='PNd79'></th></span></q></dt></tr></i><div id='PNd79'><tfoot id='PNd79'></tfoot><dl id='PNd79'><fieldset id='PNd79'></fieldset></dl></div>
            • <legend id='PNd79'><style id='PNd79'><dir id='PNd79'><q id='PNd79'></q></dir></style></legend>
                  <tbody id='PNd79'></tbody>

                  <bdo id='PNd79'></bdo><ul id='PNd79'></ul>

                  <small id='PNd79'></small><noframes id='PNd79'>

                  本文介绍了ORA 00904 错误:无效标识符的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  我在我的虚拟 XP 中安装了 Oracle 10g 并使用

                  I have installed Oracle 10g in my virtual XP and created a table using

                  create table reg1 (
                    fname varchar2(30),
                    lname varchar2(30),
                    addr varchar2(30),
                    mail varchar2(30),
                    occu varchar2(30),
                    uname varchar2(30),
                    passwd varchar2(30)
                  );
                  

                  并且表创建成功.但是当我尝试通过像

                  and the table created successfully.But when I am trying to fetch the values by simple query like

                  select fname, lname 
                    from reg1 
                   where uname="bbb";
                  

                  我收到类似

                  ORA-00904: "bbb": 无效标识符

                  ORA-00904: "bbb": invalid identifier

                  我无法理解我在这里做错了什么.

                  I cannot understand what I have done wrong here.

                  推荐答案

                  使用单引号.

                  select fname,lname from reg1 where uname='bbb';
                  

                  这篇关于ORA 00904 错误:无效标识符的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  上一篇:尝试为错误 ORA-01804 检索文本时出错 下一篇:我如何转换“遗产"?Oracle中的左外连接语句?

                  相关文章

                  <small id='VeYc0'></small><noframes id='VeYc0'>

                  <i id='VeYc0'><tr id='VeYc0'><dt id='VeYc0'><q id='VeYc0'><span id='VeYc0'><b id='VeYc0'><form id='VeYc0'><ins id='VeYc0'></ins><ul id='VeYc0'></ul><sub id='VeYc0'></sub></form><legend id='VeYc0'></legend><bdo id='VeYc0'><pre id='VeYc0'><center id='VeYc0'></center></pre></bdo></b><th id='VeYc0'></th></span></q></dt></tr></i><div id='VeYc0'><tfoot id='VeYc0'></tfoot><dl id='VeYc0'><fieldset id='VeYc0'></fieldset></dl></div>

                      <bdo id='VeYc0'></bdo><ul id='VeYc0'></ul>
                    <legend id='VeYc0'><style id='VeYc0'><dir id='VeYc0'><q id='VeYc0'></q></dir></style></legend>

                      <tfoot id='VeYc0'></tfoot>