Show message "Loading data please wait" in WinForm using C#

You need to write the following code:

      frmLoadinData _frmLoad = new frmLoadinData();
      _frmLoad.Show();
      Application.DoEvents();
/*Start your operation code from here*/
 Write your code here, like get data from data base or any other operation
/*End your Operation here*/
      _frmLoad.Close();


N.B.: frmLoadinData is a form where a label with text "Loading data please wait"

Percentage Calculation using Oracle 10g

Write the following simple query:

Select Column1,Column2,Column3,TRUNC(((ratio_to_report(count(*)) over(partition by PartitionColumn1,PartitionColumn2))*100),4) as Percent
                from Table_Name
                where <condition>
                group by Column1,Column2,Column3

N.B.:

• Column1, Column2,Column3 are just column name of your table.
• PartitionColumn1,PartitionColumn2 are column name of your table, by using these column name you calculate the percentage or partition table. It's may be one or more column.
• 100 means calculate percentage in 100.

Removing duplicate rows from a table in oracle

Just write following simple query:

Delete  FROM table_name
WHERE ROWID not in
(SELECT MIN(ROWID)
FROM table_name
group by column1,column2,column3...)

Enjoy...........