Benthic SoftWare 导入导出数据

最新推荐文章于 2022-11-14 20:51:11 发布

iteye_9815

最新推荐文章于 2022-11-14 20:51:11 发布

阅读量501

点赞数

分类专栏： JAVA 文章标签： Java

本文链接：https://blog.csdn.net/iteye_9815/article/details/82065587

版权

JAVA 专栏收录该内容

174 篇文章 0 订阅

订阅专栏

导出：


SELECT

	NEWSTITLE NEWSTITLE,
	NEWSTITLE2 NEWSTITLE2,
	NEWSCONTENT NEWSCONTENT,
	NEWSSTATUS NEWSSTATUS,
	'n10090' CATEID,
	TO_CHAR(REFRESHTIME,'MM/DD/YYYY HH24:MI:SS') REFRESHTIME,
	NEWSTAGS NEWSTAGS,
	TO_CHAR(CREATETIME,'MM/DD/YYYY HH24:MI:SS') CREATETIME,
	ADDUSER ADDUSER,
	VIEWCOUNTS VIEWCOUNTS,
	COMMENTCOUNTS COMMENTCOUNTS,
	ISPARENT ISPARENT,
	PARENTID PARENTID,
	NEWSURL NEWSURL,
	COMEFROM COMEFROM,

	ISCOMMENT ISCOMMENT,
	ISSELECT ISSELECT

FROM ZSCOMM_DB.COMM_NEWS where cateid='n10090'