jametong的ITPUB博客

暂无签名

  • 博客访问: 96779
  • 博文数量: 47
  • 用 户 组: 普通用户
  • 注册时间: 2013-11-23 01:02
文章分类

全部博文(47)

文章存档

2005年(47)

我的朋友

发布时间:2005-04-14 14:48:07

G -- Thanks for the question regarding "Rows into columns", version 9.0.1originally submitted on 24-Jan-2004 20:20 Eastern US time, last updated 13-Apr-2005 9:55Tom's latest followup | GOTO a Bookmarkable Page | Bottom You Asked (Jump to Tom's latest followup)Hi Tom,I have a querysql> SELECT tr_date, item_id, adult_price adult, child_price childFROM mytableWHERE tr_date BETWEEN '01-jan-2004' AND '31-jan-2004'AND   tr_code LIKE 'D%'The output isTR_DATE   ......【阅读全文】

阅读(1269) | 评论(0) | 转发(0)

发布时间:2005-04-14 00:14:53

David -- Thanks for the question regarding "Update statement and Null-values -- update a table from another table", version Oracle 7.3.4originally submitted on 5-Jun-2000 10:18 Eastern US time, last updated 13-Apr-2005 11:48Tom's latest followup | GOTO a Bookmarkable Page | Bottom You Asked (Jump to Tom's latest followup)Tom,When updating a column with an update-statement, the value of some records (records that don't need to be updated), are changed into the value NULL. I use the next......【阅读全文】

阅读(1291) | 评论(0) | 转发(0)

发布时间:2005-04-13 20:09:45

^_^....[@more@] ......【阅读全文】

阅读(782) | 评论(0) | 转发(0)

发布时间:2005-04-13 11:43:02

今天在asktom上看到这么一个帖子, 觉得比较简洁明了, 这也是tom的一贯风格.Can we use the init.ora created from spfile to recreate spfile in case of any spfile errors? I find a *. prefixed to all parameters. Should this be removed ?One more question: If I have to change init parameters for making my db to archivelog mode, then the steps what I understand is :a. Change the reqd parameters in init.ora.b. Startup the db as usual from spfile.c. Create spfile from pfile.d. shutdown normale. startup  ......【阅读全文】

阅读(842) | 评论(0) | 转发(0)

发布时间:2005-04-13 11:35:58

Mark -- Thanks for the question regarding "In list question with bind variables.", version originally submitted on 2-May-2000 13:21 Eastern US time, last updated 12-Apr-2005 21:02Tom's latest followup | GOTO a Bookmarkable Page | Bottom You Asked (Jump to Tom's latest followup) Hi Tom, I am using Pro*C and I need to send an array of strings in a "where <value> in :<value>" is this possible? And if not what should I do?     and we said.......【阅读全文】

阅读(978) | 评论(0) | 转发(0)
给主人留下些什么吧!~~

jametong2014-06-27 16:58

http://lvyou.elong.com/laogt2/tour/a2r0cnvf.html
http://lvyou.elong.com/laogt2/tour/a2rfco0f.html
http://lvyou.elong.com/laogt2/tour/a2r7co1c.html
http://lvyou.elong.com/laogt2/tour/a2r0co27.html

回复  |  举报
留言热议
请登录后留言。

登录 注册