Skip to content

Instantly share code, notes, and snippets.

@AmrAbdeen
Last active August 29, 2015 14:06
Show Gist options
  • Save AmrAbdeen/4295d5d23ba8a8e3c736 to your computer and use it in GitHub Desktop.
Save AmrAbdeen/4295d5d23ba8a8e3c736 to your computer and use it in GitHub Desktop.
ORACLE PL/SQL
-- Select constraint
select * from all_constraints
where constraint_name = 'T_CUST_PASS_CK'
-- To change lisetner port ..
SQLPLUS /NOLOG
At the SQL Command Line prompt, enter the following command:
CONNECT SYSTEM/password
--where password is the SYSTEM password that you set upon installation (Windows) or configuration (Linux) of Oracle Database XE.
At the SQL Command Line prompt, enter the following command:
EXEC DBMS_XDB.SETHTTPPORT(nnnn);
--where nnnn represents the new port number to use for HTTP connection requests. Be certain that you select a port number that is not already in use.
--For example, to use port number 8087 for HTTP connection requests, enter this command:
EXEC DBMS_XDB.SETHTTPPORT(8087);
--If the command is successful, the following message is displayed:
--PL/SQL procedure successfully completed.
sqlplus /nolog
connect / as sysdba
Once connected, you can change the SYS password to something you know:
ALTER USER sys IDENTIFIED BY new_password;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment