Tags » Query

The Slow Edit

Torture at its finest, the slow edit is by far  my least favorite stage of writing a book. In happier news, starting in January, I will begin querying literary agents. 249 more words

Featured

Enabling SQL trace for Deadlock and simulating deadlock

To Enable deadlock traces in global level in situations where we cannot predict when the deadlock will occur i have used the following methods after googling few sites. 494 more words

SQL

Sorting retrieved records in workflow

Hi. What would be the best way to sort records retrieved by Retrieve Record or Query Task in workflow? If I get x number of records retrieved by task and I want to process them based on some field in retrieved record what would be the most efficient way to do so? 25 more words

Platform

Get lookup table from lookup transformations

SELECT DISTINCT
    OSUB.SUBJ_NAME AS FOLDER,
    OWA1.WIDGET_ID,
    ALL_MAP.MAPPING_NAME, 
    RWI.INSTANCE_NAME LKP_NAME, 
    DECODE (OWA2.ATTR_ID, 2, OWA2.ATTR_VALUE) AS TABLE_NAME,
    NVL2(DECODE (OWA1.ATTR_ID, 1, OWA1.ATTR_VALUE), 'YES', 'NO') AS SQL_O
FROM  
    OPB_WIDGET_ATTR OWA1,
    OPB_WIDGET_ATTR OWA2,
    REP_ALL_MAPPINGS ALL_MAP, 
    REP_WIDGET_INST RWI,
    OPB_SUBJECT OSUB
WHERE 
  ALL_MAP.MAPPING_ID = RWI.MAPPING_ID
  AND OWA1.WIDGET_ID = OWA2.WIDGET_ID
  AND ALL_MAP.SUBJECT_ID = OSUB.SUBJ_ID
  AND RWI.WIDGET_ID = OWA1.WIDGET_ID
  AND RWI.WIDGET_TYPE = 11
  AND OWA1.WIDGET_TYPE = 11
  AND OWA1.ATTR_ID = 1
  AND OWA2.ATTR_ID = 2
ORDER BY 1,5;
Etl

Query Critique 34

Dear Agent,

Any human servant would choose the workhouse over Evlalia – and her most recent two just have. Evlalia isn’t a common name, so it took me a minute to understand that that’s who “her” referred to. 573 more words

Query Critiques

Spiffy Up Before You Query

The time to tweak your manuscript is BEFORE you query any editor. I know it seems that editors have oodles of freebie time, lunching and laughing uproariously with lovely agents, who pick up the tab. 330 more words

Publishing