西安网站建设兼职,泰州做网站淘宝,可以免费做简历的网站,网站制作企业有哪些以前没有注意过这个问题,今天群里的朋友问了这个问题,发上来给大家看看:创建一个文件a.sql:select * from t2 start with root_id 0 connect by prior id root_id; /*zhushi*/到sqlplus中执行:SQL a.sql3 ;select * from t2 start with root_id 0 connect by prior id…以前没有注意过这个问题,今天群里的朋友问了这个问题,发上来给大家看看:创建一个文件a.sql:select * from t2 start with root_id 0 connect by prior id root_id; /*zhushi*/到sqlplus中执行:SQL a.sql3 ;select * from t2 start with root_id 0 connect by prior id root_id; /*zhushi*/*ERROR at line 1:ORA-00911: invalid character修改a.sql如下:select * from t2 start with root_id 0 connect by prior id root_id;/*zhushi*/成功执行:ROOT_ID ID NAME DESCRIPTION---------- ---------- ----- -----------0 1 a aaa1 2 a1 aaa11 3 a2 aaa20 4 b bbb4 5 b1 bbb14 6 b2 bbb26 rows selected由此得出结论,oracle对紧跟在;后面的注释都认为是非法字符.不知是否正确.
