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, [...]
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 [...]
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 [...]
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 [...]
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 => [...]
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, [...]
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 [...]
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.
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 [...]
Top tip today from Neel over at Siebel Unleashed: using the IE address bar to enter browser script.
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.