Pro*C对inner join的支持情况
整理自：http://forums.oracle.com/forums/thread.jspa?threadID=664180&tstart=0
问：Is it possible to use INNER JOIN's with Pro*C? I'm currently getting this error:
INNER JOIN t_diagnosis b ON a.sak_diag = b.sak_diag
....1
PCC-S-02201, Encountered the symbol "INNER" when expecting one of the following:
; , for, union, connect, group, having, intersect, minus,
order, start, where, with,
The query runs fine via SQL Developer. My version of Pro*C is Pro*C/C++: Release 10.2.0.3.0.
Thanks,
Matthew
答：
Unfortunately the Pro*C precompiler does not understand "new"
syntax/keywords... this falls into the same category as using analytics
discussed here:
http://forums.oracle.com/forums/thread.jspa?threadID=664180&tstart=0
You would need to use dynamic sql as described in the programmer's guide to do this.
Support for all the ANSI 99 sql syntax (including joins) has been added
in 11g
w
ith
the new precompiler option common_parser. You can
precompile your proc program containig join sqls as follows:
proc common_parser=yes
proc_file.pc
For release 10.2 and earlier you would to workaround by using dynamic sqls as Mark suggested.
相关文档：
CSocket派生于CAsyncSocket, 所有施诸于上的操作皆为同步操作。比如Connnect,Receive等。
同步操作的优点是简单易用，但缺点也显而易见，效率低下，因为你必须等到一个操作完成之后才能进行下一个操作。
如果你很关心效率，就应该优先使用CAsyncSocket。反之就用CSocket。
下面将说明如何用CSocket创建简单的服务器和客� ......
大学的时候选修过一个学期日语，当时日语老师对我们说：“对于中国人来讲，学习英语一般是哭着进去，笑着出来；学习日语则是笑着进去，哭着出来”。意思就是说学习英语的时候，入门的时候比较困难，但是只要坚持学下去，转变了汉语的思维习惯时，最近可以把英语学得很好。而日语不同，一方面因为其与汉语的紧密关 ......
最近维护Logger共享库的时候新增了更人性化的自动创建各级目录的功能，下面是我实现创建诸如 "c:\a\b\c\d\yeah.log"中的各级文件夹的过程，请大家指教！
BOOL CreateDirectoryInPathW(const wchar_t *sLogPath)
{
static BOOL bRet = 0;
CString csFullDir(_T(""));//原始全路径
int nLen = 0;//原� ......
#include <stdio.h>
#include <stdlib.h>
#include <syslog.h>
#include <signal.h>
#include <unistd.h>
#include <string.h>
#include <getopt.h>
#define MAX_READFILE 24
#define MAX_INPUTFILE 10240
char *file ;
void time_out(){
syslog(LOG_INFO,"read inp ......
