I'm trying to gather the schema information of a view which combines multiple tables. I'm trying to get the dtype info till the size, precision and scale of the varchar and numeric columns.
I came across a system defined procedure SP_HELP which gives this info. But when executed through DBeaver it gives the result in multiple tabs and the info I need is on the second tab.
when I run the SP using prepareStatement. I'm able to get the info in the first tab which is the view name , owner and which db it belongs to. The info I need with column names and type info is present in the second tab.
How do I move my result set to point to the second tab info and consume data from there in java JDBC?