匠人学院 JR Academy学AI来匠人
匠人学院 JR Academy学AI来匠人

Follow Us

linkedinfacebooktwitterinstagramyoutube

We Accept

/image/layout/pay-paypal.png/image/layout/pay-visa.png/image/layout/pay-master-card.png/image/layout/pay-airwallex.png/image/layout/pay-alipay.png
EN

Company

About UsMetaverse ClassroomNews & BlogJR CareersBecome a MentorOur MentorsContact UsJR Store J3.Club

Resources

Job ReferralsEvents1-on-1 TutoringIndustry WhitepapersOnline LearningInterview CenterShare Interview ExperienceInternshipMembership

AI Tools

AI ToolboxCert MasterJob HunterUniMate AI

AI Learning Paths

All Learning PathsAI EngineerContext EngineeringVibe CodingPrompt MasterAI BuilderAI Product ManagerPython Basics

AI in Practice

AI ProductivityAI Data AnalysisAI FinanceAI Content CreationAI Image CreationFrontend DevelopmentHermes AgentOpenClaw Local Agent

University Resources

University of MelbourneUniversity of QueenslandUNSW SydneyUniversity of SydneyMonash UniversityUniversity of AdelaideRMITQUTUTS

Kids AI Education

Airbotix — AI Coding for KidsAU Family Resource HubNAPLAN Report GuideMy School Data GuideSydney Private School Fees 2026Kids Coding Programs

Immigration Services

Australia ImmigrationSkilled Visa 189/190/491Employer Sponsored 482/186/494Business Visa 188/888UK ImmigrationUS ImmigrationCanada Immigration

Enterprise

P3 Career IncubatorEnterprise (EN)Corporate TrainingInternship PartnershipRecruitment PartnershipApply for Partnership

Job Application Agent

Job Application ServiceJob MonitoringLinkedIn ManagementLinkedIn NetworkingLearn about P3

Support

FAQsTerms & ConditionsPrivacy PolicyCancellation & Refund PolicySite map

Top Categories

Web Full-Stack BootcampDevOps BootcampData Engineering BootcampData Analysis BootcampCoding for BeginnersBusiness Analyst InternshipAlgorithm Bootcamp

Career Services

BA & PM InternshipData Science InternshipData Analysis InternshipMarketing InternshipResume ReviewInterview CoachingVIP Mentor Guidance

Addresses

Level 10b, 144 Edward Street, Brisbane CBD(Headquarter)
Level 2, 171 La Trobe St, Melbourne VIC 3000
45A13, Block B, Oriental Hope Tianxiang Plaza, 500 Tianfu Avenue Middle Section, Wuhou District, Chengdu, Sichuan, China
Business Hub, 155 Waymouth St, Adelaide SA 5000

Contact

hello@jiangren.com.au0421-672-555

Disclaimer

footer-disclaimerfooter-disclaimer

JR Academy acknowledges Traditional Owners of Country throughout Australia and recognises the continuing connection to lands, waters and communities. We pay our respect to Aboriginal and Torres Strait Islander cultures; and to Elders past and present. Aboriginal and Torres Strait Islander peoples should be aware that this website may contain images or names of people who have since passed away.

All content on the JR Academy website, including course materials, logos, and information provided, is protected under Australian intellectual property laws. Unauthorized use, sale, distribution, reproduction, or modification is strictly prohibited. Violations may result in legal action. By accessing our website, you agree to respect our intellectual property. JR Academy Pty Ltd reserves all rights, including patents, trademarks, and copyrights. Any infringement will be subject to legal prosecution. View Terms of Service

© 2017-2026 JR Academy Pty Ltd. All rights reserved.

ABN 26621887572

Certifications/Oracle/Oracle 1Z0-149
Oracle助理级💾 数据库

Oracle Database: Program with PL/SQL (1Z0-149)

Oracle Database PL/SQL exam prep covering block structure, variables, cursors, exceptions, procedures, functions, packages, triggers, dynamic SQL, and collections. Includes 48 practice questions with explanations, a 120-minute exam format, and a 63% passing score.

Start PracticeBrowse Learning Path
63
Questions per exam
48
Question bank total
120m
Exam Duration
63/100
Passing Score
$245
Exam Fee

At a glance

48 questions
Best forOracle developers writing PL/SQL for application and database work, Database professionals who need a practical PL/SQL credential
Prep pace4-6 weeks with experience
Course pack7 chapters · 28 hours
Learner signal0 enrolled · 0/5
Exam Guide
?
Bottom line · It depends

1Z0-149 是 Oracle PL/SQL 开发的经典 OCP 考试 — 如果你在写存储过程、触发器、包的 Oracle 项目里工作，这张证直接对口；做应用层 Java/Python 开发的人不需要。

What this certification covers

This page is structured for quick scanning first: exam format, fit, prep time, and the actual study scope.

Oracle Database: Program with PL/SQL (1Z0-149) 验证 PL/SQL 编程能力，63 题 / 120 分钟，及格线 63%（约 40 题），费用 $245 USD。这是 Oracle Database PL/SQL Developer Certified Professional (OCP) 的核心考试之一。

考试覆盖 PL/SQL 的全部核心功能：匿名块和命名块、变量声明和赋值、条件语句和循环、显式游标（Cursor）和隐式游标、异常处理（预定义异常 + 自定义异常 + PRAGMA EXCEPTION_INIT）、存储过程和函数、包（Package Spec + Package Body）、触发器（DML/DDL/Database Event/INSTEAD OF）、动态 SQL（EXECUTE IMMEDIATE/DBMS_SQL）。

PL/SQL 在云原生和微服务时代看似过时，但在银行核心系统（Oracle Financials/FLEXCUBE）、电信计费系统（Oracle BRM）、政府 ERP（Oracle E-Business Suite）中仍然是主力语言。这些系统的业务逻辑大量写在数据库存储过程里，短期内不会重写。

You will work with

Oracle 技术数据库管理系统架构性能优化故障排除

After preparation

  • Prepare for the Oracle 1Z0-149 exam with a practical study plan
  • Write PL/SQL blocks, subprograms, packages, triggers, and dynamic SQL with more confidence
  • Handle cursors, exceptions, and collections in a cleaner way
  • Improve your fit for Oracle database development and programming roles

Exam details

Exam Code
1Z0-149
Provider
Oracle
Duration
120 minutes
Question Count
63 questions
Passing Score
63/100
Validity
0 years
Exam Fee
$245 USD
Question Types
Single choice, Multiple select
Languages
English, 日本語
Official Page
Open AWS page

Who should take it

Good fit

  • Oracle developers writing PL/SQL for application and database work
  • Database professionals who need a practical PL/SQL credential
  • IT staff preparing for Oracle database programming roles
  • Engineers who want stronger Oracle support and development skills

Before you start

  • Basic Oracle database knowledge is recommended
  • You should be comfortable with SQL before starting
  • Some hands-on database programming or support experience will help

Is it worth it? Career value

Salary ranges, target job titles, and the real career impact of holding Oracle 1Z0-149.

澳洲
$95K-140KAUD
美国
$90K-135KUSD
中国
¥200K-380KCNY
PL/SQL DeveloperOracle Database DeveloperERP Technical ConsultantOracle 数据库开发

PL/SQL Developer 在澳洲的需求集中在金融（CBA/Westpac 的 Oracle Financials 团队）和政府部门（Service NSW、Defence）。Seek 上 "PL/SQL Developer" 年薪中位数约 $115K AUD。

1Z0-149 和 1Z0-071（SQL）组合可以获得 Oracle Database PL/SQL Developer OCP，这是 Oracle 开发方向的权威认证。单独 1Z0-149 不够，需要配合 SQL 考试。

不适合的人群：做前端/移动端/云原生微服务的开发者 — PL/SQL 是数据库内嵌的过程化语言，和你的日常工作没有交集。学 Python/Java 写 ORM 操作数据库的人也不需要 PL/SQL 认证。

Study preparation

With hands-on AWS

4-6 weeks

From scratch

8-12 weeks

Daily pace

1-2 hours/day

Learning path preview

7 chapters
1
1Z0-149 Exam Overview and Study Plan
30 min
2
PL/SQL Blocks and Variables
60 min
3
Cursors and Exception Handling
70 min
4
Stored Procedures and Functions
80 min
5
Package Design and Triggers
90 min
6
Dynamic SQL and Collections
100 min
+ 1 more chapters inside the full path

Step-by-step preparation

A concrete week-by-week plan from past test-takers — not generic advice.

1

第一阶段：PL/SQL 基础语法（2-3 周）

在 Oracle XE 或 Oracle Live SQL 上练习。DECLARE-BEGIN-EXCEPTION-END 块结构、变量声明（%TYPE/%ROWTYPE）、IF-THEN-ELSIF-ELSE、CASE、LOOP/WHILE/FOR 循环。重点练习显式游标（CURSOR FOR loop vs OPEN-FETCH-CLOSE 两种写法）和 REF CURSOR（动态游标）。

2

第二阶段：存储过程 + 包 + 触发器（2-3 周）

CREATE OR REPLACE PROCEDURE/FUNCTION 的参数模式（IN/OUT/IN OUT）和 NOCOPY hint。Package Spec（声明）和 Package Body（实现）的分离机制、Package 初始化块。触发器类型：BEFORE/AFTER + INSERT/UPDATE/DELETE 的 12 种组合、:NEW/:OLD 伪记录、INSTEAD OF 触发器（用于视图 DML）。触发器的执行顺序（Statement-level BEFORE → Row-level BEFORE → DML → Row-level AFTER → Statement-level AFTER）。

3

第三阶段：异常处理 + 动态 SQL + 模考（2 周）

预定义异常（NO_DATA_FOUND/TOO_MANY_ROWS/ZERO_DIVIDE/DUP_VAL_ON_INDEX）的触发条件。PRAGMA EXCEPTION_INIT 绑定自定义异常到 Oracle 错误码。RAISE_APPLICATION_ERROR（-20000 到 -20999 范围）。EXECUTE IMMEDIATE 的 USING 和 INTO 子句。用 Enthuware 1Z0-149 或 Whizlabs 做 2 次模考。

Real test-taker experiences

What it actually took for real candidates to pass — prep time, scores, and lessons learned.

工作中天天写 PL/SQL 但考试比想象中细 — 触发器的执行顺序（Statement BEFORE → Row BEFORE → DML → Row AFTER → Statement AFTER）出了 3 道。Package 初始化块的执行时机（第一次调用包中任何元素时执行一次）也考了。

Oracle 开发 5 年75%
银行 Oracle Financials 团队 · 4 weeks prep

PL/SQL 的语法和 Java 差异很大 — 没有类和对象的概念，全是过程化编程。游标（Cursor）的概念对我来说最陌生，花了 3 周才理解显式游标 vs 隐式游标 vs REF CURSOR 的使用场景。

Java 开发转 Oracle65%
后端 3 年，刚接触 PL/SQL · 10 weeks prep

Certification comparison

Oracle 1Z0-149Oracle 1Z0-071Oracle 1Z0-082
ProviderOracleOracleOracle
Level助理级助理级助理级
Fee$245$245$245
Duration120 min120 min120 min
Questions per exam637368
Validity0 yrs0 yrs0 yrs

Study tips and common mistakes

💡

63 题 120 分钟，约 1.9 分钟/题。代码阅读题需要手动追踪变量值和游标状态。

💡

RAISE_APPLICATION_ERROR 的错误码范围是 -20000 到 -20999，其他范围是 Oracle 保留的。考试可能给一个超出范围的错误码问"会发生什么"。

💡

Package 题注意区分 Spec 和 Body — Spec 是接口（其他程序只能看到 Spec 中声明的元素），Body 是实现（可以包含 Spec 中未声明的私有元素）。

⚠️

**%TYPE 和 %ROWTYPE 混淆** — %TYPE 取单个列的数据类型（v_name employees.first_name%TYPE），%ROWTYPE 取整行的结构（v_emp employees%ROWTYPE）。考试至少 2 道。

⚠️

**触发器的 :NEW 和 :OLD 限制** — INSERT 触发器只有 :NEW（没有 :OLD），DELETE 触发器只有 :OLD（没有 :NEW），UPDATE 两者都有。在不存在的伪记录上引用字段会编译通过但运行时得到 NULL。

⚠️

**EXCEPTION WHEN OTHERS 的位置** — WHEN OTHERS 必须是最后一个异常处理分支，放在其他异常前面会导致编译错误。

Frequently Asked Questions

If you plan to take Oracle 1Z0-149, start with real practice.

48 questions, chapter-by-chapter learning, mock exams, wrong-question review, and AI tutor support live in the exam page.

Go to exam prep

From $29 · 2 free chapters

Student reviews

Loading reviews…

Related certifications

Oracle 1Z0-071

Oracle · 助理级
$24573 questions120 min

Oracle 1Z0-082

Oracle · 助理级
$24568 questions120 min

Oracle 1Z0-078

Oracle · 专业级
$24570 questions120 min
EXAM PREP

Oracle 1Z0-149 Question Bank

Chapter-by-chapter learning + mock exams + AI tutor

48
Questions
7
Chapters
28h
Study
AI
Tutor
  • First 2 chapters free
  • Real exam format mock tests
  • AI-powered wrong answer review
  • Chapter progress tracking
From $29
Start Practice Now

Prep snapshot

Study chapters7
Practice questions48
Estimated hours28h

What is inside

  • 48 practice questions built around the real PL/SQL topics in the exam
  • Coverage of blocks, cursors, exceptions, procedures, packages, triggers, dynamic SQL, and collections
  • Mock exam aligned to the 63-question, 120-minute format
  • Plain explanations that focus on how PL/SQL behaves in practice
  • A study flow that starts with core syntax and ends with exam-style scenarios