Tags » SQL

Installation of Oracle SQL Developer to Ubuntu

First of all, you need to install Java in your environment. I will continue with the latest OpenJDK version currently available. Easiest method to install jdk is to write following commands to the terminal: 731 more words

Oracle

Add a Data Connection to the App Service (SQL Database)

Login to the Azure portal: https://portal.azure.com
Navigate to More Services from the left tile.

In the search input section, type App Services and choose the same. 154 more words

Create Azure SQL Database

Login to the Azure portal: https://portal.azure.com
Navigate to More Services from the left tile.

In the search input section, type SQL Database and choose the same. 198 more words

[Prog] SQL Useful Queries

Hello readers,

I’ll share with you useful queries that I use continuously on SQL Developer about tablespaces and partitions:

Tablespaces’s List

select * from user_tablespaces; 164 more words
Programming

SQL Introduction

Here is an introduction to writing SQL statements rather than using the user interfaces to build objects for you, insert, update, delete and query data within them. 1,216 more words

SQL Server

Updates for SQL + PHP in this course

This course is divided into three parts: databases with PHP, web scraping with Python, and using a web framework, Flask (also Python). I started teaching this course in January 2016. 1,258 more words

SQL

What is the difference between MySQL, MySQLi and PDO?

Those are different APIs to access a MySQL backend

  • The mysql is the historical API
  • The mysqli is a new version of the historical API. It should perform better and have a better set of function.
  • 87 more words
SQL