Posts

Health - Tips

Causes for Body odor Body odor causes Body odor may be due to serious illness. Body odor may be due to kidney disease, fungal infections liver disease and so on If you take some strong medicines then the smell of those medicines may be present in your body odor. Diabetic patients may smell of acetone because of insulin that they take. If you drink alcohol, smoke cigarette or cigar you will have an unpleasant body odor. Body odor may also be due to zinc deficiency, cavities, toxins and so on. It is often related with sweating of the body, but the unpleasant odor is mainly due to bacteria present in the sweat. The major non-food reason for body odor due to sweating is the sweat glands under the arms and in the groin area. Poor hygiene is the most common reason for body odor. Remedies for Body odor Remedies for Sweat Use antibacterial soap or deodorant soap to combat body odor due to sweating. Wear cotton clothes during summer so that the sweat is soaked up. Instead of using deodorant, wi
Post a Comment
Read more

Who is the BEST - Infosys, Wipro or TCS --> Funny

One day, three consultants, one from Wipro, one from Infosys and one from TCS, went out for a walk. "Why don't we prove who is the best among ourselves?" Why not, said the other two. The Infosian said "Let's have a test. Whoever makes this monkey laugh, works for the best firm". Being a pure logical strategist, the person from TCS tried to make the monkey Laugh by telling jokes. The monkey stayed still. As a more practical consultant, the Wipro guy tried to make funny gestures... No good, the monkey stayed put... Now, comes the Infosian. Being the practical guy he was always trained to be, he whispered something into the monkey's ear, and it burst out laughing at him.. The other two were astonished. So the Wipro guy said "OK, let's take another test. Let's make this monkey cry!!" So there they went again, applying the same methods as before. The TCS guy narrated sad stories, the Wipro guy made sad gestures, and they failed again... Then
1 comment
Read more

DRINK WATER ON EMPTY STOMACH

It is popular in Japan today to drink water immediately after waking up every morning. Furthermore, scientific tests have proven a its value. We publish below a description of use of water for our readers. For old and serious diseases as well as modern illnesses the water treatment had been found successful by a Japanese medical society as a 100% cure for the following diseases: Headache, body ache, heart system, arthritis, fast heart beat, epilepsy, excess fatness, bronchitis asthma, TB, meningitis, kidney and urine diseases, vomiting, gastritis, diarrhea, piles, diabetes, constipation, all eye diseases, womb, cancer and menstrual disorders, ear nose and throat diseases. METHOD OF TREATMENT 1. As you wake up in the morning before brushing teeth, drink 4 x 160ml glasses of water 2. Brush and clean the mouth but do not eat or drink anything for 45 minute 3. After 45 minutes you may eat and drink as normal. 4. After 15 minutes of breakfast, lunch and dinner do not eat or drink anything f
Post a Comment
Read more

Interview Questions, which were asked in HR Round.....

No one will GET second chance to impress.... Very very Impressive Questions and Answers..... ... Question 1: You are driving along in your car on a wild, stormy night, it's raining heavily, when suddenly you pass by a bus stop, and you see three people waiting for a bus: An old lady who looks as if she is about to die. An old friend who once saved your life. The perfect partner you have been dreaming about. Which one would you choose to offer a ride to, knowing very well that there could only be one passenger in your car? This is a moral/ethical dilemma that was once actually used as part of a job application. * You could pick up the old lady, because she is going to die, and thus you should save her first; * or you could take the old friend because he once saved your life, and this would be the perfect chance to ! pay him back. * However, you may never be able to find your perfect mate again. The candidate who was hired (out of 200 applicants) had no trouble coming up with his an
1 comment
Read more

Oracle How to turn rows to columns

Consider this query: select job_id, count(*) from employees where job_id in ('AD_PRES', 'AD_VP', 'IT_PROG') group by job_id It returns this result set: JOB_ID COUNT(*) ---------- ---------------------- AD_PRES 1 AD_VP 2 IT_PROG 5 3 rows selected Now, you want to transpose the result set and turn the JOB_ID values into columns in a single row. Here is one way of doing it: select sum(case when job_id='AD_PRES' then 1 else 0 end) as AD_PRES, sum(case when job_id='AD_VP' then 1 else 0 end) as AD_VP, sum(case when job_id='IT_PROG' then 1 else 0 end) as IT_PTOG from ( select job_id from employees where job_id in ('AD_PRES', 'AD_VP', 'IT_PROG')) The result: AD_PRES AD_VP IT_PTOG ---------------------- ---------------------- ---------------------- 1 2 5 1 rows s
Post a Comment
Read more

Query for selecting even/odd/random row selection

-random selection --SQL Server SELECT TOP 1 * FROM ORDER BY NEWID() -- Oracle SELECT column FROM ( SELECT FROM ORDER BY dbms_random. value ) WHERE rownum = 1 --row_number( )is available in sqlserver2005 only --this is for odd rows --sqlserver select * from table where row_number() %2=1 --this is for even rows --sqlserver select * from table where row_number() %2=0 --this is for odd rows -- Oracle select * from table where rownumber%2= 1 --or rowid%2=1 --this is for even rows -- Oracle select * from table where rownumber%2= 0 --or rowid%2=0
Post a Comment
Read more

Rename a table in Oracle

Oracle provides a rename table syntax as follows: alter table table_name rename to new_table_name; For example, we could rename the customer table to old_customer with this syntax: alter table customer rename to old_customer; When you rename an Oracle table you must be aware that Oracle does not update applications (HTML-DB, PL/SQL that referenced the old table name) and PL/SQL procedures may become invalid.
Post a Comment
Read more