Writing PLSQL Code



Question 1 :

Assume that we have a table with 45 million rows and 800 columns. About %30 of these columns are nominal columns (character based) whereas about %70 are numeric columns. Using 1000 maximum distinct value limit in these nominal columns;

a) it is asked to write a plsql code in order to find the column types from the metadata ,

b) it is asked to write a plsql code in order to calculate the histogram in column base and write this in a table.



City Gender **** **** ****

NewYork Male **** **** ****

Boston Female **** **** ****

Houston Male **** **** ****

Chicago Male **** **** ****

Los Angeles Male **** **** ****

Lets assume that we have a table given above. Also assume that, one of the nominal columns of the table is named as “City”. Each different city names in the column defines the distinct value. So if there are 200 different city names, this means that the distinct value is 200. Calculating the histogram means, calculating the number of each city name given in the nominal column “City”.

Question 2 :

For the numeric columns, a data sampling is going to be done with a rate of 100000. As a result of sampling, a subset will be obtained.

a) It is asked to write a plsql code in order to sort this subset data as an ascending column format and write it in a table.

Beside these questions, it is also asked to report overall resource usage (CPU and memory based) and how to use the paralelism concept.

P.S: Please find in attached the word document format of the text given above.

Skills: Engineering, Software Architecture

See more: paralelism, writing types, writing to report, writing in names, writing in code, types of report writing, the format of writing a report, project writing format example, plsql format, plsql code, plsql &, order of report writing, how to writing report, how to write report writing format, how to write report writing, how to report writing, how report writing is done, houston engineering, format report writing, format plsql, format of writing report, format of writing a report, format of writing, character writing, base code

Project ID: #4636572

4 freelancers are bidding on average $361 for this job


Please, See my private Message.

$336 USD in 10 days
(10 Reviews)

Hi Let me handle it. Thanks

$421 USD in 3 days
(3 Reviews)

Please read PM

$463 USD in 30 days
(3 Reviews)

Hi, I have a employer in my office who expertise oracle (PLSQL/ OAF/ XML publisher reports) and currently working as a senior software developer in oracle technology. we can do this within 3 days(maximum). what we u More

$222 USD in 3 days
(0 Reviews)