metanett

When you use Excel worksheet, sometimes, you will meet this problem: how could you convert or transpose a range of data into a single column? (See the following screenshots:) Now, I introduce three quick tricks for you to solve this problem. SOLUTION  The following long formula can help you quickly transpose a range of data into a column, please do as this: 1. First, define a range name for your range of data, select the range data that you want to convert, right click and choose  Define Name  form the context menu. In the  New Name  dialog box, enter the range name you want. Then click  OK . See screenshot: 2. After specify the range name, then click a blank cell, in this example, I will click cell E1, and then input this formula: =INDEX(MyData,1+INT((ROW(A1)-1)/COLUMNS(MyData)),MOD(ROW(A1)-1+COLUMNS(MyData),COLUMNS(MyData))+1) . Note :  MyData  is the range name of the selected data, you can change it as you need. 3. Then drag the formula down to the cel

This example shows two ways to  compare text  in  Excel . One is case-sensitive and one is case-insensitive. 1. Use the EXACT function (case-sensitive). 2. Use the formula =A1=B1 (case-insensitive).

I have this requirement many times while coding interfaces in oracle apps. Every time, I use different options.    Here, I tried to list out the four different ways of achieving the same. Let’s take the well-known SCOTT schema for our example. The requirement is to show the manager name along with sub-ordinate names in a comma separated list. So first, let us simply join the tables to see the records, OPTION 1: LISTAGG function ( Tested in Oracle 11g) SELECT     manager . ename manager ,           LISTAGG ( suboridinates . ename , ',' )   WITHIN   GROUP   (order   by suboridinates . ename )  suboridinates_list      FROM  emp suboridinates ,  emp manager     WHERE  manager . empno  =  suboridinates . mgr     GROUP   BY    manager . ename ORDER   BY  manager . ename ; OPTION 2: WM_CONCAT function (Tested in 11g version) Caution: This function is undocumented and unsupported by Oracle SELECT     manager . ename manager ,          

I made my first browser extension on Chrome. It's about saving current episodes for your series. Most of us have a trouble to remember the following part of series. You can add your tv-show with current season and episode in a seconds. After watchig, just click on UP button and it will count for you :) If you want to add it your own Chrome, you can use following link. https://chrome.google.com/webstore/detail/track-your-series/haahcjpkljcjfjldgcllmkpojfbgjfaf?utm_source=gmail

It's easy to migrate your on premise database and application to cloud. Let's watch !

Here is a WF query for EBS. If you want to see all process and activities on DB instead of status monitor for a completed workflow, it can be useful for you. Just give ITEM_KEY and  ITEM_TYPE parameter and wait for the response. It can takes 3-5 minutes if you are not purging old workflows. SELECT sta.item_type item_type,          sta.activity_result_code result,          pra.process_name || ' : ' || pra.instance_label process_activity_label,          sta.process_activity instance_id,          sta.item_key item_key, sta.begin_date     FROM wf_item_activity_statuses sta, wf_process_activities pra    WHERE     sta.item_key = p_item_key          AND sta.item_type = p_item_type          AND sta.activity_status = 'COMPLETE'          AND sta.process_activity = pra.instance_id ORDER BY sta.begin_date ASC;

Problem: How to convert number to word? Example: You need to write po amount in a word format for a report.  98  >>> Ninety-eight Solution: You can use following package for this operation. SELECT ap_amount_utilities_pkg.ap_convert_number( 9815 )  AMOUNT  FROM dual; Probably, you want to take this query in your local language. If so, you must change your NLS_LANGUAGE first. ALTER   SESSION   SET   NLS_LANGUAGE   =   'TURKISH' ; Then, SELECT ap_amount_utilities_pkg.ap_convert_number( 9815 )  AMOUNT  FROM dual; Note: This package supports 12 digit  most  .