Home » Posts tagged 'ALTER'
Tag Archives: ALTER
Oracle APEX the server requires a username and password the server says XDB
Oracle APEX the server requires a username and password the server says XDB
This article from Mohammad Fawzy
The article direct link Oracle APEX the server requires a username and password the server says XDB
Summary
After install APEX on enterprise edition database you will get the following message if you try to connect to APEX “the server requires a username and password the server says XDB”
In a new installation, we must configure the embedded PL/SQL gateway by running the configuration script apex_epg_config.sql. Then, we must unlock the ANONYMOUS account.
Oracle SQL Tutorial
Summary
Introduction to Databases.
CODD’S Rules.
Datatypes and Creating Tables.
Oracle SQL SELECT Statement.
UNION, INTERSECT, MINUS Operators and Sorting Query Result.
Oracle SQL Functions (Character Functions, Math Functions, Aggregate Functions).
Oracle Join Queries, (Inner Join, Outer Join, Self Join).
GROUP BY Queries, SUB Queries, CUBE, ROLLUP Functions, WITH, CASE Operators.
Oracle Data Manipulation Language (INSERT, UPDATE, DELETE, INSERT ALL, MERGE).
Oracle Data Definiation Language (CREATE, ALTER, DROP, TRUNCATE, RENAME).
Oracle Transaction Control Language (COMMIT, ROLLBACK,SAVEPOINT).
Data Control Language (GRANT, REVOKE).
Oracle Integrity Constraints (PRIMARY KEY, NOT NULL, CHECK, FOREIGN KEY, UNIQUE).
Oracle Date Operators, Functions.
Managing Oracle Views.
Managing Oracle Sequences and Synonyms.
Managing Indexes and Clusters.
Oracle Table Partitioning and Creating Partitioned Tables.
Oracle Objects and Object Types.
OraPedia 