ORIGINWEB

Most of updated Oracle certification exam materials are available to download in http://www.examcollection.com/ website for free. Use search engine on website to lookup exams. How to run mock exam files after download? Since downloaded files are '.vce' type, we also need to download VCE program to run the files. Click and Download I meant to split into two zip file, so store in one folder after ..

Path to Oracle Certified Professional Most people in Korea take 007, 042 then 043. Advanced training courses are required to be quiliefied for OCP. http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=244#3 Certifications that we can pursue on Oracle University. https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=457&get_params=pillar_id:2

ORACLE SQL EXPERT EXAMPLES USE WINSCP TO EXECUTE ATTACHED FILE ON LINUX test_data.sql 첨부했음 (includes tables used in examples) 1. student table, jumin 칼럼사용 8월달 이름 생년월일 출력 ANSWER) select name, substr(jumin,1,8) from student where substr(jumin,4,1) = '8'; 2. student table, 전공이 101번 이름 전화번호 지역번호 출력 ANSWER) select name, tel, substr(tel, 1, instr(tel,')')-1) from student where deptno1=101; 3. student ..

단일 함수 -연산자 연결연산자 : column||'comment'||column in(a,b,c) -distinct 중복된 값 제거 select distinct column like 특정패턴 ex)where name like '김%' 'ㅈ'자로 시작하는 where name between '자%' and '차&' --------------------------------------------------------------------- 문자함수 initcap() lower() length() lengthb() contact('A','B') 결합해서 출력 substr('ABC',1,2) AB substrb('한글',1,2) 한 lpad('love',6,'*') **love ltrim('*love','*') ..

Oracle 10g RAC (Real Application Cluster) RHEL4 ASM mode Download Software 1. Minimum of 40GB Spare Disk 2. VM-Ware Work Station 8.0 3. RHEL4-U3-i386-AS-disc1~4.iso 4. Oracle 10g database package zip file 5. Oracle 10g clustware package zip file 6. Oracle 10g 1024 patch Rac 1 Server Operating System Installation Rac1 Server OS : Linux Version : RHEL 4 Virtual Machine Setting location : C:\Virtua..

http://www.jigi.net/4205 http://jeeomlove.tistory.com/19 http://blog.naver.com/PostView.nhn?blogId=sanai0419&logNo=90132524147&viewDate=&currentPage=1&listtype=0

Oracle 9i Install - Oracle Universal Installer Engine PatchSet DB Materials => patch patchset rpm fonts ship_9204_linux_disk1~3.cpio, jdk118_v3_glibc-2.1.3.tar.bz2 jre118_v3_glibc-2.1.3.tar.bz2 -patch -patchset -rpm -fonts ENGINE INSTALLATION 1. Add Group & User and User's Home Directory Group : dba User : oracle password : oracle Home Directory : /home/oracle ]#group add -g 5000 dba ]#useradd -..

php5.3.3 wget http://museum.php.net/php5/php-5.3.3.tar.gz mysql-5.1.59 wget http://downloads.mysql.com/archives/mysql-5.1/mysql-5.1.59.tar.gz

CONFIGURING MAIL SERVER . SENDMAIL Basically, the following main components are forming mail server. MUA (MAIL USER AGENT ) : The email application that a user sends/receives MTA (MAIL TRANSFER AGENT) : The server agent that responds to send request from user MDA (MAIL DELIVERY AGENT) : The server agent also that receives email from MTA and deliver to users mail box MRA (MAIIL RETRIEVAL AGENT) :..

FTP 서버 구축. VSFTPD FTP : FILE TRANSFER PROTOCOL 파일의 업로드 및 다운로드 하는 서비스를 제공 준비물 1. 전체적인 흐름 전체적인 과정을 알고 가자. ftp라는 서비스를 웹에서 제공하자! -> 그럼 URL을 ftp://naver.com으로 한다고 하자 -> 도메인 등록해야된다. 다행히 우리는 DNS서버를 구축했다. /var/named 에 이미 있는 naver.com.zone 파일에 ftp형식의 도메인을 추가해주자. -> ftp라는 서비스를 이용하려면 프로그램이 필요하다. 두가지가 있다 VSFTPD(Very Secure FTPD)와 PROFTPD가 있다. 요즘 추세는 VSFPTD이니까 소스 컴파일식으로 설치 -> 디렉토리는 /usr/local 안에 -> ftp는 파일을 ..