Skip to main content

Posts

Showing posts from February, 2017

6 Points to Learn Programming for Beginner's

Learning programming isn't that hard neither that easy,But will be simplified once you are in a right direction and know how to.There are lot of things that you can do to making the learning easier.    Don't Move too Fast     Learning is not a race, so keep calm and get it right before moving on, rather then quickly jumping for next. Thinking you know it all but you rarely did will be hindrance as you miss out the things and not have good good grasp of the fundamentals. Take it as a continuous process and  don't stop try maintaining the pace till you have mastered the topic 2. Understand the Example Code  Reading codes doesn't help you to write a program.What matters is understanding the code, so try to understand the code and always keep in mind start from the simple code don't flow on the words and go for complex code. Once you understand simple codes you will eventually grow yourself to understand the complexity. 3. Execute The Code     Don't just

Pivot in Oracle for Dynamic Columns

Pivot in SQL refers to the change of rows into columns based on specific constraints. An example of pivot could be the transpose of matrix. Example: a matrix containing day as 1st row and sales as 2nd row for  specific day sun    10 mon  20 tue    30 The transpose of the above matrix would be sun mon tue 10  20  30 This is an example scenario of pivot in sql. Now, Lets get on to the actual tables in database and see how we can use pivot . Starting with a fictional scenario, assume a table which contains two columns DAYS and SALES. CREATE TABLE TEST.DAILY_SALES (   DAYS   VARCHAR2(10),   SALES  NUMBER ) insert into DAILY_SALES('SUN',10); insert into DAILY_SALES('MON',20); insert into DAILY_SALES('TUE',15); insert into DAILY_SALES('WED',25); insert into DAILY_SALES('THU',10); insert into DAILY_SALES('FRI',30); insert into DAILY_SALES('SAT',5); Now when we execute the following select statement se

Login Sequence Diagram

 Diagramatic representation of the  interaction between processes in their own order is a Sequence Diagram. A simple Sequence diagram for login is shown below: Short descriptions on notations used in the above diagram. Actor:   An actor is an entity that interacts with the system (can be human or any other process or entity that interacts with the system  ). Call Message :  Represents the forward communication between the entities . Return Message : Represents the message passed back to the caller.