Maurice Tutor

(5)

$15/per page/Negotiable

About Maurice Tutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Biology,Calculus,Chemistry,Economics,English,Essay writing,Geography,Geology,Health & Medical,Physics,Science Hide all
Teaching Since: May 2017
Last Sign in: 398 Weeks Ago, 2 Days Ago
Questions Answered: 66690
Tutorials Posted: 66688

Education

  • MCS,PHD
    Argosy University/ Phoniex University/
    Nov-2005 - Oct-2011

Experience

  • Professor
    Phoniex University
    Oct-2001 - Nov-2016

Category > Computer Science Posted 16 Jul 2017 My Price 4.00

PL/SQL code

Lab Assignment

Write a PL/SQL code to insert data into the temp table. If the entered number is greater then 25 ignore it. If the entered number is less than 25 then insert one row for each number starting from one. Insert (1) in (Num_store), (2) in (Num_store) & so on for all the numbers except 5, 10, 15 & 20. As soon as the number becomes five enter (5 , FIVE) in (Num_store, Char_store). If it becomes 10 enter (10, Ten) in (Num_store, Char_store). If it becomes 15 enter (15, FIFTEEN, SYSDATE) in (Num_store, Char_store, Date_store) & when it becomes 20 enter (20, TWENTY) in (Num_store, Char_store).

Table : Temp

 

Field name

Width

  

Num_store

number(2)

  

Char_store

Varchar2(15)

  

Date_store

date

Answers

Maurice Tutor
(5)
Status NEW Posted 16 Jul 2017 10:07 PM My Price 4.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â----------- Th-----------ank----------- Yo-----------u f-----------or -----------usi-----------ng -----------our----------- we-----------bsi-----------te -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill-----------

Not Rated(0)
Relevent Questions