Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Find diagonal values of a 3*3 table

rajeshksethiJun 19 2021

Hi All,
Pleas help me to find the values from a 3 * 3 table (A table having 3 columns and 3 rows).

-- Sample Table
create table tab(col1 number, col2 number, col3 number);
-- Sample Data
insert into tab values(1,2,3);
insert into tab values(4,5,6);
insert into tab values(7,8,9);
commit;
select * from tab;
-- Output
1,5,9

Thanks,
Rajesh

This post has been answered by mathguy on Jun 19 2021
Jump to Answer
Comments
Post Details
Added on Jun 19 2021
5 comments
774 views