Part of Slepp's Projects — Pastebin — TURL — Imagebin — Filebin
Feedback -- English French German Japanese
Create Upload Newest Tools Donate
Sign In | Create Account

Advertising

advertising

related pastes to tag 'oracle'

1517636 - Oracle_SP: oracle work sp ubs
  1. CREATE OR REPLACE procedure SKEMAIN.clearDownUserX(
  2.   userName users.LOGINNAME%type)
  3. AS
  4. begin
  5. -- all active cancel requested or requested orders set to cancelled and inactive.
  6.   UPDATE orders SET
  7.       active = 0,
  8.       stateId = 7
  9.  
967907 - hali: oracle constraints
  1. SELECT
  2. CON.CONSTRAINT_NAME COL_NAME,
  3. CON.TABLE_NAME FK_TABLE,
  4. COL.COLUMN_NAME FK_COL,
  5. COLFK.TABLE_NAME PK_TABLE,
  6. COLFK.COLUMN_NAME PK_COL
  7. FROM
  8. USER_CONSTRAINTS CON, USER_CONS_COLUMNS COL,
  9.  
794351 - Create Historico: oracle create
  1. CREATE TABLE  "HISTORICO"
  2.    (    "SERIE" VARCHAR2(4000) NOT NULL ENABLE,
  3.         "AFILIACION" VARCHAR2(4000),
  4.         "COMERCIO" VARCHAR2(4000),
  5.         "ID_APLI" VARCHAR2(4000),
  6.         "FEC_MOV" DATE,
  7.         "ID_USR" VARCHAR2(4000),
  8.         "IMEI" VARCHAR2(4000),
  9.  
794349 - Create Historico: oracle create
  1. CREATE TABLE  "TERMINAL"
  2.    (    "SERIE" VARCHAR2(100) NOT NULL ENABLE,
  3.         "SERIE_INT" VARCHAR2(4000),
  4.         "TER_ID" VARCHAR2(4000),
  5.         "ID_MODELO" VARCHAR2(4000),
  6.         "ID_TIPEQ" VARCHAR2(4000),
  7.         "ID_APLI" VARCHAR2(4000),
  8.         "ID_FAB" VARCHAR2(4000),
  9.  
794348 - Create Historico: oracle create
  1. CREATE TABLE  "TERMINAL"
  2.    (    "SERIE" VARCHAR2(100) NOT NULL ENABLE,
  3.         "SERIE_INT" VARCHAR2(4000),
  4.         "TER_ID" VARCHAR2(4000),
  5.         "ID_MODELO" VARCHAR2(4000),
  6.         "ID_TIPEQ" VARCHAR2(4000),
  7.         "ID_APLI" VARCHAR2(4000),
  8.         "ID_FAB" VARCHAR2(4000),
  9.  
738705 - SKE Queries: oracle ubs ske
  1. SELECT count(*) FROM orderhistory WHERE orderid IN (SELECT id FROM orders WHERE traderuserid=21053);
  2.  
  3. DELETE FROM orderhistory WHERE orderid IN (SELECT id FROM orders WHERE traderuserid=21053);
  4.  
  5. DELETE FROM orders WHERE traderuserid=21053;
738611 - SKE Queries: oracle ubs ske
  1. SELECT count(*) FROM orderhistory WHERE orderid IN (SELECT id FROM orders WHERE traderuserid=19214);
  2.  
  3. DELETE FROM orderhistory WHERE orderid IN (SELECT id FROM orders WHERE traderuserid=19214);
  4.  
  5. DELETE FROM orders WHERE traderuserid=19214;
738610 - Oracle_SP: oracle work sp ubs
  1. CREATE OR REPLACE procedure SKEMAIN.clearDownUserX(
  2.   userName users.LOGINNAME%type)
  3. AS
  4. begin
  5. -- all active cancel requested or requested orders set to cancelled and inactive.
  6.   UPDATE orders SET
  7.       active = 0,
  8.       stateId = 7
  9.  
705509 - Oracle Script Final script oracle final
preview unavailable
609080 - hali: oracle service_names
  1. oracle@htpc:admin$ lsnrctl STATUS
  2.  
  3. LSNRCTL FOR Linux: Version 10.2.0.1.0 - Production ON 08-JUL-2007 18:31:22
  4.  
  5. Copyright (c) 1991, 2005, Oracle.  ALL rights reserved.
  6.  
  7. Connecting TO (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
  8. STATUS of the LISTENER
  9.  
worth-right
fantasy-obligation