SQL Programming - Science topic

Orchid related data in SQLite DB format attached in Asset folder with Android Application and application work only upto Android 8 (API level 26) but the inbuilt Database is not visible in Android 9 (API level 28) . What's the reason behind this?

Application built in Eclipse Juno Framework

I'm trying to delete a table and create them again in PostgreSQL, but, in more than 24 hours, the command DROP TABLE or TRUNCATE don't finished.

This table have a lot of tuples (millions), but, this command don't have to be fast?

What can I do to delete this table completely?

I have a column number 1,2,3,4,.............................................600. I am using here

SELECT 1,2,3,4,5 FROM tbl;

here i get only the column no with data consisting of 1, 2, 3, 4,5 ....

My question is how I get from 1 to 16.

After i need the data from 18 to 59

and continue

i want to group...

please tell me what syntax will i use?

I need to retrieve fields from a relational database that has more than twenty tables. I am having difficulty in extracting required 63 fields from the database. Someone advice please.

I use the following query for retrieving data from SQLite database in android.But I do'nt know how to retrieve data randomly?

Cursor c=db.query("questiondata",null,null,null,null,null,null);

I'm try to create and application with CodeIngiter, I use a MySQL DB for it, but I need have access to others Databases make it with SQL Server, recompile information from them and integrate to my MySQL DB on my application.

I have set of multiple-choice questions that want to ask them from users for getting his/her performance in answering the questions.

I want to do research on the above mentioned topic. I need ur suggestions

Inmon, Kimball, Hefesto or another? I'm currently building a data warehouse to pave the way for data mining, the goal of this work is to improve the process of decision-making in education policy. This requires knowing what the best architecture is.

I want to find a special string in a given set of strings. For example I have an address, street A 59 (or just A 59, street has not been entered in the database), in contrast, there exists a park with the name of A or other places. I want to search the keyword A and find all the streets with the name A, not other places, e.g. park. and there are thousands of rows in the database.

I use this command for my situation: UPDATE my-column SET my-column = 2

WHERE my-column LIKE '%A%'

But I don't know how to search for string A plus a number in front of it (I mean search A 12, A 13,... simultaneously (A+Number). Could you please help me?

Thank you so much in advance.

I want to read all transactions such as insert, update, delete for a specific table and database in SQL Server 2005 or SQL Server 2008

DECLARE @RowCount INT

SET @RowCount = (SELECT COUNT(ID) FROM Table1)

DECLARE @I INT

SET @I = 1

WHILE (@I <= @RowCount)

BEGIN

DECLARE @word VARCHAR(50), @len int

SELECT @word = word, @len = LEN(@word) FROM Table1 WHERE ID = @I

WHILE @len>0

BEGIN

INSERT INTO Table2 (base, part) VALUES (@word, SUBSTRING(@word,1,@len))

SET @len=@len-1

END

SET @I = @I + 1

END

Transactions control the queries that perform complete or rollback.

I need a function that doesn't have limitation of 32 kb buffer size like "encode to base64"

an example in attachment.