GG_INST APEX Table Def

[code language=”sql”] CREATE TABLE "GG_INST" ( "GG_IN_ID" NUMBER, "GG_IN_DSC" VARCHAR2(4000), "GG_IN_NM" VARCHAR2(100), "GG_IN_VER" VARCHAR2(50), "GG_LST_PTCH" VARCHAR2(4000), "GG_SRV_HM" NUMBER, "GG_SRV_FO" NUMBER, "GG_INST_CR_DT" TIMESTAMP (6), "GG_IN_CLS_NM" VARCHAR2(4000), "GG_IN_HST_NM" NUMBER, "GG_SRC_DB" NUMBER, "GG_XAG" VARCHAR2(1), "GG_CRS_ENTRY" VARCHAR2(4000), CONSTRAINT "GG_INST_PK" PRIMARY KEY ("GG_IN_ID") USING INDEX ENABLE ) ; CREATE OR REPLACE TRIGGER "BI_GG_INST" before insert on "GG_INST" for each row […]

DBAdmin Tables

CREATE TABLE “CT” ( “CT_ID” NUMBER, “CT_CD_TR” VARCHAR2(4000), “CT_LCL_HM_LNK” VARCHAR2(4000), “CT_HST” VARCHAR2(10), “CT_DB” VARCHAR2(10), “CT_ASGN_TO” VARCHAR2(4000), “CT_ASGN_DT” VARCHAR2(4000), “CT_ASGN_BY” VARCHAR2(4000), “CT_CMTS” CLOB, “CT_ACFS_HOME” VARCHAR2(4000), “CT_CLS” VARCHAR2(4000) ) ;   CREATE TABLE “CUSTOMER” ( “CST_ID” NUMBER, “CST_NM” VARCHAR2(100), “CST_TP” NUMBER, “CST_TEL_NBR” VARCHAR2(15), “CST_EML” VARCHAR2(100), “CST_CMT” VARCHAR2(4000), “CST_PRI_CNT” VARCHAR2(75), “CST_PRI_TEL” VARCHAR2(15), “CST_PRI_EML” VARCHAR2(100), “CST_LOB” VARCHAR2(20), “CST_DPT” VARCHAR2(20), […]

Update page process

This is the code for the select on the region for instances [code language=”sql”] Region select code select * from hc_instance where :P612_HC_DB_ID = db_id   [/code] This is the code for the Page Process for the insert, here we are inserting a record, then updating the value for the next time it refreshes the […]

bounce_apex.ksh

[code language=”sql”] #!/bin/ksh ############################################################################ # Script Name..: # Description..: This script will reset the APEX port in case of hang # Author…….: Michael Culp # Date………: 10/11/2009 # Version……: 2.1 # Modified By..: # Date Modified: # Comments…..: # Schema owner.: # alter session set current # Login User…: # Run Order….: # Dependent on.: […]

105_cr_dba01.ksh

[code language=”sql”] #!/bin/ksh # This script assigns the user that will be used in oracle to access tables in APEX # M. Culp # 11/06/2010 # 01/04/2010 Made changes to reflect the LS commands # 02/03/2010 # This should give access to the user in APEX that this is going against # connect dba01/password; # […]

DBAdmin Databases Section 02

DBAdmin Database(s) The DBAdmin system at the core is just a simple database an can be used in and of itself. There are approximately 100+ tables that make up the Oracle DBAdmin database and it currently runs on a VM and non-RAC version of Oracle.  Each database is accessed by the Oracle database through the […]