How to Attach And Send An Executable (.exe file) in Gmail – Trick

Gmail would not allow to attach .exe format file.If you try to attach an executable file(.exe) then Gmail would prompt a message saying “file is an executable file. For security reasons, Gmail does not allow you to send this type of file”.

gmail exe file

But still if you need to send a executable file in Gmail there are some workarounds

Rename the file

Rename the file without .exe extension.For eg if the file is “test.exe” change it to “test.txt” and attach in gmail for sending.
Communicate in the receiver side that they have to change it to .exe extension.

Compress the file

Compress the file using any tool and the attach it in gmail.For Eg if you compress using the winrar tool it will be compressed and extension would be “test.rar” which Gmail would allow to be attached and sent.

These workarounds would violate Google policies.Thus if you wish to go with Google,upload the file in some file sharing website and give the link in the mail.

How to Open .docx/.xlsx/.pptx Extension File Without Microsoft Office Installed

The later versions of Microsoft Office has the word document extension as .docx instead of the older extension .doc.Suppose if you want to open a word document with .docx extension but you don’t have the latest/compatible version to open them,there are different ways to view them.

View using older Microsoft office – Microsoft Office Compatibility Pack

Microsoft has a compatible pack to view newer version documents in older version office.The Microsoft Office Compatibility Pack can be downloaded from here

View using Google Docs

The document can be uploaded to Google docs and viewed.Thus no softwares have to be installed.

View using Open Office

Open Office is a open-source office suite.By installing Open Office the documents can be viewed
through it.

View using on-line tools or converters

There are several on-line tools and converters available which can be downloaded and used to convert the documents.
On line Tools : zamzar ,ThinkFree
Converter Softwares : docx-converter , docx2doc

Can We Format(Bold/Italic) Text in the GTalk Chat Window – Trick

Yes it is true that we can format the text when we type in Gtalk chat window.Even though we dont have buttons to make a text bold or Italic,there is a easy way to do that.
To make the text bold format we have to add asterisks(*) in front and end of the word(s).
Eg         : *I am in bold*
Result : I am in bold

To make the text italic format we have to add underscore(_) in front and end of the word(s).
Eg         : _I am in italic_
Result : I am in italic

Combination of both bold and italic
Eg         :  *_I am in bold and italic_*
Result :  I am in bold and italic

How To Remove/Delete/Move Mail Message from Inbox Label – Gmail

We usually want to organize our mail box and keep our Inbox clean.We label the mail messages and use filter option in gmail and organize them but still we would see the mails sitting in our Inbox that does not have filter.

Here are the ways to remove the Inbox label from a mail message or mulitple mail messages.

Remove Inbox Label from a Mail Message :

  • Open the mail message.
  • Click on the  ‘X’ next to the Inbox label near the message subject line or Click Archive button on the top.
  • This action will remove the mail from Inbox and moves that mail to “All Mail” Label.
  • “All Mail” label would be located in the left side of the gmail page.If you don’t see “All Mail” click the More drop-down menu at the bottom of the labels list.

Remove Inbox Label from a Multiple Mail Messages :

  • Select the mails to be moved from Inbox.
  • Click on Archive button on the top.
  • This action will move the mails to “All Mail” Label and removes them from Inbox.

Keep your mails organized and Inbox clean :)

Flash Player is not working in Google Chrome Browser – How to install

If there is a problem in viewing videos/flash content  in youtube or facebook etc; through chrome browser,Here is a easy way to resolve it.

Step 1 : Download Adobe Flash Player installer for Google Chrome from Adobe officially website. Click here to download.

Step 2 : You will get a prompt message at the left bottom corner of the screen as  save the file or discard.Click Save button.

Step 3 : Open the path of downloaded  folder and run the install_flash_player.exe.

Step 4 : Restart Chrome.

By installing flash player the problem will be resolved.Enjoy flash content in Google chrome.

How To Print The E-Mail from Gmail – Tip

To print the mail we don’t need to copy the content to doc/notepad and print them. Gmail makes it easy to print the email message with an option.

To print the whole email message,open the email and click on the “Reply” button in the top right corner of the email.This opens a drop down with links, click on Print in it.

A new window/tab will open in the browser with the Gmail logo and the email message content. The print dialog box will also open immediately from which we can print the email.

Steps to Convert the CLOB to VARCHAR2 Data Type

Steps to convert the CLOB(Character Large OBject) to Varchar2 data type.

Step 1: Create a new temporary column with varchar2
Step 2: Move the CLOB column content to new temporary column, if it is needed. (Note : By this situation you may loose the data depending upon Max length)
Step 3: Drop the CLOB column.
Step 4: Rename the temporary column with dropped CLOB column.

Example:

Step 1: ALTER TABLE your_table (temp_column VARCHAR(4000));
Step 2: UPDATE your_table SET temp_column = DBMS_LOB.SUBSTR(clob_column, 4000, 1);
Step 3: ALTER TABLE your_table DROP COLUMN clob_column;
Step 4: ALTER TABLE your_table COLUMN temp_column TO clob_column;

How to Convert the Data Type VARCHAR2 to CLOB in Oracle

We cannot directly convert the data type VARCHAR2 to CLOB(Character Large OBject). Using below two options, we can able to covert it.

Option 1:

Step 1 : Convert the VARCHAR2 To LONG Data Type
Step 2 : Convert the LONG to CLOB Data Type.

Example:

Step 1: ALTER TABLE YOUR_TABLE_NAME MODIFY(Your_Column_Name LONG);
Step 2: ALTER TABLE YOUR_TABLE_NAME MODIFY(Your_Column_Name CLOB;

Option 2:

Step 1: Add a new column as CLOB
Step 2: UPDATE VARCHAR2 date to CLOB column
Step 3: DROP VARCHAR column
Step 4: Rename CLOB column to VARCHAR column name

How to Lock the system/PC just using the mouse – Trick

We usually use Alt+Ctrl+Del or Windows+L to lock our system by the keyboard.Lets see how we can lock the system by the mouse.

Step 1 : Right click on the desktop, point to New->Shortcut.

shortcut
Step 2 : In the Shortcut dialog box, copy and paste ‘rundll32 user32.dll,LockWorkStation‘ without single quote in the ‘Type the location of the item’ text box and Click Next.

ShortcutDialog
Step 3 : In “Type a name for this shortcut” text-box type some name you wish like “Lock the System” and Click Finish.


Step 4 : Just double click on the icon, the desktop will be locked :)

Remove white spaces in a string c#

By using trim() we can remove white space characters from the beginning and end of a string.But to remove white space characters in middle we cannot use trim() method.

we can easily remove the white spaces/empty space in a string by replace method

string strSample = “Test with white space”;
strSample = strSample.Replace(” “, “”);

Result : strSample = “Testwithwhitespace”