by: Amr Abdeen
Sometimes you looking for item_ you forget it or not remember whats app include it.. so you use next code to find it…. SELECT workspace, application_id, application_name, page_id, page_name, item_name, item_help_text FROM apex_application_page_items WHERE...
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...
You can by use .. select * from all_constraints where constraint_name = ‘text’
You can alter user by.. sqlplus /nolog connect / as sysdba Once connected, you can change the SYS password to something you know: ALTER USER ADMIN IDENTIFIED BY new_password