Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

»ùÓÚ OCI ʵÏÖµÄ oracle ×î¸ßЧdump³ÌÐò

»ùÓÚOCI ʵÏֵĠ×î¸ßЧdump³ÌÐò£¬ ±ÈOTL ÒÔ¼°ÆäËûµÄ½Ó¿Ú¶¼¿ìºÜ¶à
ÄÜÖ´ÐÐÈκÎsql , ×Ô¶¯Ê¶±ð×Ö¶ÎÃûºÍ×Ö¶ÎÀàÐÍ£¬½øÐÐÊä³öÊä³ö
/*
* oracle_dump.cpp
*
* Created on: 2010-2-1
* Author: clm971910@gmail.com
*
* ѹËõ
* 4216351 dump done
* ÍêÕû 106 Ãë
* д·Ö¸ô·û 8Ãë
* ѹËõд´ÅÅÌ 34Ãë
* ¶ÁÊý¾Ý 9Ãë
* Êý¾Ý¿â²éѯ 54Ãë
*/
#include <iostream>
#include <string>
#include <stdio.h>
#include <stdlib.h>
#include <time.h>
#include <unistd.h>
#include <sys/types.h>
#include <sys/stat.h>
#include <fcntl.h>
#include <errno.h>
#include <getopt.h>
#include <oci.h>
#include <oratypes.h>
#include <ocidfn.h>
#ifdef __STDC__
#include <ociapr.h>
#else
#include <ocikpr.h>
#endif
#include <ocidem.h>
#include "tbZip.h"
using namespace std;
/* =================== macro =====================*/
#define MAX_SELECT_COL_SIZE 1000 /* sqlÖÐ×î´óµÄÁÐÊý */
#define MAX_COLNAME_LEN 54 /* ÁÐÃû×î´ó³¤¶È */
#define MAX_SQL_LINE_SIZE 1024 /* sqlµÄ×î´ó³¤¶È */
#define MBYTE 1024 * 1024 /* 1M µÄ×Ö½ÚÊý */
#define DEFAULT_FETCH_SIZE 1000 /* ÿ´ÎÈ¡µÄ¼Ç¼Êý */
#define MAX_COLDATA_LEN 16 * 1024 /* ÁÐÊý¾ÝµÄ×î´ó³¤¶È */
/*=====================define all struct=======================*/
/* OCI »·¾³ */
typedef struct OCI_ENV
{
OCIEnv *oci_env; /* »·¾³¾ä±ú */
OCISvcCtx *oci_svc; /* ·þÎñÆ÷»·¾³¾ä±ú */
OCIServer *oci_srv; /* ·þÎñÆ÷¾ä±ú */
OCIError *oci_err; /* ´íÎó¾ä±ú */
OCIStmt *oci_stmt; /* Óï¾ä¾ä±ú */
OCISession *oci_session; /* »á»°¾ä±ú */
} OCI_ENV;
/* ÁÐÔªÐÅÏ¢ */
typedef struct COL_META
{
ub2 colType; /* ×Ö¶ÎÀ


Ïà¹ØÎĵµ£º

×î½üÔÚ×öOracleÁÙʱ±í¼ÓÔØ ×ªÔØÒ»¸öÒÔ±ã²éѯ

×ªÔØ
DML statements on temporary tables do not generate redo logs for the data changes. However, undo logs for the data 
and redo logs for the undo logs are generated. Data from the temporary table is automatically 
dropped in the case of session termination, either when the user logs o ......

oracle Êý¾Ý¿â¸Äoracle_sidµÄ²Ù×÷·½·¨

ÐÞ ¸Ä SID
°¸Àý: ¾ÉÊý¾Ý¿â(OLDDB)
        Îļþ´æ·Å(data files,redo files,control files,temp files, undo files)Ŀ¼ÊÇ
(/u01/OLDDB)
dumpÎļþĿ¼ÊÇ(/u01/dump)
       ÐÂÊý¾Ý¿â(NEWDB)
   ......

oracleÊý¾Ý¿âÈçºÎÇåÀíÁÙʱ±í¿Õ¼ä

     Õý³£À´Ëµ£¬ÔÚÍê³ÉSelectÓï¾ä¡¢create indexµÈһЩʹÓÃTEMP±í¿Õ¼äµÄÅÅÐò²Ù×÷ºó£¬OracleÊÇ»á×Ô¶¯ÊͷŵôÁÙʱ¶ÎaµÄ¡£µ«ÓÐЩÓкîÎÒÃÇÔò»áÓöµ½ÁÙʱ¶ÎûÓб»ÊÍ·Å£¬TEMP±í¿Õ¼ä¼¸ºõÂúµÄ×´¿ö£¬ÉõÖÁÊÇÎÒÃÇÖØÆôÁËÊý¾Ý¿âÈÔûÓнâ¾öÎÊÌâ¡£Õâ¸öÎÊÌâÔÚÂÛ̳ÖÐÒ²³£±»ÍøÓÑÎʵ½£¬ÏÂÃæÎÒ×ܽáһϣ¬¸ø³ö¼¸ÖÖ´¦Àí·½·¨¡£ ......

OracleÖÐTO_DATE¸ñʽ

TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02   13:45:25ΪÀý)
   
        Year:      
        yy two digits Á½Î»Äê            &n ......

Oracleºº×ÖÅÅÐò


ʹÓÃÒ»ÏÂSQL
select * 
from T_0303003 
order by stock_holder
½øÐÐѡȡÊý¾Ýʱ£¨stock_holderΪ´æ·ÅÖÐÎĵÄ×ֶΣ©£¬½á¹û·¢ÏÖÁ½¿â·µ»ØµÄ¼Ç¼˳Ðò²»Ò»Ö¡£×ÁÄ¥Ö®ºóÓ¦¸ÃΪ×Ö·û¼¯ÎÊÌ⣬һ¸ö¿â×Ö·û¼¯ÎªÏµÍ³Ä¬ÈÏ×Ö·û¼¯£¬ÁíÒ»¸ö¿âΪUTF-8×Ö·û¼¯¡£²éÕÒ×ÊÁϺó·¢ÏÖ£¬¶ÔÓÚÖÐÎÄ×ֶεÄÅÅÐò£¬Ó¦¸ÃÊ¹Ó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ