Shell Programming and Scripting

$ 
$ ## show the SQL script
$ cat -n test.sql
     1  --       
     2  with t as (
     3    select table_name, column_name, data_type, data_length
     4    from user_tab_columns                                 
     5    where table_name = 'DEPT')                            
     6  --                                                      
     7  select distinct
     8         'struct '||lower(table_name)||' {'
     9  from t
    10  union all
    11  select decode(data_type,'NUMBER','  int ','VARCHAR2','  char ')||
    12         lower(column_name)||
    13         decode(data_type,'VARCHAR2','['||to_char(data_length+1)||']')||';'
    14  from t
    15  union all
    16  select '};'
    17  from dual
    18  /
    19
$
$ ## show the shell script
$ cat -n getcstruct.sh
     1  #!/bin/bash
     2  sqlplus -s /nolog <<EOF
     3  connect scott/tiger
     4  set heading off feed off
     5  @test.sql
     6  EOF
     7
$
$ ## execute the shell script
$ . getcstruct.sh

struct dept {
  int deptno;
  char dname[15];
  char loc[14];
};
$
$