SQL*Plus: Release 8.1.6.0.0 - Production on Tue Jan 14 17:12:46 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Enter password:
Connected to:
Oracle8i Release 8.1.6.1.0 - Production
JServer Release 8.1.6.0.0 - Production
SQL> desc lsnewsarticle;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
CLASSID NOT NULL NUMBER
NEWSTITLE NOT NULL VARCHAR2(200)
NEWSKEYWORD VARCHAR2(200)
NEWSCONTENT CLOB
PICPATH VARCHAR2(100)
ISHTML CHAR(1)
LINK1 NUMBER
LINK2 NUMBER
LINK3 NUMBER
LINK4 NUMBER
INPUT_DATE DATE
INPUT_USER VARCHAR2(30)
NEWSTYPE CHAR(1)
Y VARCHAR2(20)
M VARCHAR2(20)
ISMGZ VARCHAR2(10)
SQL> select a.* from (select b.*,rownum rn from(select newstitle,to_char(input_date,'yyyy-mm-dd hh24:mi:ss') as inputdate,input_user,id from lsnewsarticle where classid='1' order by input_date desc ) b where rownum <= 10) a where rn >= 0;
ERROR:
ORA-03113: end-of-file on communication channel
SQL> select a.*
from ( select b.*,rownum rn
from ( select newstitle,to_char(input_date,'yyyy-mm-dd hh24:mi:ss') as inputdate,input_user,id
from lsnewsarticle where classid='1' order by input_date desc ) b where rownum < 10) a
where rn > 0; 2 3 4 5
NEWSTITLE
--------------------------------------------------------------------------------
INPUTDATE INPUT_USER ID RN
------------------- ------------------------------ ---------- ----------
协会应邀参加“2001东来顺连锁工作会”
0000-00-00 00:00:00 ??辍保?刻ü裨被??盏哪攴延 5 1
........省略略干行
9 rows selected.
SQL> col newstitle format a60
SQL> l
1* select newstitle,id from lsnewsarticle where newstitle like '%东来顺连锁工作%'
SQL> /
NEWSTITLE ID
------------------------------------------------------------ ----------
协会应邀参加“2001东来顺连锁工作会” 5
中国连锁经营协会应邀参加“2001东来顺连锁工作会” 69
盛况空前 发展无限—'99东来顺连锁工作会圆满成功 776
SQL> select * from lsnewsarticle where id=5
2 ;
select * from lsnewsarticle where id=5
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
SQL> exit
Disconnected from Oracle8i Release 8.1.6.1.0 - Production
JServer Release 8.1.6.0.0 - Production
[oracle@helloworld log]$ sqlplus app
SQL*Plus: Release 8.1.6.0.0 - Production on Tue Jan 14 17:26:44 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Enter password:
Connected to:
Oracle8i Release 8.1.6.1.0 - Production
JServer Release 8.1.6.0.0 - Production
SQL> update lsnewsarticle set INPUT_USER='liubin' where id=5;
1 row updated.
SQL> select * from lsnewsarticle where id=5;
ERROR:
ORA-01858: a non-numeric character was found where a numeric was expected
no rows selected
SQL> select * from lsnewsarticle where id='5';
ERROR:
ORA-01858: a non-numeric character was found where a numeric was expected
no rows selected
SQL> select * from lsnewsarticle where id=5;
select * from lsnewsarticle where id=5
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
SQL> exit
Disconnected from Oracle8i Release 8.1.6.1.0 - Production
JServer Release 8.1.6.0.0 - Production
[oracle@helloworld log]$ sqlplus app
SQL*Plus: Release 8.1.6.0.0 - Production on Tue Jan 14 17:31:53 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Enter password:
Connected to:
Oracle8i Release 8.1.6.1.0 - Production
JServer Release 8.1.6.0.0 - Production
SQL> delete from lsnewsarticle where id=5;
1 row deleted.
SQL> commit
2 ;
Commit complete.