oracle 数据库关于换行符问题。net程序下面

Question

在程序里面按照条件生成了一条超长的Sql。如果在里面手工加上换行是可以正确执行的。请问如何在Sql里面（对于程序而言就是一个string）加入换行符？ 
在jave里面是chr(13)||chr(10)
但在.net里面是什么
不过我感觉这跟编程环境无关   个人感觉而已  我试过用chr(13)||chr(10) 不行因为oracle数据库里面行允许字符为2499 所以总是报错，我手动用enter换行可以 但毕竟再程序里面 请教下怎么换行

Answer 1

http://blog.csdn.net/a9529lty/archive/2008/08/01/2755266.aspx

Answer 2

\r\n是不行得
枫 叶没明白我得意思
=============================
我得意思是再程序里面生成得动态sql字符串  另他再运行得时候不会报错  我再sqlplus里面把程序里面生成得sql语句贴过来 一执行就报错
错误信息：输入被截断为7499 
sp-0027：输入太长（》2499个字符）-行已忽略

Answer 3

insert into henan_zbl(point_type,point_class,point_,point_show)values (100,103,17051,mdsys.sdo_geometry(2003,null,null,+mdsys.sdo_elem_info_arry(1,1003,1),mdsys.sdo_ordinate_array(113.936174,36.304832, 113.944915,36.297296, 113.960568,36.293069, 113.978455,36.288079, 113.986059,36.286153, 113.997178,36.277868, 113.994346,36.265975, 113.984729,36.249298, 113.986884,36.241832, 113.993943,36.231718, 113.996882,36.214564, 113.998454,36.195559, 113.999145,36.17805, 113.998539,36.164649, 113.983552,36.149134, 113.97309,36.136933, 113.973368,36.122407, 113.982169,36.10781, 113.996863,36.098378, 114.013844,36.09265, 114.01643,36.083691, 114.016787,36.075868, 114.0094,36.058055, 113.998441,36.041761, 114.00013,36.032809, 113.992905,36.028773, 113.993217,36.017227, 113.997524,36.001923, 113.994318,35.996363, 114.00359,35.983625, 114.011991,35.973128, 114.011402,35.961216, 114.015702,35.951778, 114.019817,35.935401, 114.023226,35.91137, 114.048855,35.893281, 114.067137,35.878317, 114.070057,35.865015, 114.046457,35.846316, 114.024799,35.835772, 114.017911,35.825615, 114.023208,35.805142, 114.027389,35.794382, 114.015562,35.782735, 114.011159,35.7746, 114.027704,35.768844, 114.051094,35.76967, 114.080063,35.774025, 114.074286,35.753645, 114.06609,35.73686, 114.065964,35.726136, 114.054764,35.715505, 114.043636,35.711001, 114.028178,35.704491, 114.004758,35.701112, 113.9955,35.698635, 113.992817,35.679762, 113.983559,35.677285, 113.973016,35.670224, 113.966846,35.668743, 113.952111,35.67142, 113.941097,35.676619, 113.931248,35.67619, 113.922485,35.663496, 113.912581,35.658471, 113.905772,35.654953, 113.893468,35.655056, 113.883057,35.659229, 113.870144,35.659847, 113.863341,35.65684, 113.838678,35.652449, 113.802393,35.653774, 113.785215,35.658003, 113.781619,35.666204, 113.7935,35.682448, 113.799217,35.697721, 113.798143,35.711009, 113.784806,35.727973, 113.76162,35.74451, 113.755045,35.760907, 113.750979,35.78137, 113.746165,35.790603, 113.730839,35.795327, 113.714885,35.799035, 113.70451,35.806272, 113.694781,35.816057, 113.68498,35.819713, 113.675166,35.822349, 113.659732,35.817881, 113.650612,35.82715, 113.642131,35.838457, 113.637377,35.852796, 113.642347,35.85684, 113.647347,35.863438, 113.649366,35.878232, 113.656857,35.887362, 113.656935,35.894, 113.655203,35.903718, 113.661451,35.911838, 113.658441,35.91748, 113.656227,35.938438, 113.638583,35.955439, 113.644784,35.959473, 113.651623,35.965544, 113.657817,35.969067, 113.665182,35.967474, 113.671895,35.962821, 113.680502,35.962239, 113.692197,35.962652, 113.70207,35.965123, 113.703373,35.97124, 113.701617,35.978916, 113.696749,35.983553, 113.688202,35.989242, 113.683926,35.991831, 113.687044,35.99538, 113.698166,35.999373, 113.689595,36.003019, 113.676066,36.003643, 113.665028,36.0068, 113.662012,36.011932, 113.662114,36.020613, 113.665872,36.026199, 113.675124,36.028165, 113.69364,36.033117, 113.694297,36.036687, 113.687101,36.052579, 113.68175,36.068456, 113.680652,36.0797, 113.675121,36.080257, 113.670862,36.084379, 113.673974,36.087417, 113.68196,36.086329, 113.680174,36.091451, 113.655686,36.101869, 113.656958,36.105434, 113.666271,36.112506, 113.675481,36.110897, 113.688931,36.103635, 113.693865,36.104615, 113.714191,36.106488, 113.717297,36.109016, 113.713654,36.113132, 113.706325,36.117789, 113.705155,36.122906, 113.707676,36.127992, 113.705263,36.132098, 113.69662,36.129617, 113.688019,36.13071, 113.679502,36.138952, 113.670907,36.140556, 113.660472,36.142686, 113.668512,36.146194, 113.669175,36.150274, 113.66736,36.152843, 113.673524,36.153813, 113.682758,36.154246, 113.691383,36.155196, 113.70125,36.157156, 113.704972,36.159679, 113.703801,36.164796, 113.698294,36.167395, 113.684193,36.171599, 113.678698,36.175219, 113.686098,36.17669, 113.701484,36.177072, 113.705815,36.179079, 113.707081,36.182132, 113.707147,36.18775, 113.704717,36.190323, 113.692424,36.191447, 113.683805,36.191009, 113.681362,36.192561, 113.682074,36.200727, 113.689522,36.206282, 113.709281,36.212246, 113.705107,36.223516, 113.703363,36.232213, 113.712903,36.25869, 113.71868,36.27907, 113.72976,36.279488, 113.732305,36.286617, 113.739771,36.293705, 113.744102,36.295711, 113.74418,36.30235, 113.732581,36.310107, 113.73328,36.317251, 113.742682,36.331983, 113.747718,36.341645, 113.756337,36.342084, 113.76308,36.339984, 113.769776,36.3338, 113.780867,36.335239, 113.782665,36.331139, 113.784487,36.329081, 113.806466,36.314597, 113.824833,36.306783, 113.833488,36.310286, 113.841485,36.310219, 113.846986,36.307109, 113.85622,36.307543, 113.858108,36.311102, 113.85692,36.314687, 113.85394,36.322883, 113.855218,36.326958, 113.876141,36.327294, 113.879253,36.330332, 113.888463,36.328723, 113.892698,36.322559, 113.90063,36.316875, 113.904321,36.316844, 113.91429,36.327486, 113.921637,36.32436, 113.921415,36.305466, 113.925058,36.30135, 113.93121,36.301298, 113.936174,36.304832)));

Answer 4

系统提示我 太长 了 不让我发  所以 就只发了个insert