Sunday, May 22, 2016

Multiplication Table in Oracle...

Hi Guys ,

Today we will discuss about the Multiplication with the help of Level --- Connect by clauses.

Query:

select :n Multiplier,level Multiplicand  , :n*(level) Product from dual connect by level <=10;


 -----> In this we can able to give any number's product.

Output:

Multiplier Multiplicand Product
3 1 3
3 2 6
3 3 9
3 4 12
3 5 15
3 6 18
3 7 21
3 8 24
3 9 27
3 10 30

Read data from csv in R Programming

Read a data set from csv file.. x <- read.csv(file.choose(),header=TRUE) here x is the R data set vaiable.