Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
CREATE TABLE SHIFT_SUMMARY_NEW ( SRNO NUMBER, YEAR NUMBER(4), MONTHS VARCHAR2(3), DBA_NAME VARCHAR2(50), SUN VARCHAR2(50), MON VARCHAR2(50), TUE VARCHAR2(50), WED VARCHAR2(50), THU VARCHAR2(50), FRI VARCHAR2(50), SAT VARCHAR2(50) ); CREATE SEQUENCE SHIFT_SUMMARY_NEW_SEQ MINVALUE 1 START WITH 1 INCREMENT BY 1 CACHE 20; CREATE OR REPLACE TRIGGER "MGMT"."SHIFT_MASTER_NEW_BR_I" before insert on "SHIFT_SUMMARY_NEW" for each row begin if :NEW."SRNO" is null then select "SHIFT_SUMMARY_NEW_SEQ".nextval into :NEW."SRNO" from dual; end if; end; / ALTER TRIGGER "MGMT"."SHIFT_MASTER_NEW_BR_I" ENABLE;
|Not able to drop or recreate an Oracle stored procedure||1||39|
|create a nested synonym||4||28|
|Assistance required for troubleshooting an issue - ORA-12154: TNS error - MS SQL Server 2008||3||42|
|SQL2016 to ORACLE11G linked-server||6||28|