inserting record into a table

wxdqz · Aug 21, 2008

Hi,
I am trying to insernt the follwoing record into a table:

DROP TABLE templates;

CREATE TABLE templates (
templateID number(11) default '0',
templateName varchar2(50) default NULL,
templateDescription varchar2(50) default NULL,
templateFormat long,
templateLevel number(11) default NULL,
templateGrouped number(11) default '0',
templateGroupTag varchar2(50) default NULL
) ;

INSERT INTO templates VALUES (1,'About Invisix','Template for the About Invisix Sub Section',
'\r\n<head>\r\n<title>Invisix</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">\r\n' ||
'<link rel=\"stylesheet\" href=http://www.phpbuilder.com/board/archive/index.php/\"invisix.css\">\r\n\r\n' ||
'<script language=\"JavaScript\" src=http://www.phpbuilder.com/board/archive/index.php/\"includes/flash1.js\"></script>\r\n</head>\r\n<body bgcolor=\"#333366\" l' ||
'leftMargin=0 topMargin=0 marginheight=\"0\" marginwidth=\"0\">\r\n<table width=\"100%\" border=\"0\" cellspacing=\"0\" '||
'cellpadding=\"0\" height=\"498\">\r\n <tr> \r\n <td width=\"100%\" bgcolor=\"#333366\" valign=\"bottom\" align=\"left\">'||
'<object classid=\"clsid

27CDB6E-AE6D-11cf-96B8-444553540000\" '||
'codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=4,0,2,0\" width=\"700\" height=\"38\">\r\n '||
'<param name=movie value=http://www.phpbuilder.com/board/archive/index.php/\"header_o.swf\">\r\n <param name=quality value=high>\r\n'||
'<embed src=http://www.phpbuilder.com/board/archive/index.php/\"header_o.swf\" quality=high'||
'pluginspage=\"http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash\" '||
'type=\"application/x-shockwave-flash\" width=\"700\" height=\"38\">\r\n </embed> \r\n '||
'</object></td>\r\n <td width=\"75\" valign=\"top\">'||
'<img src=http://www.phpbuilder.com/board/archive/index.php/\"../images/background/b1.gif\" width=\"73\" height=\"51\"></td>\r\n </tr>\r\n <tr> \r\n'||
'<td width=\"100%\" valign=\"top\"> \r\n <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n '||
'<tr valign=\"top\"> \r\n <td width=\"145\"><img src=http://www.phpbuilder.com/board/archive/index.php/\"../images/background/a2.gif\" width=\"145\" height=\"31\"></td>\r\n <td width=\"85%\"> \r\n <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n <tr bgcolor=\"#72AAC8\"> \r\n <td><img src=\"../images/background/shim.gif\" width=\"1\" height=\"1\"></td>\r\n </tr>\r\n <tr bgcolor=\"#23D6DF\"> \r\n <td><img src=\"../images/background/shim.gif\" width=\"1\" height=\"1\"></td>\r\n </tr>\r\n <tr bgcolor=\"#72AAC8\"> \r\n'||
'<td><img src=http://www.phpbuilder.com/board/archive/index.php/\"../images/background/shim.gif\" width=\"1\" height=\"1\"></td>\r\n </tr>\r\n'||
'<tr valign=\"top\" bgcolor=\"#382275\"> \r\n '||
'<td height=\"100%\"><img src=http://www.phpbuilder.com/board/archive/index.php/\"../images/background/shim.gif\" width=\"1\" height=\"25\"></td>\r\n'||
'</tr>\r\n <tr bgcolor=\"#F0E6EB\"> \r\n '||
'<td><img src=http://www.phpbuilder.com/board/archive/index.php/\"../images/background/shim.gif\" width=\"1\" height=\"3\"></td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n </table>\r\n </td>\r\n <td width=\"75\" valign=\"top\"><img src=\"../images/background/b2.gif\" width=\"73\" height=\"31\"></td>\r\n </tr>\r\n <tr> \r\n <td bgcolor=\"#FFFFFF\" valign=\"top\"> <img src=\"../images/background/shim.gif\" width=\"700\" height=\"8\"></td>\r\n <td width=\"75\" bgcolor=\"#333366\" valign=\"top\"> \r\n <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n <tr valign=\"top\"> \r\n'||
'<td bgcolor=\"#FFFFFF\" width=\"1\"> \r\n <img src=http://www.phpbuilder.com/board/archive/index.php/\"../images/background/shim.gif\" width=\"20\" height=\"8\"> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *</p!
> * * * *'||
'* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * </td>\r\n <td bgcolor=\"#23D6DF\"><img src=http://www.phpbuilder.com/board/archive/index.php/\"../images/background/shim.gif\" width=\"2\" height=\"1\"></td>\r\n <td bgcolor=\"#856491\"><img src=\"../images/background/shi!
m.gif\" width=\"1\" height=\"1\"></td>\r\n <td bgcolor=\"#333366\" width=\"100%\"> \r\n <img src=\"../images/background/shim.gif\" width=\"1\" height=\"1\"> * </td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n</table>\r\n \r\n\r\n<%@include file=\"includes/mainMenu.jsp\" %>\r\n\r\n \r\n<%@include file=\"includes/menu.jsp\" %>\r\n \r\n<div id=\"flash\" style=\"position:absolute; left:18px; top:157px; width:57px; height:397px; z-index:3\"><object classid=\"clsid

27CDB6E-AE6D-11cf-96B8-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=4,0,2,0\" width=\"55\" height=\"395\">\r\n <param name=movie value=\"sring13.swf\">\r\n <param name=quality value=high>\r\n <embed src=\"sring13.swf\" quality=high pluginspage=\"http://www.macromedia.com/shock!
wave/download/index.cgi?P1_Prod_Version=ShockwaveFlash\"'||
'type=\"application/x-shockwave-flash\" width=\"55\" height=\"395\">\r\n '||
'</embed> \r\n </object></div>\r\n \r\n<div id=\"Layer2\" '||
'style=\"position:absolute; left:76px; top:157px; width:126px; height:213px; z-index:2; visibility: '||
'visible\">\r\n<[elementTemplates1#Image]></div>\r\n<div id=\"Layer1\" style=\"position:absolute; left:280px; top:150px;' ||
'width:433px; height:246px; z-index:1; visibility: visible\" class=\"menuheaders\"><[elementTemplates2#Body]>'||
'</div>\r\n \r\n</body>',1,0,'');

the value is too long. Even I can not open this in vi. I tried both with concatination and without concatination and I am getting some weared errros.
Is there a way I can insert this into a table?Is there a max limit for a line in vi?
Your help is greately appreciated.
Thanks
Imran

inserting record into a table

wxdqz

New Member