Call dbms_sql.describe_columns2 to get info for a column : dbms_sql « System Packages « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Packages
  3. dbms_sql

Call dbms_sql.describe_columns2 to get info for a column

  
SQL>
SQL>      declare
  2        l_cursor number := dbms_sql.open_cursor;
  3        l_ignore number;
  4        l_desc dbms_sql.desc_tab2;
  5        l_cnt number;
  6      begin
  7        dbms_sql.parse( l_cursor,
  8                        'select to_char( sysdate, ''DD-MON-YYYY'' ) || ' ||
  9                                'to_char( sysdate, ''HH24:MI:SS'' ) ' ||
 10                         'from dual',
 11                       dbms_sql.native );
 12
 13       dbms_sql.describe_columns2( l_cursor, l_cnt, l_desc );
 14
 15       for i in 1 .. l_cnt loop
 16         dbms_output.put_line( 'Column ' || i || ' is "' || l_desc(i).col_name || '"' );
 17       end loop;
 18
 19       dbms_sql.close_cursor( l_cursor );
 20     end;
 21     /
Column 1 is "TO_CHAR(SYSDATE,'DD-MON-YYYY')||TO_CHAR(SYSDATE,'HH24:MI:SS')"

PL/SQL procedure successfully completed.

SQL> --








Related examples in the same category

1.First DBMS_SQL Example
2.Pass a query statement to a stored procedure
3.Use dbms_sql.open_cursor create a cursor
4.Use dbms_sql.bind_variable, dbms_sql.execute to insert value to a table
5.Use dbms_sql.bind_array to bind array to a cursor
6.Use dbms_sql.parse to bind a select statement to a cursor
7.Non-Query DML and DDL Statements
8.Use DBMS_SQL with the RETURNING clause.
9.DBMS_SQL.NATIVE;
10.DBMS_SQL.PARSE and DBMS_SQL.EXECUTE
11.Dynamic sql statement with variable binding
12.Dynamic select statement and row fetch
13.Execute PL/SQL block
14.DBMS_SQL package: dynamic SQL
15.Pass where clause to a stored procedure
16.Executing Queries and use DBMS_SQL.COLUMN_VALUE to map value
17.Executing PL/SQL Blocks and use BIND_VARIABLE to bind variable
18.drop the supplied table using dynamic SQL.
19.DBMS_SQL.BIND_VARIABLE_CHAR
20.illustrate the importance of setting out_value_size.
21.Calling a function which uses dynamic SQL from within an SQL statement.
22.Illustrates the interaction of roles and dynamic SQL.
23.illustrates a DDL statement which is built dynamically from the procedure parameters.
24.Use dbms_sql to process query, cursor and value
25.Use dbms_sql.bind_variable to bind variable
26.dbms_sql.varchar2_table type variable