How to unlock sample HR schema in Oracle

Oracle provides a sample HR (Human Resource) schema. Bu default this schema is locked and if you want to use this schema for learning purpose it need to be unlocked first. Follow these steps.

Connect to database as system user (SYS AS SYSDBA) with the password provided during installation.
Execute the following SQL statement.

   ALTER USER HR IDENTIFIED BY <password> ACCOUNT UNLOCK;

Replace <password> with the password you want to use. You just unlocked HR schema. Connect to HR schema and start learning.
Happy learning.

Comments

Oracle Apex - Upload Files to Amazon S3 Directly From Browser

This article is about uploading files from Oracle Apex to AWS S3. The files are directly uploaded to S3 without using any intermediate storage. The metadata is written to application DB to simplify further access. Reference: https://docs.aws.amazon.com/sdk-for-javascript/v2/developer-guide/s3-example-photo-album.html AWS Tasks Complete the prerequisite tasks described in https://docs.aws.amazon.com/sdk-for-javascript/v2/developer-guide/s3-example-photo-album.html . This includes setting an S3 bucket, Amazon Cognito Identity Pool, Configuring IAM, and configuring CORS. You will require bucket name, bucket region and pool id to access S3. Credentials are stored in DB and accessed using apex.server process while the user clicks the upload button. Apex Tasks Step#1 Add AWS SDK in your application user interface details. Refer the attachment. Step#2 Create a PL/SQL dynamic region using below given code htp.p('<div> <input type="file" id="fileUploa...

How to Get Page Item Value ? Oracle APEX - JavaScript

Get Page Item Value For example, to get the value of the page item P2_FIRST_NAME, use either of the following methods.

How to set Modal Dialog Title in Oracle APEX? JavaScript

At times, the same modal dialog page is used to add as well as to edit a record. In such circumstances, a user-friendly title enhances the UX. Updating non-modal dialog page title For a non-modal dialog, this is pretty straightforward. A substitution string can be used to dynamically set the title. For example, the page title in this scenario is set to Vendor display name. This is achieved by updating the title attribute. However, this approach will not work for modal dialogs. We can use javascript to update the modal dialog title. Updating Modal Dialog Title On page load, use a dynamic action to set the dialog title. .m-dialog-content CSS class is optional. This is used to avoid updating the title of the parent dialog in scenarios where a modal page opens another modal page. Output Edit Add

Know Low-Code

Search This Blog