DBMS

in Oracle Application Express We write codes What are the codes?

Q1: Write an anonymous block that uses a country name as input and prints the highest and lowest elevations for that country. Use the wf_countries table. Execute your block using United States of America as a county name.

Q2: Write an anonymous PL/SQL block that assigns the programmers full name to a variable, and then displays the number of characters in the name.

Q3: Write a PL/SQL block to display the country_id and country_name values from the WF_COUNTRIES table for country_id whose values range from 55 through 70. Use a WHILE loop. Increment a variable from 55 through 70. Test your variable to see when it reaches 70.

Q4: Write and test a PL/SQL block to read and display all the rows in the wf_countries table for all countries in region 5 (South America region). For each selected country, display the country_name and national_holiday_name. Display only those countries having a national holiday date that is not null.

Q5: Write and execute a PL/SQL block to read each row from the proposed_raises table. For each row, UPDATE the date_approved column with todays date. Use the WHERE CURRENT OF... syntax to UPDATE each row.