Saturday, 28 March 2020

What is a corona?

Hi everyone.
 Everyone knows the situation.
 This is a summary of a lesson in virology.

 What is a corona?  How does one grow?  How to avoid it?
     Corona is an inanimate, inactive, protein molecule on which a layer of fat is added to a layer of powder.  Unlike others, this particle has some weight and is not exposed to air.  Falling on the earth.
      It is an inanimate cell.  When a woman's ovary has 14 days of life, the sperm is turned into a cell, and cell division begins, and this corona is an inanimate cell for 14 days.  begins.  The source of protein in our nostrils is sarcoma.  When our eye is caught in the eye or 'pussy' or 'pus' in the nose and the 'gills' in the mouth, it can break into the lungs for a few thousand and millions of minutes and then invade the blood vessels in the lungs and block the oxygen to our body.  Because of this, the patient dies of oxygen.  Its expansion would have been cleared.
    These pathogens are known to cause sneezing and sneezing, through their cheeks and sputum.  If we are close we can fall on ourselves.  Or they can be up to 4 hours to 24 hours depending on their material properties and their ability to absorb the heat of the atmosphere.  This means that the heat on the fat will dissolve and dissolve.
    So far, the countries that have contracted the disease are very cold.  One of the reasons for the lack of heat is the lack of a layer of fat on it, due to its low temperature.
     Wherever we touch them in the meantime, they are contagious to us.  Most commonly we touch our hands and our palms and fingers are contagious.  Most commonly it is natural to touch our eyes, nose, and mouth with our hands.  These cells make it easier to reach wherever they are.
     Once they reach our eye, chimneys, or nosebleeds, or the cheeks of our mouth, it is impossible to prevent them.  They are usually present in everyone, especially in the elderly.
    Although we have not yet found a drug, we can protect ourselves by taking advantage of some of its weaknesses.
      Adiyela?

     It is a fatty substance that protects against it.  If we remove this fat content, we can eliminate it.
     Usually fat content melts into heat.  Or 'soap' foam melts.  Most commonly, we use soap products to remove oily (fatty) matter in our homes or utensils.  That's all.
     This coronal cell adhesion to our body is dissolved by diluting our body and hair with about 40 degrees centigrade water, foamy soap, and bathing our head 2-3 times a day.  If the coconut oil is then rubbed on the body, then these pathogens are replenished on our body parts, causing a condition that cannot be trapped.  These can be eliminated in the next bath.
     In the meantime, if we wash our hands with hot water and soapy soap for a minute or so at a later time, we can cleanse the clothes, chairs, and masks we wear and dissolve the fat in these diseased cells.
 But in most situations, this cell cannot reach our face.  It is impossible to prevent contact with eyesores, nasal sores or blisters or mouth sores.
     These are the same things that the mouths of the scalp give us advice, the words behind them.
    Do it all and take care of this disease.
 Jaihind ........

Monday, 23 March 2020

Sex is NOT Love

Sex is NOT love. Love is not sex. You can have sex and not be in love. You can be in love and not engage in sex. A man may hate you and still have sex with you. Be wise. Using sex to manipulate a man will eventually fail. It is self-deception to think that giving him sex will make him love you. True Love will never force you to engage in sex. A man who doesn't love you will not change his mind because of sex. If he tells you to ‘prove your love’ by having sex with him. He is only using you. If he is in it for the sex, ‘better sex’ will take him away from you.
Making yourself his ‘sex slave’ is foolish. Love will never shame or degrade you. If you have made the mistake of trying to use sex to buy this man, now is the time to re-assess your relationship and build it on the right foundation. If he gets married to you because ‘the sex is good’, it will be fatal to your marriage. Let him get married to you because he loves you, honors you, feels a strong emotional, mental and spiritual connection with you and wants you to spend the rest of his life with you.

Manu.

A humble request to Online Purchaser's

Stop ordering stuff online for a few days....you sitting at the comfort of your home might get things but to get that one product. have you ever thought about how many people are involved?
The shopkeeper.... courier person... warehouse....truck drivers.......loading/unloading persons......again the warehouse and the courier service to your area.....
Ever thought these ppl are humans too and aren't it the best for them also to stay safe?
Plus if even one of them is infected....you aren't safe either....

So let's all just adjust with whatever we have for a few days......!
After all needs will always be there but we should be alive to fulfill our needs right!

Show a little compassion!
Cos just staying at home and blaming that the govt hasn't imposed complete bandh is stupid as it sounds.
Cuz our safety lies in our hands!

With the rising number of cases and the foolish ppl on the roads .....I really don't think India will be very far from where Italy is standing today!!

N to those who ask I will not earn my bread if I don't go out.....let's see you gotta be alive to eat the same bread that you earned.

For a few days please keep everyone at home!
Stay safe🙏

With Love
Manoj

Thursday, 4 May 2017

HOW TO WRITE UPDATE STATEMENT IN ORACLE SQL


USING UPDATE:
This can be used to modify the table data.
Syntax: Update <table_name> set <col1> = value1, <col2> = value2 where <condition>;
Ex: update student set marks = 500;
     (NOTE: If you are not specifying any condition this will update entire table.)
Output:
NO
NAME
MARKS
1
Visu
500
2
Vasu
500
3
Manoj
500
4
Aisu
500
5
Mohan
500
6
Manvi
500
7
Namu
500
8
Susu
500
9
Thanu
500
10
AJ
500
11
MK
500
12
MD
500

EX: update student set marks = 500 where no = 2;
Output:
 
NO
NAME
MARKS
1
Visu
100
2
Vasu
500
3
Manoj
300
4
Aisu
400
5
Mohan
500
6
Manvi
600
7
Namu
500
8
Susu
300
9
Thanu
200
10
AJ
100
11
MK
(null)
12
MD
(null)

EX: update student set marks = 500, name = 'Visu' where no = 1;
Output:

NO
NAME
MARKS
1
Visu
500
2
Vasu
500
3
Manoj
300
4
Aisu
400
5
Mohan
500
6
Manvi
600
7
Namu
500
8
Susu
300
9
Thanu
200
10
AJ
100
11
MK
(null)
12
MD
(null)

WHAT ARE THE CONDITIONAL SELECTIONS AND OPERATIONS IN ORACLE SQL


Conditional Selections and Operations:
We have two clauses used in this
Ø  Where
Ø  Order by
USING WHERE
Syntax: select * from <table_name> where <condition>;
     The following are the different types of operators used in where clause.
v  Arithmetic operators     
v  Comparison operators
v  Logical operators
v  Arithmetic operators      -- Highest precedence
+, -, *, /
v  Comparison operators
a.       =, !=, >, <, >=, <=, <>
b.       between, not between
c.       in, not in
d.       null, not null
e.       like
v  Logical operators
a.       And
b.       Or                                   -- Lowest precedence
c.       not

USING COMPARISION OPERATORS:  With WHERE Clause
a)      =, !=, >, <, >=, <=, <>
EX: SELECT *FROM STUDENT WHERE NO=5;
Output: only the number equal to 5 will give as result
NO
NAME
MARKS
5
MOHAN
500

EX: SELECT *FROM STUDENT WHERE NO>5;
Output: The numbers which are greater than 5 will give in the result.
NO
NAME
MARKS
6
Manvi
600
7
Namu
500
8
Susu
300
9
Thanu
200
10
AJ
100
11
MK
(null)
12
MD
(null)

EX: SELECT *FROM STUDENT WHERE NO<5;
Output: The numbers which are less than 5 will give in the result.
NO
NAME
MARKS
1
Visu
100
2
Vasu
200
3
Manoj
300
4
Aisu
400

EX: SELECT *FROM STUDENT WHERE NO >=5;
Output: The numbers which are greater than equal to 5 will give in the result.
NO
NAME
MARKS
5
Mohan
500
6
Manvi
600
7
Namu
500
8
Susu
300
9
Thanu
200
10
AJ
100
11
MK
(null)
12
MD
(null)

EX: SELECT *FROM STUDENT WHERE NO >=5;
Output: The numbers which are less than equal to 5 will give in the result.
NO
NAME
MARKS
1
Visu
100
2
Vasu
200
3
Manoj
300
4
Aisu
400
5
Mohan
500

EX: SELECT *FROM STUDENT WHERE NO <>5;
Output: with this statement except no 5, remaining all the rows will be displayed in the result.
NO
NAME
MARKS
1
Visu
100
2
Vasu
200
3
Manoj
300
4
Aisu
400
6
Manvi
600
7
Namu
500
8
Susu
300
9
Thanu
200
10
AJ
100
11
MK
(null)
12
MD
(null)

b)      Between, Not Between
Using Between:
SYNTAX: select * from <table_name> where <col> between <lower bound> and <upper bound>;
Ex: select * from student where marks between 200 and 400;
Output: With the above statement we are going to see the result of marks between 200 and 400.
NO
NAME
MARKS
2
VASU
200
3
MANOJ
300
4
AISU
400
8
SUSU
300
9
THANU
200

Using Not Between:
SYNTAX: select * from <table_name> where <col> not between <lower bound> and <upper bound>;
Ex: select * from student where marks not between 200 and 400;
Output: With the above statement, we are going to see result of marks between 200 and 400.
NO
NAME
MARKS
1
VISU
100
5
MOHAN
500
6
MANVI
600
7
NAMU
500
10
AJ
100

c)       in, not in:
Using IN: This will give the output based on the column and its list of values specified.
Syntax: select * from <table_name> where <col> in ( value1, value2, value3 … valuen);
Ex: select * from student where no in (1, 2, 3);
Output:
NO
NAME
MRKS
1
VISU
100
2
VASU
200
3
MANOJ
300

Using Not In: This will give the output based on the column which values are not in the list of values specified.
Syntax: select * from <table_name> where <col> not in ( value1, value2, value3 … valuen);
Ex: select * from student where no not in (1, 2, 3,7,8,9,10);
Output:
NO
NAME
MARKS
4
Aisu
400
5
Mohan
500
6
Manvi
600
11
MK
(null)
12
MD
(null)

d)      null, not null:
Using Null: This will give the output based on the null values in the specified column.
Syntax: select * from <table_name> where <col> is null;
Ex: select * from student where marks is null;
Output:
NO
NAME
MARKS
11
MK
(null)
12
MD
(null)

Using Not Null: This will give the output based on the not null values in the specified column.
Syntax: select * from <table_name> where <col> is not null;
Ex: select * from student where marks is not null;
Output:
NO
NAME
MARKS
1
Visu
100
2
Vasu
200
3
Manoj
300
4
Aisu
400
5
Mohan
500
6
Manvi
600
7
Namu
500
8
Susu
300
9
Thanu
200
10
AJ
100

e)      Like:
Using Like: This will be used to search through the rows of database column based on the pattern you specify.
Syntax: select * from <table_name> where <col> like <pattern>;
1.       Ex: select * from student where marks like 100;
Output: This will give the rows whose marks are 100.
NO
NAME
MARKS
1
VISU
100
10
AJ
100


2.       EX: select * from student where name like 'V%';
Output: This will give the rows whose name start with ‘V’.
NO
NAME
MARKS
1
VISU
100
2
VASU
200

3.       EX: select * from student where name like '%J';
Output: This will give the rows whose name ends with ‘J’.
NO
NAME
MARKS
3
MANOJ
300
10
AJ
100

4.       EX: select * from student where name like '_A%';
Output: This will give the rows whose name’s the second letter start with ‘A’.
NO
NAME
MARKS
2
VASU
200
3
MANOJ
300
6
MANVI
600
7
NAMU
500

5.       EX: select * from student where name like '__N%';
Output: This will give the rows whose name’s the third letter start with ‘N’.
NO
NAME
MARKS
3
MANOJ
300
6
MANVI
600

6.       EX: select * from student where name like '%_S%';
Output: This will give the rows whose name’s the second letter start with ‘S’ from ending.
NO
NAME
MARKS
1
VISU
100
2
VASU
200
4
AISU
400
8
SUSU
300

7.       EX: select * from student where name like '%I__%';
Output: This will give the rows whose name’s the third letter start with ‘I’ from ending.
NO
NAME
MARKS
1
VISU
100
4
AISU
400

8.       EX: select * from student where name like '%S% S %';
Output: This will give the rows whose name contains 2 S’s.
NO
NAME
MARKS
8
SUSU
300

LOGICAL OPERATORS:
a)   Using And:    
Syntax: select * from <table_name> where <condition1> and <condition2> and ..<conditionn>;
Ex: select * from student where no = 2 and marks = 200;
Output: This will give the output when all the conditions become true.
NO
NAME
MARKS
2
VASU
200

b)   Using Or: This will give the output when either of the conditions become true.
Syntax: select * from <table_name> where <condition1> and <condition2> or .. <conditionn>;
Ex: select * from student where no = 2 or marks >= 200;
Output:
NO
NAME
MARKS
2
Vasu
200
3
Manoj
300
4
Aisu
400
5
Mohan
500
6
Manvi
600
7
Namu
500
8
Susu
300
9
Thanu
200

USING ORDER BY: This will be used to ordering the column's data (ascending or descending).
Syntax: Select * from <table_name> order by <col> desc;
By default, oracle will use ascending order, If you want the output in descending order you have to use desc keyword after the column.
Ex: select * from student order by no;
Output:
NO
NAME
MARKS
1
Visu
100
2
Vasu
200
3
Manoj
300
4
Aisu
400
5
Mohan
500
6
Manvi
600
7
Namu
500
8
Susu
300
9
Thanu
200
10
AJ
100
11
MK
(null)
12
MD
(null)
EX: select * from student order by no desc;

NO
NAME
MARKS
12
MD
(null)
11
MK
(null)
10
AJ
100
9
Thanu
200
8
Susu
300
7
Namu
500
6
Manvi
600
5
Mohan
500
4
Aisu
400
3
Manoj
300
2
Vasu
200
1
Visu
100