Executing sqlplus to connect to local database gives below error when the respective service is not running. To solve this issue, follow below steps: 1. Goto Services.msc 2. Start the below services: 3. Then try again the sqlplus command. Enter the user-name and password if prompted.
Tag: SQL
How to connect to Oracle database and run SQL queries from matlab command line and database explorer App?
In this video it shows the steps to configure the Oracle database in the matlab environment using the database explorer. The it shows how one run a query on the connected database through the database explorer or Matlab commands/ script. In this video it initially shows the result of connecting…
How to connect to the Oracle database using JDBC driver from your Android App? – Android Studio Example
In this page it shows the steps to develop the Android App code to connect to the Oracle database. It briefly shows the steps to install and setup the Oracle database on your machine initially. Then it takes through the steps of how to include the jdbc JAR file in…
How to save edited text (bold, italic, underline, alignment) in SQLite database in your Android App?
In this video it shows how to save the edit text information, such as Bold, Italics, underline or Left/ right/ center alignmnent (justification) in a SQLite database. Part 1 of this tutorial is available in the below link:https://programmerworld.co/android/how-to-create-your-own-text-editor-android-app-for-making-text-bold-italics-underline-alignment/ I hope you like this video. For any questions, suggestions or appreciation…
How to store images in SQLite database (insert, update, delete and fetch) in your Android App?
This video shows simple steps to store the image files in your local SQLite database. For storing the Images in the database, unlike simple text or numbers, it uses BLOB field. It first converts the image file (or image) into bitmap. Then it converts the bitmap into bytes by compressing…
How to create stored procedure in MS SQL database server and run (call) it from your Android App?
This video shows the complete end to end steps to create a simple stored procedure in MS SQL server and call the same from the Android App. In the first part of the video it shows how to create a simple stored procedure using MS SQL Server Management Studio (SSMS)….