Tag Archives: SQL

How to execute several .SQL files from console

Yesterday I needed to run an older version of a project just to make a few changes, for that I needed to update my old code for that project and run all the scripts (.SQL files) to update the database. A colleague gave me a line of code to get the task done faster than executing each […]

How to execute .SQL files from console

Very easy, just log in into sqlplus and type as follows if you are in the same path as your file: SQL > @file_name.sql If you are not in the same path as your file, you should type as follows: SQL > @/path/to/file_name.sql What if I need to pass a parameter? Well, not a problem, […]

How to create Oracle users in Oracle 11g XE

Here is how it’s done. Log on as SYSTEM user C:\Users\delta1>sqlplus system SQL*Plus: Release Production on Thu Feb 20 12:01:00 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter password: Connected to: Oracle Database 11g Express Edition Release – Production SQL> Execute the CREATE USER command SQL> create user user_name identified by […]