• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

sql file problem

 
Ranch Hand
Posts: 125
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi I have this sql file
problems
1)what is this par here

2)it is giving syntax error (probabaly ; at end thats y)
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fcharset0 Arial;}}
{\*\generator Msftedit
5.41.15.1507;}\viewkind4\uc1\pard\f0\fs20 CREATE OR ALTER
TABLE user \par
\tab regi_hu_g_code char(11) NOT NULL,\par
\tab tot_expe number(9) DEFAULT 0,\par
\tab tong number(9) DEFAULT 0,\par
\tab tol_expected number(9) DEFAULT 0,\par
\tab perc_acccy number(9,2) DEFAULT 0,\par
\tab created_by varchar2(8) NOT NULL\par
\tab created_time timestamp NOT NULL\par
\tab upf varchar2(8) NOT NULL\par
\tab up timestamp NOT NULL\par
)
\par
\par
\par
};
 
Ranch Hand
Posts: 1228
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Did you edit & save the sql file in wordpad ?
You see the extra characters & formatting stuffs because the editor you used added that to the sql file & oracle cannot understand it. So open a simple text editor & create the sql like

1. Open the sql in wordpad
2. Create a new document in notepad.
3. copy the contents of the sql opened in word pad & paste it in notepad
4. Save & Execute the new sql created in notepad.
[ September 14, 2006: Message edited by: Srinivasa Raghavan ]
 
Is this the real life? Is this just fantasy? Is this a tiny ad?
Clean our rivers and oceans from home
https://www.kickstarter.com/projects/paulwheaton/willow-feeders
reply
    Bookmark Topic Watch Topic
  • New Topic