Download VCEM application on Google Play or internet by mobile. Use free online converter to convert VCE file to VCEM. http://upload.avanset.com/ Store converted .vcem file on your mobile if you have worked on Personal computer, then run VCEM application on mobile to test oracle certification exams.
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','*') ..