Home » SQL & PL/SQL » SQL & PL/SQL » How to insert Folder path name?
How to insert Folder path name? [message #241217] Mon, 28 May 2007 22:08 Go to next message
fba_sen57
Messages: 14
Registered: March 2006
Location: Brunei
Junior Member
Hi ALL,

I am trying to insert a folder path eg c:\program files\... into my insert statement. How will write the statement in full to include in the folder path? Do you use single quote ' ?

eg. insert into tablename (employee_id, folder_path) values (12345, 'C:\program files\employer\employee.xls')

Also I got the message "ORA-00984: column not allowed here". Why does this error occur? Please advise
Re: How to insert Folder path name? [message #241230 is a reply to message #241217] Mon, 28 May 2007 23:30 Go to previous message
bonker
Messages: 402
Registered: July 2005
Senior Member
It works for me..


scott@orcl>select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.1.0 - Production
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

scott@orcl>

scott@orcl>create table tname(emid int,folder_path varchar2(1000));

Table created.

scott@orcl>insert into tname values (12345, 'C:\program files\employer\employee.xls')
  2  /

1 row created.

scott@orcl>

scott@orcl>select * from tname;

      EMID FOLDER_PATH
---------- ----------------------------------------
     12345 C:\program files\employer\employee.xls

scott@orcl>



Post your entire test case.





Previous Topic: how to use functions in alias names
Next Topic: Regarding bulk insert (merged topics)
Goto Forum:
  


Current Time: Thu Dec 08 22:29:15 CST 2016

Total time taken to generate the page: 0.09320 seconds