3 Replies - 1109 Views - Last Post: 23 August 2015 - 09:42 AM

#1 [email protected]  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 23-August 15

column not allowed while writting below quirey

Posted 23 August 2015 - 05:39 AM

SQL> insert into mouli1 values ('&empname',&empid,&sal,&sno,&doj);
Enter value for empname: manjusree
Enter value for empid: 5497
Enter value for sal: 20000
Enter value for sno: 3
Enter value for doj: 1-jan-2015
old 1: insert into mouli1 values ('&empname',&empid,&sal,&sno,&doj)
new 1: insert into mouli1 values ('manjusree',5497,20000,3,1-jan-2015)
insert into mouli1 values ('manjusree',5497,20000,3,1-jan-2015)
*
ERROR at line 1:
ORA-00984: column not allowed here


SQL>



Is This A Good Question/Topic? 0
  • +

Replies To: column not allowed while writting below quirey

#2 andrewsw  Icon User is online

  • lashings of ginger beer
  • member icon

Reputation: 6342
  • View blog
  • Posts: 25,595
  • Joined: 12-December 12

Re: column not allowed while writting below quirey

Posted 23 August 2015 - 06:09 AM

Is this for Oracle or MySQL..?

I guess that the issue is that the date needs to be surrounded with apostrophes.
Was This Post Helpful? 0
  • +
  • -

#3 [email protected]  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 23-August 15

Re: column not allowed while writting below quirey

Posted 23 August 2015 - 09:33 AM

its sqlpluse
i have cross check everything seems to be right, let me know if am missing anything here
Was This Post Helpful? 0
  • +
  • -

#4 andrewsw  Icon User is online

  • lashings of ginger beer
  • member icon

Reputation: 6342
  • View blog
  • Posts: 25,595
  • Joined: 12-December 12

Re: column not allowed while writting below quirey

Posted 23 August 2015 - 09:42 AM

So do you have no comment about missing apostrophes around the date value?

SQL *Plus? The Oracle database utility?

Question moved to Oracle forum. MySQL is a different database.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1