2. Code a PL/SQL statement that prints the value of a variable named current_scr
ID: 3706391 • Letter: 2
Question
2. Code a PL/SQL statement that prints the value of a variable named current_script to the console?
Answer is:
3. Oracle doesn’t automatically ___________________ INSERT, UPDATE, or DELETE statements?
Answer is:
4. When you raise an application error in a stored procedure, you specify an error number and an error _______________?
Answer is:
5. To make a parameter for a stored procedure optional, you assign it a/an ______________________________.
Answer is:
6. When you use a BEFORE trigger to work with an UPDATE statement, you can use the ______________________________ identifier and a column name to refer to a value in the row before it is updated.
Answer is:
A time zone can be stored as a region name, region abbreviation, or as an ______________________________ from Greenwich Mean Time.
Answer is:
Explanation / Answer
SQL>
Declare
2 current_script varchar2(40);
3 begin
4 current_script := 'Helloo';
5 dbms_output.put_line (current_script);
6 end;
7 /
3.Oracle doesn’t automatically COMMITS INSERT, UPDATE, or DELETE statements.
4.When you raise an application error in a stored procedure, you specify an error number and an error message
5.To make a parameter for a stored procedure optional, you assign it a/an DEFAULT VALUE
6.When you use a BEFORE trigger to work with an UPDATE statement, you can use the ROW Identifier and a column name to refer to a value in the row before it is updated.
A time zone can be stored as a region name, region abbreviation, or as an The time zone offset from Greenwich Mean Time.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.