Lab Sql

I need to have stored procedure where I can run multiple cursors. Loop over each cursor and then d… Read more How To Return Multiple Rows From Oracle Stored Procedure From Multiple Cursors?

I have an activity that populates a list and does some other things from a cursor. I get the cursor… Read more Activity Not Properly Managing Cursor.

Scenario: I have a stored procedure that gets data from a table based on 2 inputs: a date and a str… Read more Using A Cursor In A Stored Procedure To Loop Rows Mysql

This Python code creates a table, inserts three rows into it and iterates through the rows, with in… Read more Python, Sqlite3: Cursor Returns Duplicates When A Commit Intervenes

I have this inner XML which I am passing across to a SQL Server stored procedure. As you can see, … Read more Sql Server Xml File With Multiple Nodes Named The Same

i want to select value from my database but i got error Caused by: java.lang.IllegalStateException… Read more Caused By: Java.lang.illegalstateexception: Get Field Slot From Row 0 Col -1 Failed

This is the first and second activity file of the program i'm developing.. in the first file.. … Read more Android App Which Retrieves The Zip Code For Each City

Hi everyone I’ve been having some difficulty, hope one of you can help. I’m trying to create a litt… Read more Cursorindexoutofboundsexception When Accessing Sqlite Database

What I am trying to do is retrieve an ArrayList from another database manager class. Unfortunately … Read more How To Use A Get Method For A Sqlite Database Management Class In Another Class?

I want to compare two tables recordby record. I have two cursor for each table. The code looks like… Read more Sql: Compare Two Table Record By Record

How do I achieve the same as an Oracle cursor expression does in a MySQL database (version from 5.6… Read more Cursor Expression In Mysql

Let's suppose there is a Query called A and it takes 2sec. SELECT ... FROM ... ORDER BY 'u… Read more Postgresql Cursor With "order By" Clause

I want to create function to split the value of a column (sku) in TBL_Sku to any column (Sku1, 2, 3… Read more How To Split Value Of Column To Dynamic Column In Sql Server?

I have a ListView (in an Activity and not in a ListActivity) that utilizes a custom cursor adapter … Read more Can't Getting Data From Cursor Adapter

i'm wondering if this method is right to verify if the value of _username already exists in the… Read more Sqlite Verify If Value Of Column Exists

I'm new to SQL Server and was given a task where I have to use cursor to duplicate records for … Read more Sql Server : Insert Cursor Within Stored Procedure

CREATE PROCEDURE p_processDataFor @accountId BEGIN for each item in (select * from Acco… Read more How Can I Avoid Using Cursor For Implementing This Pseudo Code - Sql Server

IllegalStateException: couldn't read row 0, col -1 from cursorWindow. I am new to android I loo… Read more Illegalstateexception: Couldn't Read Row 0, Col -1 From Cursorwindow

I am calling a function that returns a reference cursor, and I am using XMLType.createxml to conver… Read more Reference Cursor Gets Lost In Xmltype.createxml

My requirement is to delete data from db2 table which contains duplicate phone num(invalid phone nu… Read more Db2/cursor Program Working In Cobol