Print all column values via only Record using PLSQL

Question

I have following plsql script that prints record parameters. Is there a way to print all column values just passing country_record. I mean I do not want to write all column name like country_record.country_id

 DECLARE
       country_record   countries%ROWTYPE;
       countryid        countries.country_id%TYPE;
    BEGIN
       countryid := &countryid;

       SELECT *
         INTO country_record
         FROM countries
        WHERE country_id = countryid;

       DBMS_OUTPUT.put_line ('id: ' || country_record.country_id);
    END;

You will find your answer here: stackoverflow.com/questions/8717251/… — rtbf
– rtbf, Commented Jul 1, 2014 at 6:55

Maheswaran Ravisankar · Accepted Answer · 2014-07-01 07:15:02Z

1

If printing it all you wanted, you can try out this. Using SQL*Plus

VARIABLE MYCUR SYSREFCURSOR;

 DECLARE
       country_record   countries%ROWTYPE;
       countryid        countries.country_id%TYPE;
       plsql_cursor SYS_REFCURSOR;
    BEGIN
       countryid := &countryid;

       OPEN :MYCUR for 
       SELECT *
         FROM countries
        WHERE country_id = countryid;

    END;
  /

  print mycur;

edited Jul 1, 2014 at 7:15

answered Jul 1, 2014 at 7:07

Maheswaran Ravisankar

17.9k6 gold badges50 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ahmet Karakaya Over a year ago

I am using TOAD,Is there a similar solution for it?

Maheswaran Ravisankar Over a year ago

Same concept, an answer here

Collectives™ on Stack Overflow

Print all column values via only Record using PLSQL

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related