Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- . . .
- Connection conn;
- . . .
- PreparedStatement ps = conn.prepareStatement("SELECT * FROM foo");
- ResultSetMetadata rsmd = ps.getMetaData();
- int numberOfColumns = rsmd.getColumnCount();
- DECLARE
- lv_stat varchar2(100) := 'select blah blah blah';
- lv_cur INTEGER;
- lv_col_cnt INTEGER;
- lv_desc DBMS_SQL.desc_tab;
- BEGIN
- DBMS_SQL.parse(lv_cur,lv_stat,DBMS_SQL.NATIVE);
- DBMS_SQL.describe_columns(lv_cur,lv_col_cnt,lv_desc);
- FOR ndx in lv_desc.FIRST .. lv_desc.LAST LOOP
- DBMS_OUTPUT.PUT_LINE(lv_desc(ndx).col_name ||' '||lv_desc(ndx).col_type);
- END LOOP;
- END;
Add Comment
Please, Sign In to add comment