Reset passwords and unlock accounts on Oracle SQL server
To unlock a user account on Oracle SQL: ALTER USER username ACCOUNT UNLOCK; To reset the password on an Oracle SQL account: ALTER USER username IDENTIFIED BY a_new_password;
Oracle SQL
FIX: Oracle SQL Developer timeout when connected to Azure
When using Oracle SQL Developer to connect to an Oracle database housed on a VM in Microsoft Azure, Developer will “timeout” after approx. 2 – 3 minutes due to Azure closing unused connections. Using this configuration, Oracle SQL Developer will hold the connection open indefinitely. Download and unzip the Oracle InstantClient: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html Put the unzipped … Read more
Fix the msvcr100.dll error when installing Oracle SQL Developer
If you get a msvcr100.dll error when attempting to run Oracle SQL Developer for the first time after installation: Go to C:\Program Files\Java\jdk1.8.0_51\bin\ Copy msvcr100.dll Paste it into sqldeveloper\sqldeveloper\bin\ SQL Developer should now start with no errors.
Create and auto-increment field using “sequence” in Oracle database
Create a database table: create table Books ( bookID number(38), title varchar2(50), author varchar2(50), pages number(38), constraint pk_bookID PRIMARY KEY(bookID) ); Create a sequence: Create sequence sequence_name start with value increment by value minvalue value maxvalue value; ***** For example **** Create sequence auto_incr start with 1 increment by 1; Insert some sample data into … Read more
Checking your current Oracle database version
To check for your current Oracle database version number: SELECT * FROM V$VERSION;
Drop a table in Oracle database
Delete database table and all data in the table: DROP TABLE table_name PURGE;