在Oracle 10G中插入查询错误 [英] Insert Query Error in Oracle 10G

问题描述

大家好.

我写了一个查询在oracle中插入一条记录，但它给了我错误
未声明绑定变量"


查询是:

hi guys..

I have written a query to insert a record in oracle but it gives me error
"Bind Variable not declared"


Query is :

<pre lang="sql">insert into VISITOR_REG values (''Nilesh'',8999890654,''caGloo'',''Project Meet'',''C10001'',''E00001'',''Ahmedabad'',15-Mar-11 11:39:00 AM,''ASHUTOSH'','''',''In'')</pre><br />

表格说明是:

The table description is :

<br />
Name                                      Null?    Type<br />
----------------------------------------- -------- -----------------<br />
VISITOR_NAME                                       VARCHAR2(30)<br />
MOBILE_NO                                          NUMBER(10)<br />
COMPANY                                            VARCHAR2(50)<br />
PURPOSE                                            VARCHAR2(50)<br />
DEPARTMENT                                         VARCHAR2(50)<br />
CONTACT_PERSON                                     VARCHAR2(20)<br />
CITY                                               VARCHAR2(30)<br />
VISIT_DATE                                         DATE<br />
ENTRY_PERSON                                       VARCHAR2(50)<br />
EXIT_PERSON                                        VARCHAR2(50)<br />
STATUS                                             VARCHAR2(10)<br />
<br />

帮帮我...

Help me out...

推荐答案

您需要通过的日期.

Date you need to pass like this.

INSERT INTO X VALUES (TO_DATE('1998/05/31 12:00:00', 'YYYY/MM/DD HH24:MI:SS'));

对于数据库，存储日期的日期格式可能会有所不同.因此，我们在存储时必须明确提及日期/时间的格式(带有格式字符串的to_date函数).数据将以数据库级别指定的格式存储.

The date format in which the date is stored may be different for a database. So we have to explicitly mention the format of the date/time when we are storing (to_date function with format string). The data will be stored in the format as specified at the database level.

这篇关于在Oracle 10G中插入查询错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！