We sometimes need to include a single quote in an SQL statement, I believe you already know the normal way, use two single quote characters to express one single quote. However, if you are using oracle 10g or a more recent version, the following way could be better:
This is a new feature of 10g that enables us to embed single-quotes in literal strings without having to resort to double, triple or sometimes quadruple quote characters. This is particularly useful for building dynamic SQL statements that contain quoted literals.
The mechanism is invoked with a simple "q" in PL/SQL only. The syntax is q'[...]', where the "[" and "]" characters can be any of the following as long as they do not already appear in the string.
Note that at the time of writing, the quoting mechanism only appears to work with 10g clients/OCI. If used with any software that uses an older Oracle client it fails with ORA-01756: quoted string not properly terminated (confirmed with sqlplus, TOAD and PL/SQL Developer).
If you want samples, see Reference
原文发表于 2004-4-5 21:55
4.4晚约11点半，俺拖着疲惫的双腿完成首师大东门至南门的穿越, 终于回到家了。
已经零点多了，我打开电脑，首先到风版瞧了一眼。蓟门42号老兄已经先行发了平安贴，小榄领队则补充了对周六无名英雄畅游、蓟门42号、西津渡一干猛驴的谢意。我将自己拍的照片放到老地方后，在活动照片版发了一个下载照片的链接，然后就陷入了香甜的梦乡。
…more
I have heard that Obsidian is a powerful note-taking application that can serve as "your second brain." However, when I tried it previously, I did not find its user experience to be satisfactory. Nevertheless, I decided to give it another try. Although this solution is free, it spent me at least a few hours before I get it. TLDR; here's the steps:
-
Create a private repository obsidian_notes on github.com to store your notes.
-
Create a classic personal access token on github.com for the obsidian git plugin as it dosn't support the git protocol on Mobile devices.
-
Install Obsidian and Obsidian Git plugin on every platform you want to use
-
Install iSH application on your iPhone/iPad, and run the following command in the iSH shell
- apk add git
- adduser -h /home/david david (Surely you can choose your preferred name)
- su - david
- git clone https://github.com/yourUserName/yourNotesRepo.git (you will need the personal access token at this step)
-
Open the Obsidian app on your iPhone/iPad, create a new Vault with any name. (no worries, we will remove it shortly)
-
Open the Files app and find yourNotesRepo directory, copy it to the clipboard,
- Find your Obsidian directory which holds your newly created vault and paste yourNotesRepo directory here
- Remove the newly created vault directory
Yes. That's it. If you meet any problems when you follow my steps, feel free to leave a comment here, or contact me at https://t.me/shukebeta
最早于 2004-3-30 21:49 发表于我的绿野驴志
今天和一个朋友聊起我在学编程的事儿。“你都三十多了,学什么编程啊！” 汗！
卖了十年计算机，没有半点儿成绩。还好意思和朋友说什么“怎么说是干自己喜欢的事儿“。
随着挣钱能力的降低，我也开始爱说什么“挣太多钱也没啥意思,够花就好....”，可钱有够花的么？呵呵
说着说着就跑题了。
俺现在主要用Delphi7,主要开发数据库应用,也就是中小企业应用了,目前在搞一个中关村小企业适用的进销存,遇到很多难点,还希望有同行的朋友多交流!
就写到这儿了,如果有愿意和俺做链接的，说一声！
俺这人就好交朋友!
04-Mar-2023 Update
今天50岁的我看那个32岁时的我：这个傻憨的年青人，后来真的成了一个程序员，而且混得还行吧。
作者 周令瑜
十年前读了这本书，这是当时的读书笔记。天知道在陪Eric长大的过程中，这本书有起多大的作用。
2013-03-13 17:55:10
压根儿不认识的俩孩子，在外面碰到了，很快就可以玩到一块。这是因为孩子没有任何戒心，没有顾虑，彼此真诚。成人则顾虑太多、对人设防，表面客气、内心疏离，所以，成人世界远不如孩子的世界纯净而温暖。
2013-03-13 17:55:37
在孩子的事情上，到底是谁不讲理？很多时候是父母。父母不要利用身高、体重的优势强行带走孩子，不要利用孩子依赖自己的心理来胁迫孩子。强迫、威胁孩子，孩子要么抵触父母，和父母对立；要么屈从了父母，而变得卑躬屈膝。
2013-03-14 05:56:16
只有走进孩子的心灵，多花时间陪伴孩子，细心观察他们的一举一动，试着去理解他们言行背后的内心世界，了解他们的内心需求，我们才能让孩子得到真正的幸福。否则，不论我们提供多么优越的物质条件，我们的孩子也不会幸福。
2013-03-14 06:05:11
当众教育孩子是对孩子的一种羞辱。
…more