. Execute the command Assignment 4 PL/SQL Assignment 1 Spring 2015 What does thi
ID: 644909 • Letter: #
Question
. Execute the command
Assignment 4
PL/SQL Assignment 1
Spring 2015
What does this command do? Google it on the Internet.
Type the following program and execute it. Can you tell from the result what the command
DBMS_OUTPUT.PUT_LINE does?
today_date := SYSDATE; DBMS_OUTPUT.PUT_LINE('Today''s date is '); DBMS_OUTPUT.PUT_LINE(today_date);
END;
Before you begin to work on the following questions, first download createDB.sql from
the course website and execute it.
Read the following program and figure out what it does. Then type it and execute it to verify if you are right.
DBMS_OUTPUT.PUT_LINE('there are total ' || na || ' A''s'); else
DBMS_OUTPUT.PUT_LINE('No student makes an A'); end if;
END;
4. Revise the above program, so that it will output the statistics for the grades A, B, C, D, and F.
Explanation / Answer
Spring is a framework in java just like struts.
The first DB program displays the todays date as stored in the variable today_date
The second db program will display the total count of A grade.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.