oracle8,我用dephi6.0 table.create建立一个表test,建立过程程序未正常,
建完后select * from test 提示表或视图不存在,
用sqlplus登陆,select * from tab可以看到,select * from user_tables也可以看到,
select * from test提示表和视图不存在,请高手指点!!!
!!!!
建完后select * from test 提示表或视图不存在,
用sqlplus登陆,select * from tab可以看到,select * from user_tables也可以看到,
select * from test提示表和视图不存在,请高手指点!!!
!!!!
试试。
提示:
ORA-00932: 数据类型不一致
把上面语句的执行结果贴出来看看。
For example, adding a character field to a date field (dates may only be
added to numeric fields) or concatenating a character field with a long field.
n An attempt was made to perform an operation on a database object (such as
a table or view) that is not intended for normal use. For example, system
tables cannot be modified by a user. Note that on rare occasions this error
occurs because a misspelled object name matched a restricted object’s name.
An attempt was made to use an undocumented view.Action: If the cause is
different datatypes, then use consistent datatypes. For example, convert the
character field to a numeric field with the TO_NUMBER function before
adding it to the date field. Functions may not be used with long fields.
an object not intended for normal use, then do not access the restricted
object.
执行结果:
TABLE_NAME
------------------------------
TEST
animals
country
已选择3行。
结果中有小写字母显示的
但你执行select * from test;
或者select * from "TEST";都应当没有问题
也不应当出现 ORA-00932: 数据类型不一致 这种错误提示
给大家理解错了,对不起
animals 和 country 是程序建立的,出现以上提到的问题。