Top "Resultset" questions

JDBC ResultSet get columns with table alias

Imagine I have a query like SELECT * from table1 a, table2 b where (WHATEVER) Maybe both tables have the same …

java sql oracle jdbc resultset

Execute anonymous pl/sql block and get resultset in java

I would like to execute the anonymous PL/SQL and need to get the resultset object. I got the code …

java jdbc plsql resultset

How to find out if a Java ResultSet obtained is empty?

Class.forName("org.sqlite.JDBC"); Connection conn = DriverManager.getConnection("jdbc:sqlite:userdata.db"); Statement stat = conn.createStatement(); ResultSet rs = stat.…

java database jdbc resultset

How to check if resultset has one row or more?

How to check if resultset has one row or more with JDBC?

java sql jdbc resultset

rs.last() gives Invalid operation for forward only resultset : last

I am trying to get the row count of a result set by: rs.last(); int row_count = rs.getRow(); …

java oracle jdbc resultset

Convert Java resultset to String array

I am writing a program that will query an MS access database, return the query as a result set, and …

java swing arraylist resultset

JDBC SQL SERVER: The statement did not return a result set

I am executing the following query from Microsoft SQL Server Studio, which works fine and displays results: SELECT * INTO #temp_…

java sql-server jdbc resultset

PostgreSQL - Writing dynamic sql in stored procedure that returns a result set

How can I write a stored procedure that contains a dynamically built SQL statement that returns a result set? Here …

postgresql resultset plpgsql execute dynamic-sql

How to select an empty result set?

I'm using a stored procedure in MySQL, with a CASE statement. In the ELSE clause of the CASE ( equivalent to …

sql mysql stored-procedures null resultset

Create a comma-separated string from a single column of an array of objects

I'm using a foreach loop to echo out some values from my database, I need to strip the last comma …

php arrays csv resultset array-column