Neeraj Gupta

Niraj Gupta holds BTECH degree in Computer Science and Engineering and has worked with Top MNC’s. Niraj is having rich experience of around 7 years in IT field. Niraj wish to bring out the best useful information for his users through this blog.

Feb 262017
Let's Break up the Stress: Positive Thinking: Feel the Power and Achieve the Impossible: Inspirational, Motivational & Moral Short Stories

Stress is an ever present in today’s madcap and hectic world. It can arrive in a whirlwind, or creep up on us unexpectedly. But however it arrives you can be sure that it brings a set of challenges with it. Now you can feel the power and achieve the impossible with Let’s Break up the

[Read More]
Apr 022016

Water constitutes 50 to 75 per cent of the human body. We can last weeks without food, but only days without water. Water forms the basis of blood, digestive juices, urine and perspiration, and is contained in lean muscle, fat and bones. As the body can’t store water, fresh supply is needed every day to

[Read More]
Nov 182015

Basic Tuning for SQL Query   Ordering of the FROM clause.  When we are fetching data from more than one table, write the table with fewer rows at the end of the FROM clause. Therefore, the table returning the least number of rows should be last in the FROM list. Example: SELECT COL1 FROM TAB1,

[Read More]
Aug 142015

In order to fix EPUB Check Errors there is a method that can be run in Microsoft Word to clear out formatting problems, using the replace function.  In all steps EXCEPT #4, replace all until 0 changes are made. Remove spaces before and after paragraph returns.  In the Find area, type “^p ” (a paragraph

[Read More]
Jul 152015

26. TALK: Chat to Users The “talk” command is used to chat with another logged-in user(s) or allow chat to users on other systems. Example: $ talk user3 This command will allow the current user to talk to user “user3”. 27. UNAME: Print system information The “uname” command is used to print the name, version

[Read More]
Jul 132015

UNIX Commands    1. CAT: Concatenate files to standard output The “cat” command can be used to: Display text files Copy text files into a new document Append the contents of a text file to the end of another text file, combining them Syntax: cat [options] [file_names] Example: $ cat myfile.txt This command will display the

[Read More]
Jun 172015

Tips for the monsoon Although we welcome monsoon showers because they provide a much-needed relief from the summer heat, thunderstorms that accompany monsoons come with their own hazards. Here are a few tips to help you prepare for the monsoons: SKIN During monsoons, your skin tends behaves a little strangely and is often unstable, going

[Read More]
Jun 122015

Introduction to UNIX  The UNIX operating system is a set of programs that act as a link between the computer and the user UNIX is a computer Operating System which is capable of handling activities from multiple users at the same time. hence UNIX is called a multiuser system A user can also run multiple

[Read More]
May 192015
Laughter is a Good Exercise to Fight Against Stress

Adopting a humorous view towards life`s situations can take the edge off everyday stressors. Not being too serious or in a constant alert mode helps maintain the equanimity of mind and promote clear thinking. Being able to laugh stress away is the smartest way to ward off the effects of stress. A sense of humor

[Read More]
Mar 312015
CAST Function-Converting Between Timestamps and Dates

The CAST function can be used to convert a TIMESTAMP to a DATE and vice versa. First let’s convert a TIMESTAMP to a DATE. SELECT CAST(SYSTIMESTAMP AS DATE) ts_to_date FROM   dual; TS_TO_DAT ——— 31-MAR-15 To convert a DATE to a TIMESTAMP do the following. SELECT CAST(SYSDATE AS TIMESTAMP) date_to_ts FROM   dual; DATE_TO_TS ————————————————————————— 31-MAR-15

[Read More]