A0

Labels

Showing posts with label oracle sql. Show all posts
Showing posts with label oracle sql. Show all posts

How to develop logic?

 Logic DevelopmentHave you heard programmer is nothing without logic? If yes then you should definitely read this article to which can help you in development of logics.Before some practices we should understand what is logic? can you answer this question? you should answer if you don't know then don't worry I will answer you. "The ability to solve any problem". If you know better answer then you can comment below this will also increase my...

Operators and Precedence in Oracle SQL

 OperatorsWe can also use the operators while writing the queries eg +, -, *, / and ^. By using these operators we can display output in more accurate way for example if the salary for the employee is 500 per month and we want to display this salary for an year then by using the operators we can easily display the output. We can solve this query by multiplying the monthly salary with 12 months. After calculating output will be 500*12 =6000. Do...

Select Statement and Distinct Keyword

 Select Statement:So this is the first blog related to oracle SQL. Today lecture will about the select statement which is one of the important topic in Oracle SQL. It is used to retrieve(show) the data. For example there is employee table in the database and by using select statement we can show the whole data which is present in the table. So here is the query related to select statement.e.gselect * from emp;Here * is use as whole. If I will...