Affiliate / Ads Media For Newly Started Blogs

Displaying ads on blog is exciting because it gives you money too. But when you start a blog it is hard to get approved by the ads media because:
  • Your blog site might not getting enough traffic
  • Having not independent domain  name
  • You recently started.
Or any other reason

So here are some ads media references for your newly started blog:

    The below plsql program unit could be used in a WHEN-NEW-FORM-INSTANCE trigger to initially populate the hierarchical tree with data in Oracle forms.

    htree ITEM;
    v_ignore NUMBER;
    rg_emps RECORDGROUP;
    -- Find the tree itself.
    htree := Find_Item(’treeblock.htree1’);
    -- Check for the existence of the record group.
    rg_emps := Find_Group(’emps’);
    IF NOT Id_Null(rg_emps) THEN
    END IF;
    -- Create the record group.
    rg_emps := Create_Group_From_Query(’rg_emps’,
    ’select 1, level, ename, NULL, to_char(empno) ’ ||
    ’from emp ’ ||
    ’connect by prior empno = mgr ’ ||
    ’start with job = ’’PRESIDENT’’’);
    -- Populate the record group with data.
    v_ignore := Populate_Group(rg_emps);
    -- Transfer the data from the record group to the hierarchical
    -- tree and cause it to display.
    Ftree.Set_Tree_Property(htree, Ftree.RECORD_GROUP, rg_emps);

    Function-based index is good idea for making queries run faster without changing the application logic
    and code. Function-based indexes are highly useful in case-sensitive searches and sorts and in searches
    on columns that have computations performed on them.

    The following are some examples that shows how to create a function-based index.

    create index indxemp_name on emp (UPPER(ENAME));

    Once you create the function-based index as shown here, you can use the index expression in a
    query such as the following:

    select *
    from emp
    where UPPER(ENAME) LIKE 'K%N';

    Another example of a function-based index shows a test table and an index that is created on
    an arithmetic expression:

    create table testtbl(
    a integer,
    b integer,
    c integer);

    create index indxtesttbl on testtbl(a+b*(c-1),a,b);

    If you issue a SQL statement as shown below, the query will use an index range scan instead of
    a full table scan.

    select a from testtbl where a+b*(c-1) <200;

    Limitations of Function-Based Indexes
    Function-based indexes come with a few limitations or restrictions.

    • The data type of the index expression can't be VARCHAR2, RAW, LONGRAW, or a PL/SQL
    data type of indeterminate length.
    • The database ignores function-based indexes while doing an OR expansion.
    • The index expression must not invoke an aggregate function such as SUM.


    Custom software or tailor made software is software that is specially developed for some specific organization or other user. Since custom software is developed for a single customer it can accommodate that customer's particular preferences and expectations.

    If you need any custom software for your business, office, home or a simple data entry form to store data into table, you can contact us for the same.

    We will gather information / requirement from you and on that behalf we will develop software / data entry for your convienience.

    Each Data Entry will cost you $10 only.
    Each Data Report will cost you $8 only.
    There will be no charge for Menu system.

    For order or inquiry Click Here

    Custom Software Design

    Reviewed by Paul Rodridges on

    Mar 13


    Below is the some useful commands of Ole2 to format excel file in Oracle Forms.

    -- Change font size and name in ole2
    -- Declare as cfont ole2.obj_type;
    OLE2.SET_PROPERTY(CFONT, 'Name','Calibri');      
    OLE2.SET_PROPERTY(CFONT, 'Bold',1); 
    OLE2.SET_PROPERTY(CFONT, 'Size',11);
    -- Changing number format with ole2
    OLE2.SET_PROPERTY(cell, 'NumberFormat', '00,0,0,000.00');
    -- Changing background color in ole2
    -- Declare colour ole2.obj_type;
    colour:=ole2.get_obj_property(cell, 'Interior');
    ole2.set_property(colour, 'ColorIndex', 33);
    -- Border color
    colour:=ole2.get_obj_property(cell, 'Borders');
    ole2.set_property(colour, 'ColorIndex', 1);
    -- Wrapping text in ole2
    OLE2.ADD_ARG(args, 2);
    OLE2.ADD_ARG(args, 1);
    cell:=OLE2.GET_OBJ_PROPERTY(worksheet, 'Cells', args);
    ole2.set_property(cell, 'WrapText', 'True');
    -- Autofit columns in ole2
    range := OLE2.GET_OBJ_PROPERTY( worksheet,'UsedRange');
    range_col := OLE2.GET_OBJ_PROPERTY( range,'Columns');
    OLE2.INVOKE( range_col,'AutoFit' );
    OLE2.RELEASE_OBJ( range );
    OLE2.RELEASE_OBJ( range_col );
    -- Saving a excel file in ole2
    args := OLE2.Create_Arglist;
    filen := 'c:\myfile.xls';
    OLE2.INVOKE(workbook, 'SaveAs', args);
    See also: Create Excel File in Oracle Forms http://foxinfotech.blogspot.com/2013/02/creating-excel-file-in-oracle-d2k-forms.html

    Add combo list / drop down list item element at runtime in Oracle forms.


    (list_name VARCHAR2,
    list_index, NUMBER
    list_label VARCHAR2,
    list_value NUMBER);


      nElmntCount Number;
       -- First count the total list element currently in list item
       nElmntCount := Get_list_element_count('yourlist');
       -- Then add it by adding + 1 to total count element
       Add_list_element('yourlist', nElmntCount + 1, 'A Value', 'A Value');

    See also: http://www.foxinfotech.in/2013/04/adding-value-combolist-runtime-oforms.html

    Write Post-Query trigger for the block you want to fetch the field value for display item.


       Select Ename into :datablock.dspname
          from emp
          where ecode = :datablock.ecode;
       -- Field dspname in datablock will be populated with the value
       when others then
       -- you can ignore error 

    You can write multiple plsql blocks in post-query trigger for different tables.

    Below is the example plsql unit to validate login credentials and after successful validation open a new form by passing some parameters to it, in Oracle forms 10g.
    Create a form for custom login. Create text items for username and password etc. and a login button. When user click on that login button call this plsql routine.

        vPassword fox_user.password%type; -- get a password field type from your user master table
        plid paramlist;
    -- check if username is null
    if :appstart.usn is null then
        error_message('User name must be entered.');
        raise Form_Trigger_Failure;
    end if;
    -- check if password is null
    if :appstart.psw is null then
        error_message('Password must be entered.');
        raise Form_Trigger_Failure;
    end if;
    select password into vpassword
          from fox_user
          where rtrim(userid) = rtrim(:appstart.usn);
    -- decrypt password using your own encrypt / decrypt method.
    -- below mentioned decrypt is a program unit i used
    if :appstart.psw != decrypt(vpassword) then
         error_message('Invalid Password for the user. Logon Denied!');
         raise form_trigger_Failure;
    end if;
      -- if valid username and password then create parameter list to pass the calling form
        plid := get_parameter_list('formdata');
        if Not id_null(plid) then
        end if;
        plid := Create_Parameter_list('formdata');
        Add_parameter(plid, 'userid', text_parameter, :appstart.usn);
    new_form('main', full_rollback, no_query_only, plid);  
         when no_data_found then
            error_message('Invalid Userid. Please enter valid userid and password. Logon Denied!');
         when too_many_rows then
            error_message('Internal error...');
         when others then


    New MTS datacard configuration is slightly different from the previous ones. After installing the software / driver for new MTS datacard, you have to Activate it from the software also. If you will not click on Activate and trying to connect directly from Mblaze connect option you will get the error "Remote computer did not respond."

    So first activate it from the software also after getting activated from the MTS. The problem is that it will not activate by click once only, you have to click again and again until you get the message "Plug out and Plug in again.", after getting this message you plug out the datacard and plug in again then you will get the connect button directly on the screen. In my case I tried around 30 to 40 times to activate.

    After that you can connect to the internet.

    Like us to get notifications for free source code in future, thanks.
    Note: Activate from software only after getting approved and activated from MTS.

    You can view and download some Oracle books from my blog click this link to go to the page http://www.foxinfotech.in/p/httpsdocs.html

    The following ebooks you will find there:

    Oracle PLSQL Programming 5th Edition O'Reilly

    Oracle Database 11g SQL Oracle Press

    Oracle Fusion Developer Guide

    Oracle Jdeveloper 11g Handbook

    and more...

    See Also:

    Oracle Forms Recipes - Get it from Google Play

    Oracle Forms Recipes - Get it from Amazon

    Below is the example to write file on client in Oracle Forms 10g with webutil library package.

    Note:  Webutil library must be attached to the form.

    v_dir VARCHAR2(250) := 'c:\temp';
    ft_tempfile CLIENT_TEXT_IO.FILE_TYPE;
    ft_tempfile := CLIENT_TEXT_IO.FOPEN(v_dir ||'\tempfile.txt','w');
    CLIENT_TEXT_IO.PUT_LINE(ft_tempfile,'First line....');
    CLIENT_TEXT_IO.PUT_LINE(ft_tempfile,'Second line....');
    CLIENT_TEXT_IO.PUT_LINE(ft_tempfile,'Third line....');

    Writing Text Files in Oracle Forms 10g

    Reviewed by Nisha Vats on

    Mar 01


    Below is the example to read an image file from client in Oracle Forms 10g with the help of webutil library.

    Note: Webutil library must be attached to the form.

    v_file VARCHAR2(250):= CLIENT_GET_FILE_NAME('','',
    'Gif Files|*.gif|JPEG Files|*.jpg|',
    'Select a photo to upload',open_file,TRUE);

    it_image_id ITEM := FIND_ITEM

    Convert numbers to Indian Rupees format in Oracle Forms / Reports.

    Create the below mention function in Oracle Forms / Reports and call it with passing a number parameter.

    FUNCTION INR_words( p_number In number, vFrDec varchar2 Default 'Paisa Only')
     RETURN varchar2 As
     TYPE myArray Is Table Of varchar2(255);    
     TYPE myArray2 Is Table Of varchar2(255);
     l_str    myArray := myArray( '',
                       ' Thousand ', ' Lac ',
                       ' Crore ', ' Arab ',
                       ' Kharab ', ' quintillion ',
                       ' Sextillion ', ' Septillion ',
                       ' Octillion ', ' Nonillion ',
                       ' Decillion ', ' Undecillion ',
                       ' Duodecillion ' );
     l_str2 myArray2 := myArray2('Rs Paisa', '$ Pany');
        l_num   varchar2(50) Default Trunc( p_number );
        l_dec   varchar2(50) Default Substr(To_Char(p_number - Trunc(p_number), '.99'),2);
        l_return varchar2(4000);
        j number := 3;
        For i In 1 .. l_str.Count
            EXIT When l_num Is Null;
            IF ( Substr(l_num, Length(l_num)-(j-1), j) <> 0 ) Then
               l_return := To_Char(To_Date(
                                Substr(l_num, Length(l_num)-(j-1), j),'J' ), 'Jsp' ) || l_str(i) || l_return;
            END IF;
            l_num := Substr( l_num, 1, Length(l_num)-j );
        END LOOP;
        IF l_dec > 0 Then
            l_return := rtrim(l_return) || ' and ' || rtrim(inr_words(Substr(l_dec,2), Null)) || ' ' || rtrim(Initcap(vFrdec));
        END IF;
        RETURN Replace(l_return, '-', ' ');

    If you want to add any discussion forum to your blog or site then Google discussion forum is very good option.

    To have a discussion forum in your blog follow these steps.
    Rs. 163 .Coms at GoDaddy!
    1.   Go to https://groups.google.com/forum/ and log in with your google account.

    2.   Create a group and specify settings.

    3.  Then create a new tab page in blogger and paste the following code in HTML view and change the "your-forum-name" with your forum name and then click on publish.

    <iframe frameborder="0" height="1000" id="forum_embed" scrolling="no" src="javascript:void(0)" width="600">

    <script type="text/javascript">
     document.getElementById("forum_embed").src =
      "https://groups.google.com/forum/embed/?place=forum/your-forum-name" +
      "&showsearch=false&hideforumtitle=true&showpopout=true&parenturl=" +

    Below is the example to create an excel file in Oracle Forms.

    Pass the Sql query string to the below procedure to generate an Excel file using Ole2 package.

    PROCEDURE Create_Excel_File (CSQL Varchar2)
       source_cursor    Integer;
       l_colCnt         Number            Default 0;
       l_descTbl        Dbms_sql.desc_tab;
       newval1          Varchar2 (4000);
       application      OLE2.OBJ_TYPE;
       workbooks        OLE2.OBJ_TYPE;
       workbook         OLE2.OBJ_TYPE;
       worksheets       OLE2.OBJ_TYPE;
       worksheet        OLE2.OBJ_TYPE;
       colour           OLE2.OBJ_TYPE;

    You can test or tune your program unit performance in Oracle forms with Ora_Prof package.

    Suppose you have created to procedure to perform a single task with different logic and you want to check exactly which procedure is performing well. See the below example:

      i PLS_INTEGER;
        --test 1

    Below is the example to read and import comma delimited csv file in oracle forms with D2k_Delimited_String package. This package is available in D2kdlstr.pll library.

    To download D2kdlstr.Pll Click Here

    Create the following procedure in program unit of Oracle forms.

    Procedure Import_csv_file (I_FILENAME IN VARCHAR2) Is
       -- Text File Type
       Infile        Text_Io.File_Type;
       Linebuf       Varchar2 (4000);
       V_Getstring   Varchar2 (100);

       -- Field Values Array
       Type Fieldvalue Is Table Of Varchar2(100)
          Index By Binary_Integer;

       Fv            Fieldvalue;
       Rec_Count Number := 0;
       Infile := Text_Io.Fopen (I_FILENAME, 'R');
       -- Read File

    You have a large table and you wonder whether it should be partitioned.

    Here are some rules of thumb for determining whether to partition a table:
    • Tables that are over 2 gigabytes in size
    • Tables that have more than 10 million rows and SQL operations are getting slower
    as more data is added
    • Tables you know will grow large; it’s better to create a table as partitioned rather
    than rebuild as partitioned when performance begins to suffer as the table grows
    • Rows can be divided in a way that facilitates parallel operations like loading,
    archiving, retrieval, or backup and recovery

    Dynamic Lov is a good idea for the form where too many Lov requirement is there with different record groups. In this blog you will learn create dynamic Lov step by step.

    See also:

    Step-1 Create a Single Lov (you can give any name)
    1.   Click on form builder navigator Lovs node and then click on Add button. Select create lov manually option from the window.
    Step-2 Create Record Group (you can give any name)
    2.   Click on form builder navigator Record Groups and then click on Add button and set the properties and query as displayed in below image.

    Step-3 Create Parameters
    3. Click on Parameter node and then click on Add button and create 4 Char type Parameters as displayed below:

    Step-4 Set Lov Properties
    4.   Set the lov properties as show below:

    Step-5 Set Lov Column Mapping Properties
    5.   Set the Lov's Column Mapping Properties with the parameters as show below:

    Step-6 Create a procedure to populate lov 

    Returns information about the current Form Builder application. You must call the built-in once for each
    value you want to retrieve.
    Usage Notes
    To request a complete login, including an appended connect string, use the Username, Password, and
    Connect_String properties. For instance, assume that the user has initiated an Microsoft Windows
    Runform session specifying the following connect string:

    ifrun60 my_form scott/tiger@corpDB1
    Form Builder returns the following string as the result of a call to
    Form Builder returns the following string as the result of a call to
    Form Builder returns the following string as the result of a call to

    Upload Files To FTP in Oracle Forms D2k

    Use following procedure to upload files to Ftp. 

    PROCEDURE Ftp_Upload IS
        outfile text_io.file_type;
        -- write a ftp script
        outfile := text_io.fopen('D:\ftpsendsource.ftp', 'w');
        text_io.put_line(outfile, 'open yourftpurl');
        text_io.put_line(outfile, 'youruser');
        text_io.put_line(outfile, 'yourpassword');
        text_io.put_line(outfile,'send D:\Temp\Test1.txt');
        text_io.put_line(outfile,'send D:\Temp\Test2.abc');
        host('cmd /c ftp -s:d:\ftpsendsource.ftp');
             when others then
               if text_io.is_open(outfile) then
               end if;          

    Blog To Make Money Through Internet

    In this blog I will explore many ways to earn money through internet by blogging. Even when I started, I was not expecting that there is too many ways to earn money on internet but now I realize that anybody with some efforts can do a better for his / her life.

    About Blogging
    Blogging is a very nice thing, what my experience is when I started blogging I enjoyed it by spending time on it more than any other resource on internet. Because in this world everybody is blessed with a some good skill, knowledge or talent etc. By blogging you can explore your skill, knowledge your talent or your thoughts. You can provide free stuff on blog and you can sell on blog or you can do almost anything on blog.

    Ways to earning money through blog
    Yes the main point the Money. There is many ways to earn money with blog, following are the examples:
    • Google Adsense (Inbuilt feature in Blogger, pay per click program)
    • Luminate (It shows advertisement on your blog images, very nice feature and pays good)
    • Chitika (Pay per click program)
    • Amazon.com affiliate program (pay per order)
    • Flipcart.com affiliate program (pay per order)
    • Paypal.com (by selling your own goods or software or ebooks directly from your blog or by asking "Support My Blog" button with paypal.com, its a fantastic feature)
    For all above options for their website you can search with these names find their websites. And for paypal.com its very easy to open an account even if you are not having credit card only with a bank account you can open an account with paypal it will directly transfer money to your bank.

    Below is the example of Luminate Advertising and for others you can see my blog home page.

    Adding Fish Aquarium To Blogger

    In this blog you will learn to add Fish aquarium in blogger as you can see at bottom of this blog.

    Follow these steps:

    1   Go in Layout and add a gadget and a window will appear.

    2   Choose more gadgets option and you will find Fish gadget option and then click on add button. A window will open as showing below:

    3.   Set the parameters according to your requirement and click on Save.

    This will look something like this.

    V. Kapoor

    {picture#https://3.bp.blogspot.com/-q3wCssWUHo8/ViDFfCpPEuI/AAAAAAAAD0M/MHPvgnl3T3U/s1600/authpic.JPG} Vinish Kapoor is a Software Consultant, currently working in a reputed IT company in Noida, India and doing blogging on Oracle Forms, SQL and PLSQL topics. He is an author of an eBook Oracle Forms Recipes, which is available on Google play. {facebook#https://www.facebook.com/foxinfotech2014} {twitter#https://twitter.com/foxinfotech} {google#https://plus.google.com/u/0/+VKapoor/posts}
    Fox Infotech. Powered by Blogger.