1. Home
  2. /
  3. Oracle-forms-plsql Typing Test
  4. /
  5. Calculate Portfolio Variance

Calculate Portfolio Variance - Oracle-forms-plsql Typing CST Test

Skip to main content
CodeSpeedTest
Languages
Start TypingJump into a test — pick any languageAdaptive TrainingUnlock chars as you master themPractice DrillsFocused sessions targeting weak spotsDaily ChallengesNew coding challenges every dayRace ModeCompete against others in real timeAI OpponentRace against an AI at your WPM levelTournamentsLive coding speed tournamentsArcade GamesZType, Overkill Survival, Glyphica & moreGamificationXP, coins, badges & quests
LeaderboardGlobal rankings for every languageCertificatesEarn verifiable Bronze / Silver / Gold certsActivityDaily streaks & historical analyticsProfileYour stats, badges & achievements
Browse Languages500+ languages with real code examplesBlogTips, guides & deep divesFree ToolsWPM calculator, typing speed report & moreFAQCommon questions answeredGetting StartedNew to CodeSpeedTest?AboutOur story & missionSupportGet help — Pro users get priorityContactGet in touch with the team
Pricing
Mode:
Duration:
1
Coding works best on desktop or with an external keyboard.
CodeSpeedTest

Improve your coding speed, code accuracy, and programming syntax WPM with practice sessions across 500+ programming languages.

Quick Links

HomeAboutFeaturesGetting StartedLanguages

Legal & Support

Pro ⚡ PricingContactPrivacy PolicyTerms of Service

Connect

CodeSpeedTest on GitHubCodeSpeedTest on TwitterEmail CodeSpeedTest

© 2026 CodeSpeedTest. All rights reserved.

Calculate Portfolio Variance — Oracle-forms-plsql Code

Compute portfolio variance given weights and covariance matrix.

DECLARE
	weights SYS.ODCINUMBERLIST := SYS.ODCINUMBERLIST(0.6,0.4);
	cov_matrix SYS.ODCINUMBERLIST := SYS.ODCINUMBERLIST(0.0004,0.0002,0.0002,0.0003);
	portfolioVariance NUMBER;
BEGIN
	portfolioVariance := weights(1)*weights(1)*0.0004 + weights(1)*weights(2)*0.0002
		+ weights(2)*weights(1)*0.0002 + weights(2)*weights(2)*0.0003;
	DBMS_OUTPUT.PUT_LINE('Portfolio Variance: ' || portfolioVariance);
END;

Oracle-forms-plsql Language Guide

Oracle Forms is a software product for creating screens that interact with an Oracle database. PL/SQL is Oracle's procedural extension to SQL, allowing developers to write business logic, triggers, and stored procedures inside the database. Together, they provide a robust environment for developing enterprise applications.

Primary Use Cases

  • ▸Enterprise data entry and management systems
  • ▸Automated business workflows and approvals
  • ▸Database-triggered validations and constraints
  • ▸Financial and HR enterprise applications
  • ▸Legacy ERP systems built on Oracle databases

Notable Features

  • ▸Graphical user interface builder for database applications
  • ▸Integrated PL/SQL editor for business logic
  • ▸Triggers for validation, navigation, and automation
  • ▸Support for web deployment via Oracle Forms Services
  • ▸Tightly coupled with Oracle database for high performance

Origin & Creator

Oracle Corporation developed Oracle Forms in the late 1980s as a rapid application development tool for Oracle databases. PL/SQL was introduced in 1991 to extend SQL with procedural programming.

Industrial Note

Oracle Forms + PL/SQL is niche to Oracle database environments, mainly used in legacy enterprise applications, internal ERP, and large-scale administrative systems.

Quick Explain

  • ▸Oracle Forms enables rapid development of data entry and query applications.
  • ▸PL/SQL allows embedding business logic directly in the database.
  • ▸Forms and PL/SQL integrate tightly for validation, triggers, and workflows.
  • ▸Supports multi-tier applications with client-server or web deployment.
  • ▸Widely used in enterprise ERP, banking, and government applications.

Core Features

  • ▸Data block creation and form layout
  • ▸PL/SQL procedures, functions, and packages
  • ▸Form triggers for events like WHEN-VALIDATE-ITEM
  • ▸Report integration with Oracle Reports
  • ▸Menu, alert, and navigation management

Learning Path

  • ▸Learn basic SQL and Oracle database concepts
  • ▸Understand PL/SQL syntax and blocks
  • ▸Practice creating simple Oracle Forms
  • ▸Implement triggers and stored procedures
  • ▸Deploy forms in client-server and web environments

Practical Examples

  • ▸Employee data management form with validation triggers
  • ▸Invoice processing system with workflow automation
  • ▸Customer database form integrated with Oracle Reports
  • ▸PL/SQL-driven approval workflow for purchase orders
  • ▸Interactive dashboards for inventory management

Comparisons

  • ▸Oracle Forms vs APEX: Forms for legacy, APEX for modern web apps
  • ▸PL/SQL vs T-SQL: PL/SQL for Oracle databases, T-SQL for SQL Server
  • ▸Oracle Forms vs VB6/Delphi: Forms optimized for database-driven enterprise apps
  • ▸Oracle Reports vs JasperReports: Reports integration inside Oracle ecosystem
  • ▸Forms + PL/SQL vs Java web apps: Forms faster for rapid Oracle-based development

Strengths

  • ▸Rapid form-based development for Oracle databases
  • ▸Built-in database validation and triggers
  • ▸Stable and mature platform for large enterprises
  • ▸Strong integration with other Oracle tools
  • ▸Reduces repetitive coding for standard CRUD operations

Limitations

  • ▸Outdated UI for modern web/mobile apps
  • ▸Limited cross-database support
  • ▸Heavily tied to Oracle ecosystem
  • ▸Forms can be difficult to scale for very complex workflows
  • ▸Steep learning curve for advanced PL/SQL optimization

When NOT to Use

  • ▸Modern web/mobile application development
  • ▸Cross-database applications
  • ▸High-performance real-time systems
  • ▸Non-Oracle backend systems
  • ▸Projects requiring modern UI/UX design

Cheat Sheet

  • ▸Data Block - links form items to database table/view
  • ▸Item - field, button, or control in form
  • ▸Trigger - PL/SQL block executed on event
  • ▸PL/SQL Procedure - reusable logic in database
  • ▸Menu - defines navigation between forms

FAQ

  • ▸Is Oracle Forms free? -> No, requires Oracle license.
  • ▸Can I use PL/SQL outside Forms? -> Yes, directly in Oracle DB.
  • ▸Can Forms be deployed on web? -> Yes, via Oracle Forms Services.
  • ▸Do I need deep PL/SQL knowledge? -> Recommended for triggers and automation.
  • ▸Is Forms still relevant? -> Yes, for legacy enterprise Oracle apps.

30-Day Skill Plan

  • ▸Week 1: SQL and PL/SQL basics
  • ▸Week 2: Data block and form design
  • ▸Week 3: Implementing triggers and procedures
  • ▸Week 4: Forms navigation and alerts
  • ▸Week 5: Web deployment and integration with Reports

Final Summary

  • ▸Oracle Forms + PL/SQL enables rapid development of enterprise database applications.
  • ▸PL/SQL allows embedding complex business logic directly in the database.
  • ▸Ideal for legacy ERP, financial, and administrative systems.
  • ▸Supports client-server and web deployments.
  • ▸Mature, stable, and tightly integrated with Oracle ecosystem.

Project Structure

  • ▸Form files (.fmb)
  • ▸Compiled form files (.fmx)
  • ▸PL/SQL packages and procedures in database
  • ▸Menu and alert definitions
  • ▸Reports and supporting files

Monetization

  • ▸Enterprise application development services
  • ▸Oracle Forms maintenance and migration
  • ▸Custom workflow and reporting solutions
  • ▸PL/SQL optimization consultancy
  • ▸Training and workshops for legacy Oracle systems

Productivity Tips

  • ▸Use templates and libraries for common form items
  • ▸Precompile forms for faster deployment
  • ▸Reuse PL/SQL procedures across forms
  • ▸Leverage alerts and menu definitions
  • ▸Document form and trigger behavior for team collaboration

Basic Concepts

  • ▸Data Blocks - database tables or views linked to form items
  • ▸Items - fields, buttons, and controls in forms
  • ▸Triggers - PL/SQL blocks executed on events
  • ▸Procedures and Functions - reusable PL/SQL logic
  • ▸Menus and Navigation - flow control in forms applications

Official Docs

  • ▸https://www.oracle.com/tools/technologies/forms/
  • ▸https://docs.oracle.com/en/database/oracle/forms-and-reports/

More Oracle-forms-plsql Typing Exercises

Calculate Compound Interest in PL/SQLCompute Portfolio ReturnCalculate Forward PriceDiscount Future Cash FlowsCompute Sharpe RatioMonte Carlo Simulation for Option PricingCompute Correlation Between Two AssetsYield Curve ConstructionPresent Value of an Annuity

Practice Other Languages

CReactPythonC++RustTypeScriptKotlinPHPJavaC#RubyMqlCqlN1qlCypher