How to Unlock HR Schema in Oracle Database XE 11gR2 by using PL/SQL Developer

Oracle provides sample HR schema in all versions of its databases which is locked by default. For working with tutorial of Introduction to Oracle you need to work on HR schema. Follow the given below steps to unlock HR schema in Oracle Database XE 11gR2 by using PL/SQL Developer.

Login in PL/SQL Developer as a user “system or sysdba” with respective password

Click on New button and open Command Window


Execute the following command

ALTER USER HR IDENTIFIED BY password ACCOUNT UNLOCK;

Here password is your choise password which you want to use for HR schema.



Login in with user HR with password specified above. Now you can use all tables of HR schema by using PL/SQL Developer.

Comments

  1. obat kuatAugust 26, 2012 at 5:25 PM

    postingan yang bagus tentang How to Unlock HR Schema in Oracle Database XE 11gR2 by using PL/SQL Developer

    ReplyDelete
    Replies
    1. AnonymousApril 18, 2022 at 9:35 PM

      How To Unlock Hr Schema In Oracle Database Xe 11Gr2 By Using Pl/Sql Developer >>>>> Download Now

      >>>>> Download Full

      How To Unlock Hr Schema In Oracle Database Xe 11Gr2 By Using Pl/Sql Developer >>>>> Download LINK

      >>>>> Download Now

      How To Unlock Hr Schema In Oracle Database Xe 11Gr2 By Using Pl/Sql Developer >>>>> Download Full

      >>>>> Download LINK Vj

      Delete
  2. hrms solutionsSeptember 17, 2012 at 2:03 AM

    Very nice! I am looking for this type of info and sometimes I get lucky like today...:-). Thanks for your post.

    ReplyDelete
  3. human resource applicationSeptember 17, 2012 at 2:09 AM

    Easy to read, interesting and easy to understand. What more do you want from a topic-specific article? Thanks for sharing!

    ReplyDelete
  4. HussainNovember 21, 2012 at 6:54 AM

    Thank you so much!!

    ReplyDelete
  5. crepagZcane-RenoApril 25, 2022 at 12:03 PM

    crepagZcane-Reno Kristi Wilson https://wakelet.com/wake/KEFebPobpgRHrFOjeXv67
    naiplastaslink

    ReplyDelete
  6. AtiomiWlibniAugust 26, 2022 at 1:06 PM

    tinccomQfer-wo Tiffany Cannon Cisco Packet Tracer
    FL Studio
    Norton Security
    reufurmager

    ReplyDelete

Post a Comment

Popular posts from this blog

What is Oracle Integration Cloud Service - ICS?

Image
Oracle Integration Cloud Service (ICS) is a solution that enables you to simplify integrations between cloud applications, and between cloud and on premises applications. It helps you create connections to well-known and less-known SaaS and PaaS applications, using the available cloud adapters, publish or subscribe to the Messaging Cloud Service, or use industry standards such as SOAP, REST, FTP, File, and JMS. For more information watch this Oracle video.
Read more

How to Create Packages in Oracle Database using TOAD for Oracle

Image
What are Packages in Oracle Database A package is a group of procedures, functions, variables and SQL statements created as a single unit. It is used to store together related objects. A package has two parts, Package Specification and Package Body. Package Specification Package Specification acts as an interface to the package. Declaration of types, variables, constants, exceptions, cursors and subprograms is done in Package specifications. Package specification does not contain any code. Package Body Package body is used to provide implementation for the subprograms, queries for the cursors declared in the package specification.
Read more

How to create a Simple Scheduler Job in Oracle Database using Toad

Image
Scheduler is a process which runs programmed jobs at scheduled times. This process wakes up at the specified time and runs automatically. The basic elements of the scheduler are: Jobs Schedules Programs A job specifies what needs to be executed and when. A program is a collection of metadata that will be executed by the scheduler. It contains the name of the program (a procedure or an executable, the type of the program (pl/sql block, shell script etc). A schedule specifies when and how many times a job is executed. 1. Login to the database using Toad, and create a Scheduler Job as follows;
Read more