txtÎļþµ¼Èëoracle·½·¨
ÔÚʵ¼Ê¹¤×÷ÖУ¬¾³£Òª´ÓÊý¾Ý¿âÖе¼³öÊý¾Ý»òÍùÊý¾Ý¿âÖе¼ÈëÊý¾Ý¡£µ±Óöµ½Êý¾ÝÁ¿½Ï´óʱ£¬¾ÍÐèÒªµ¼ÈëÎı¾¸ñʽµÄÊý¾Ý£¬Ò»°ãµ¼ÈëµÄÊý¾Ý¸ñʽÓÐtxt£¬csvµÈ¡£ÒÔÏÂÖ÷Òª½éÉÜÎÒÔÚʵ¼Ê¹¤×÷ÖÐÏòoracleÖе¼ÈëÊý¾ÝµÄÁ½¸öʵÀý¡£
1.ʹÓÃPL/SQL DeveloperµÄText Importer
£¨1£©´Ó²Ëµ¥ÖÐÑ¡È¡Text Importer¹¦ÄÜ¡£
Tool——>Text Importer£¨Èçͼ1Ëùʾ£©
£¨2£©µã»÷“Text Importer”ºóÏÔʾÖ÷´°¿Ú£¨Èçͼ2£©
£¨3£©ÉèÖý«Êý¾ÝÎļþµ¼Èëµ½ÄĸöÊý¾Ý¿âÖеÄÄĸö±íÖУ¬Èçͼ3Ëùʾ¡£
£¨4£©ÉèÖÃÍê³Éºó£¬µã»÷“Import”°´Å¥£¬Êý¾Ý¿ªÊ¼µ¼ÈëÖ±µ½Êý¾ÝÈ«²¿µ¼Èëµ½Êý¾Ý¿âÖС£
2.ʹÓÃPower Builder ½«txtÎļþµ¼Èëµ½Êý¾Ý¿âÖС£
£¨1)ÏȽ¨±í½á¹¹
ÀýÈ磺Create Table Temp (subsid varchar(20) not null primary key,subsname(50))£»Èçͼ4Ëùʾ¡£
ÔÚÕâÀïÐèҪ˵Ã÷µÄÊÇ£ºÔÚ½¨Á¢±íµÄ¹ý³ÌÖУ¬±ØÐëÉèÖÃÖ÷¼ü£¬·ñ×Ų»ÔÊÐíµ¼ÈëÊý¾Ý¡£
£¨2£©¼ìË÷¸Õ½¨µÄÁÙʱ±ítemp
select * from temp
£¨3£©µã»÷“Rows”ϵēImport”Ñ¡Ïµ¯³öÎļþ¶Ô»°¿ò£¬Ñ¡ÔñÄãÒª¼ÓÔصÄÊý¾ÝÎļþ£¬µã»÷“È·¶¨”¡£Èçͼ5Ëùʾ¡£
£¨4£©µã»÷¹¤¾ßÀ¸ÉϵēSave Changes to Database”°´Å¥£¬¿ªÊ¼µ¼ÈëÊý¾ÝÖ±µ½Õû¸öÊý¾Ýµ¼ÈëÍê±Ï¡£Èçͼ6Ëùʾ¡£
ÒÔÉÏÁ½¸öÀý×ÓÊÇÎÒÔÚÈÕ³£¹¤×÷ÖÐÓöµ½µÄÎÊÌâµÄ½â¾ö°ì·¨£¬Ï£ÍûÄܶԸ÷λÓÐËù°ïÖú¡£ÓÉÓÚµ¼ÈëµÄͼΪgif¸ñʽ£¬ÔÚ±à¼Ê±¿ÉÒÔ¿´Çå³þ£¬µ«·¢±íºó¾Í²»Çå³þÁË£¬»¹Íû¸÷λº£º¡£
Ïà¹ØÎĵµ£º
Exam : Oracle 1Z0-051
Title : Oracle Database: SQL Fundamentals I
1. View the Exhibit to examine the description for the SALES table.
Which views can have all DML operations performed on it? (Choose all that apply.)
A. CREATE VIEW v3
AS SELECT * from SALES
WHERE cust_id = 2034
WITH CHECK OPTI ......
1.¼ò½é
ÔÚ9i֮ǰ£¬²ÎÊýÎļþÖ»ÓÐÒ»ÖÖ£¬ËüÊÇÎı¾¸ñʽµÄ£¬³ÆΪpfile£¬ÔÚ9i¼°ÒÔºóµÄ°æ±¾ÖУ¬ÐÂÔöÁË·þÎñÆ÷²ÎÊýÎļþ,³ÆΪspfile,ËüÊǶþ½øÖƸñʽµÄ¡£ÕâÁ½ÖÖ²ÎÊýÎļþ¶¼ÊÇÓÃÀ´´æ´¢²Î ÊýÅäÖÃÒÔ¹©oracle¶ÁÈ¡µÄ£¬µ«Ò²Óв»Í¬µã£¬×¢ÒâÒÔϼ¸µã£º
1)pfileÊÇÎı¾Îļþ£¬spfileÊǶþ½øÖÆÎļþ£»
2) ¶ÔÓÚ²ÎÊýµÄÅäÖã¬pfile¿ÉÒÔÖ±½ÓÒÔÎı¾±à¼Æ ......
ÔÚpl/sqlʱ¾³£»áÅöµ½½«Ä³Ð©Ìض¨µÄ·ûºÅת»»³ÉÐÐ,Õ⹦ÄÜÏ൱ÓÚsplit.ÒÔÇ°ÔÚÍøÉÏÊÕ¼¯µÄsplitº¯ÊýÈçÏÂ:
CREATE OR REPLACE TYPE DJ_STR_SPLIT IS TABLE OF VARCHAR2 (4000);
CREATE OR REPLACE PACKAGE Dj_Function_API IS
module_ CONSTANT VARCHAR2(25) := 'FNDBAS';
lu_name_ CONSTANT VARCHAR2(25) := 'DjFuncti ......
ÔÚdb2ºÍoracleÖеĶÔÊ÷µÄµÝ¹é²éѯÓï¾ä¡£
±í½á¹¹£º
create table MAIN_NODE (
MLA_ID INTEGER not null , //½ÚµãID
MLA_ROOTID &nb ......
²ì¿´listener.log È·ÈÏûÓÐÎÊÌâ
# find / -name listener.log
/home/oracle/app/OraHome_1/network/log/listener.log
λÖÃÔÚ$ORACLE_HOME/network/log/listener.log
TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 29-DEC-2009 15:12:15
Copyright (c) 1991, 2007, Oracle. All ......