Database

E-commerce Site from the Scratch- Part1

This the first tutorial for creating a simple e-commerce site with all basic features from the scratch. In this tutorial, we will learn how to design the database, the structure of the files and folder, and the designing index page of a ecommerce site that will sell furniture online. Step1: Create a database named ‘ecommerce‘. […]

Read More

How to make HTML template dynamic using Reactjs, PHP and MySQL

Steps:1. Before starting this tutorial, you have to complete the previous tutorial that converts any HTML template into reactJS project. How you can make a particular portion of the reactJS project dynamic using reactJS, PHP and MySQL is shown in this tutorial. You have to install xampp server for starting the steps of this tutorial. […]

Read More

Create table by using SQL statements in Oracle 12c

Using create table statement table columns and constraints can be declared very easily. This tutorial will help you to learn different types of database table creation statements on SQL developer by using multiple examples. Example-1: Creating a table with a primary key(s) The following statement will create a table named ‘customers’ with four fields (id, […]

Read More

How to create new database user on Oracle 12c from SQL Developer

By default, we make a connection with the database by the username and password of any default user. But when we need to create any new database with separate database schema then it is necessary to use different username and password. You can create a new user from the command line by using SQL PLUS […]

Read More

REPLACE examples in Oracle

Different uses of REPLACE function in Oracle are shown here. Example-1: use of REPLACE in the string SELECT REPLACE( ‘Oracle is a relational database system’, ‘Oracle’, ‘MySQL’ ) Replaced_text FROM dual; Output: Example-2: use of REPLACE in the table create the post table with the following structure: CREATE TABLE post ( post_id NUMBER GENERATED BY […]

Read More

INSTR examples in Oracle

Different uses of INSTR function in Oracle are shown here. Example-1: use of INSTR from the beginning of the string SELECT INSTR( ‘Eat to live, not live to eat’, ‘eat’ ) TEXT FROM dual; Output: Example-2: use of INSTR with positions and occurrence SELECT INSTR( ‘Eat to live, not live to eat’, ‘live’, 5, 2) […]

Read More

SUBSTR examples in Oracle

Different uses of SUBSTR function in Oracle are shown here. Example-1: use of SUBSTR without length SELECT SUBSTR( ‘Advanced Database Management System’, 9 ) TEXT FROM dual; Output: Example-2: use of SUBSTR with positive length SELECT SUBSTR( ‘Advanced Database Management System’, 9,8 ) TEXT FROM dual; Output: Example-3: use of SUBSTR with negative length SELECT […]

Read More

Oracle data types examples

This tutorial will help you to learn the uses of major data types in Oracle. Example-1: Use of char, varchar2 and Date data types Create a table named members that consists of 5 fields, acc_id, acc_name, acc_type, acc_nid, acc_create_date. acc_id and acc_nid char and other fields are varchar. CREATE TABLE members ( acc_id CHAR(10), acc_name VARCHAR2(50), acc_type VARCHAR2(7), […]

Read More

Create tables and use SELECT query using SQL Developer

Using SQL Developer you can easily create table and insert data without writing any query. After inserting data, SELECT query is used to retrieve data from any table based on different criteria. How these types of tasks can be done using SQL developer of Oracle 12c is shown in this tutorial. Before starting this tutorial […]

Read More

How to use SQL Developer and connect with a database

When the Oracle in installed and configured properly then the user can run and use SQL Developer to create database and do other database related operations. SQL developer provides GUI to do database task more easily. If you install oracle 11g or oracle 12c then SQL developer will be installed by default. How you can […]

Read More