How to concat two or more columns with separator in Android sqlite?
Answers
Search your favorite tutorials...
How to concat two or more columns with separator in Android sqlite?
AndroidMobile DevelopmentApps/Applications
Follow Answer 18
1 Answer
Vrundesha Joshi
Vrundesha Joshi
Answered on 26th Mar, 2019
Before getting into example, we should know what sqlite data base in android is. SQLite is an open source SQL database that stores data to a text file on a device. Android comes in with built in SQLite database implementation. SQLite supports all the relational database features. In order to access this database, you don't need to establish any kind of connections for it like JDBC, ODBC etc.
This example demonstrate about How to concat two or more columns with separator in Android sqlite.
Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new
project.
Step 2 − Add the following code to res/layout/activity_main.xml.
<?xml version = "1.0" encoding = "utf-8"?>
<LinearLayout xmlns:android = "http://schemas.android.com/apk/res/android"
xmlns:tools = "http://schemas.android.com/tools"
android:layout_width = "match_parent"
android:layout_height = "match_parent"
tools:context = ".MainActivity"
please make me brainlist