Saturday, 11 August 2018

Simple PL/SQL Program

SET SERVEROUTPUT ON;

DECLARE
   c_id varchar2(100):= 'AR';
   r_id  varchar2(100);
   c_name varchar2(100);
  BEGIN
   SELECT region_id, country_name INTO r_id, c_name
   FROM countries
   WHERE country_id = c_id;
  dbms_output.put_line('Region Id is: '|| c_id || ' Country Name is: '|| c_name);

END;

/

No comments:

Post a Comment

AWS Migration Guide: Complete Cloud Migration Strategy for Businesses

Basics of AI: A Beginner’s Guide to Artificial Intelligence

Basics of AI: A Beginner’s Guide to Artificial Intelligence Artificial Intelligence, or AI, is one of the most important technologie...