view counter

CRM & Siebel Feed

Oracle customer relationship management (CRM), Oracle CRM On Demand and Oracle Siebel resources, news, and support articles.

Combining Similar Rows

First, we create a table named combine test; CREATE TABLE combine_test AS     SELECT 100 eft_no, 4 bank_code, NULL eft_amount, ‘success’ eft_desc FROM DUAL UNION ALL        SELECT 100, 2, 100, NULL  FROM DUAL UNION ALL        SELECT 120, 4, NULL, ‘pending’ FROM DUAL UNION ALL        SELECT 120, [...]

Lead() function

If we had an orders table that contained the following data: ORDER_DATE PRODUCT_ID QTY 25/09/2007 1000 20 26/09/2007 2000 15 27/09/2007 1000 8 28/09/2007 2000 12 29/09/2007 2000 2 30/09/2007 1000 4 And we ran the following SQL statement: select product_id, order_date,  lead (order_date,1) over (ORDER BY order_date) AS next_order_date from orders; It would return the following [...]

Lag() function

If we had an orders table that contained the following data: ORDER_DATE PRODUCT_ID QTY 25/09/2007 1000 20 26/09/2007 2000 15 27/09/2007 1000 8 28/09/2007 2000 12 29/09/2007 2000 2 30/09/2007 1000 4 And we ran the following SQL statement: select product_id, order_date,  lag (order_date,1) over (ORDER BY order_date) AS prev_order_date from orders; and the result is… PRODUCT_ID [...]

Difference betweeen rank and dense_rank

Partition is made over dept_no and ordered by salary for both rank and dense_rank. They both make the same job except the numeric ranking. The same number is assigned for records with the same order value in both of them. At dense_rank, the numeric assignment is made sequentially for next row. But in rank, it is not [...]

Advenced Queuing (AQ)

there are not so many stuff about advanced queues for beginner level. this example may help you to figure out.. -- to create queue, some grants are given to our user GRANT "AQ_ADMINISTRATOR_ROLE" TO YTS; GRANT "AQ_USER_ROLE" TO YTS; GRANT EXECUTE ON SYS.DBMS_AQ TO YTS; -- queue table is created BEGIN SYS.DBMS_AQADM.CREATE_QUEUE_TABLE ( QUEUE_TABLE => [...]

explain plan script

this is a small hint to get a guick EXPLAIN PLAN when your ambulance button is not working at TOAD and you have limited time   EXPLAIN PLAN FOR SELECT * from something;       set pagesize 25  set linesize 121 SELECT * FROM TABLE(dbms_xplan.display);   just run this as script.. Tagged: Oracle, pl/sql, [...]

Siebel User Group Australia Event – 21 August

There’s another Siebel User Group event coming up in Sydney. On Thursday 21st August we’re back at the Australia Graduate School of Management for a panel discussion on The Single View of a Customer – Myth or Reality?
I’m personally interested to hear the panellists’ experiences with building business processes around search. Being able to locate [...]

Workflow to process multiple rows

There’s no standard loop construction (For/While/Do) in Siebel Workflow, but there are still a couple of ways to have a Workflow Process handle multiple rows.
Update Operation
For a simple update to a child entity use a Siebel Operation. When a Workflow Process has a Business Object then a Siebel Operation Update step defined for a child [...]

Browser Script “on the fly”

Top tip today from Neel over at Siebel Unleashed: using the IE address bar to enter browser script.
I’ve never thought of this, and the key point is worth repeating: script entered into the address bar after a javascript tag is executed by the browser, in exactly the same way as browser script. This means that [...]

Talking Chalk at Web 2.0 Expo 2008

So what have I been up to recently on the blog front...experimenting with what I hope is more engaging content. Here's my first attempt using slideshare.net to record my chalk talk at Web 2.0 Expo 2008.

view counter