Select Code to Download

#open connection to the database
my $db = DBI->connect("dbi:Oracle:host=$host;sid=$sid;port=$port", $ui
+d, $pwd) or die "Error while connecting to database!!!\nIncorrect Con
+nection information\n";
...
 
 print "$pdisplay_order, $parent_name, $child_name\n";
 }

However, when I use the following, I can fetch the values from the tab
+le / view
 #$SQL_query = qq {SELECT display_order, name, id_parent_category from
+ CATEGORY ORDER BY DISPLAY_ORDER };
...
    #$SQL_query = qq {SELECT * from VW_CATEGORIES};