how to create a table and set scale in oracle apex sql

Experienced in creating AWS EC2 instances.

Experienced in Data migration using Amazon DMS service.Implemented RMAN Backup and Recovery, Incomplete Recovery and disaster recovery using Data Guard.Performed Upgradation of databases from lower version (9i/10g) to higher version (11g).Created documentation, design and implemented rich user interfaces using Oracle Apex.Created Oracle Apex Application from Scratch.Experience of Oracle Golden Gate installation, configuration and troubleshooting Golden Gate Extract and Replicate issues.Installed and maintained Oracle 12c/11g/10g RAC with ASM & OCFS2 File systems.Migrated Databases into Exadata Machine with minimal downtime using Dataguard.Worked on Exadata Database Machine X2-2 Half Rack, X3-2.Expertise in setup/implementation/maintenance of Real-Application-Cluster (RAC) of 2/3 Node RAC on 10g/11g/12c.Configuration and Management of Data Guard 10g/11g on RHEL, OEL and Sun-Solaris for Disaster Recovery.Having good experience in configuring OEM 12C cloud control and monitoring databases using OEM 10g/11g/12c.Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM), TOAD, Oracle SQL Developer in various versions.Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB.Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.

ERP and Other Software Implementation Experience in multisite, multicurrency.Having Hands on experience working in both Application and Production support environment.Excellent experience in Installation, administration and troubleshooting of Oracle 12c/11g/10g/9i for OLTP (multiple instances)/ OLAP environment on Very Large or Highly Transactional Databases.Handful of experience in Oracle Installations, Upgrades, Patches, Critical Patch Updates (CPU) in various environment ranging from 9i/10g/11g/12c.Providing DBA support to MultipleCluster, Non-cluster and ASM Database in production, development and Testing Servers on UNIX, Linux and Solaris Environments.

Experience with very large scale database environments and mission critical OLTP and OLAP systems in high-availability environments.

Over 8+ years of professional experience as an Oracle Database Administrator having hands on experience in database administration production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, database security, cloning, migration, shell scripting and documentation, Setting up and configuring Data - guard, Replications using golden gate on Sun Solaris, Red Hat Linux, HP-UX, AIX, and Windows Platform.

How to create a table and set scale in oracle apex sql