How to Execute DDL commands in Oracle Forms

DDL (Data Definition Language) commands like CREATE, DROP and ALTER are not directly supported in Oracle Forms because Oracle Form is not supposed to manipulate the database structure.
A statement like CREATE TABLE X (A DATE); will result in error:
Encountered the symbol "CREATE" which is an reserved word.
However, you can use the FORMS_DDL built-in to execute DLL statements. Eg:
FORMS_DDL('CREATE TABLE X (A DATE)');


Oracle Forms Developer -- The Complete Video Course




Comments

  1. UnknownJuly 23, 2020 at 10:39 PM

    Thanks for sharing valuable information and very nice article. Keep posing.

    workday studio online training hyderabad
    workday studio online training india

    ReplyDelete
  2. Ezra AbramJanuary 29, 2021 at 1:47 AM


    Thanks for the nice blog here.I was searching this one for a long time.This blog is very helpful for my studies..I got another one site also,which is same as yours Oracle BPM.Check this one also Oracle Fusion HCM Sure it will be helpful for you too..Once more iam thanking you for your creative blog.

    ReplyDelete
  3. Keerthi55April 30, 2021 at 7:30 PM

    I really enjoy the article. Thanks Again. Fantastic.
    data science training
    python training
    angular js training

    ReplyDelete
  4. edigPpromka-2000April 23, 2022 at 9:29 AM

    edigPpromka-2000 Adrian Viher https://wakelet.com/wake/ab6-bul_h7x4dGYyQxtM9
    almeseari

    ReplyDelete
  5. apelFinfuAugust 25, 2022 at 3:40 PM

    AnoreVpe-fu Byron Mancuso WinRar
    Bandicam
    Eset NOD 32
    dragerroca

    ReplyDelete
  6. orabAin-deNovember 30, 2022 at 10:10 AM

    probadOtrac-shi Thomas Newman Click here
    Free download
    maesuncopa

    ReplyDelete

Post a Comment

Popular posts from this blog

What is Oracle Integration Cloud Service - ICS?

Image
Oracle Integration Cloud Service (ICS) is a solution that enables you to simplify integrations between cloud applications, and between cloud and on premises applications. It helps you create connections to well-known and less-known SaaS and PaaS applications, using the available cloud adapters, publish or subscribe to the Messaging Cloud Service, or use industry standards such as SOAP, REST, FTP, File, and JMS. For more information watch this Oracle video.
Read more

How to Create Packages in Oracle Database using TOAD for Oracle

Image
What are Packages in Oracle Database A package is a group of procedures, functions, variables and SQL statements created as a single unit. It is used to store together related objects. A package has two parts, Package Specification and Package Body. Package Specification Package Specification acts as an interface to the package. Declaration of types, variables, constants, exceptions, cursors and subprograms is done in Package specifications. Package specification does not contain any code. Package Body Package body is used to provide implementation for the subprograms, queries for the cursors declared in the package specification.
Read more

How to create a Simple Scheduler Job in Oracle Database using Toad

Image
Scheduler is a process which runs programmed jobs at scheduled times. This process wakes up at the specified time and runs automatically. The basic elements of the scheduler are: Jobs Schedules Programs A job specifies what needs to be executed and when. A program is a collection of metadata that will be executed by the scheduler. It contains the name of the program (a procedure or an executable, the type of the program (pl/sql block, shell script etc). A schedule specifies when and how many times a job is executed. 1. Login to the database using Toad, and create a Scheduler Job as follows;
Read more