• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

sql file problem

 
arjun rampal
Ranch Hand
Posts: 125
  • Mark post as helpful
  • send pies
  • 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
};
 
Srinivasa Raghavan
Ranch Hand
Posts: 1228
  • Mark post as helpful
  • send pies
  • 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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic