The Oracle HR example uses 10g, 11g, and oracle11g.
Oracle HR example users can create 10g, 11g
First, add the 10. SQL files in the attachment (see the end of the article) to this path:
$ ORACLE_HOME/demo/schema/human_resources
Script Name
Description
Hr_anz. SQL
Collects statistics on the tables in the schema.
Hr_code. SQL
Creates procedural objects in the schema.
The life cycle platform of a program apeSlogan: Professional communication, career planning, face the reality, intentions to communicate, sentiment. Public Number: IterlifetimeTwo-dimensional code: hundred Wood-iter Professional Exchange Struggle Group: 141588103 for a small company, the position of "Executive vice president" is very deceptive and looks beautiful, and in essence does not necessarily do the work in accordance with it. Moreover, for the boss, the non-reliable personnel can
Oracle unlocking and locking (for HR Users)
SQL * Plus: Release 9.2.0.4.0-production on TUE Jul 14 18:12:38 2009
Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.
SQL> conn sys/sys as sysdba
Connected.
SQL> show user
User is "sys"
SQL> DESC dba_users
Name null? Type
-----------------------------------------------------------------------------
Username not null varchar2 (30)
User_id not null number
Password varchar2 (30)
Account_sta
: CSS2 Japanese HirakanaHiragana-iroha: CSS2 Japanese HirakanaKatakana: CSS2 Japanese katakanaKatakana-iroha: CSS2 Japanese katakana No.Lower-latin: CSS2 lowercase latin lettersUpper-latin: CSS2 capital latin letters* List-style-image: url (images/disc.gif); use disc.gif to display the list items.* List-style-position: outside | insideOutside: The list item tag is placed outside the text and the surrounding
can come in, we decorations! We water splashed the streets of loess cushion Ah! What technology you want! Don't mess it up!Tell the truth ... I have lived so long ... Do the back-end of the good-looking sister interviewed also about 10 of a dozen ... It's a rare thing to recruit in.After the job, the whole department was in full swing with chicken blood ... Increased productivity by at least 30% ... TriedIncidentally, the front of the good looking sister because the number of more ... And the f
OA to try to set a single sign-on, take the existing HR system attempt, the results do not know the HR system encryption and verify the address, and then find HR Vendors-Xiamen Summer Valley software implementation personnel. It turned out that the technician was reluctant to give me a very annoying.It is strange, not open source software how so like to firmly gr
Switch to Oracle's HR users to practice under
1. Check the name and salary of the employee whose salary is more than 12000
Select Initcap (concat (last_name,first_name)) "name" salary from employees where salary>12000;
2. Check the employee's name and department number for employee number 176
Select Initcap (concat (last_name,first_name)) "name" department_id from employees where employee_id = 176;
3. Select the name and salary of the employee wh
First to create a AA user:
sys@orcl> create user AA identified by AA;
User created.
To view user rights with an HR user login:
Sys@orcl> Conn Hr/hr
Connected.
Hr@orcl> select * from Session_privs;
Privilege
----------------------------------------
CREATE session
ALTER session
Unlimited tablespace
CREATE TAB
Tags: Ops directory sed nal RTM user its source users Oracle HR Example User's build 10g,11g can be Put the 10. sql files on the attachment (see the end of the article) in this path first: $ORACLE _home/demo/schema/human_resources
Script Name
Description
Hr_analz.sql
Collects statistics on the tables in the schema.
Hr_code.sql
Creates procedural objects in the schema.
HR to throw a resume, you cry is useless. But know hr clock what kind of resume, hate what kind of resume, you will not have to cry!
Don't cry, the hardest resume to write like this!
Speaking of the most difficult part of a resume, most people's minds are bound to flash the words "work experience is the hardest to fix." But this is not the case, according to HRM published the "Resume Deliv
A letter to HR newcomers
Hello, HR!
Congratulations, you have entered a field with broad future prospects. As human resources are gradually recognized and human resources are viewed from a strategic perspective, this will be a perfect place for you to do your best.
It also reminds you that you may have entered a place with low salary, high morale, complex interpersonal relationships, and subtle relationshi
I will share with you my experience in HR Recruitment and interview over the past five years.
This article from http://job.csdn.net/n/20060815/93744.html
I have been doing HR full-time recruitment for several years. Recently, I feel that this topic is getting hotter and hotter. From the HR perspective, I will talk about some questions about recruitment interview
The Oracle HR sample user's build 10g,11g can bePut the 10. sql files on the attachment (see the end of the article) in this path first:$ORACLE _home/demo/schema/human_resources
Script Name
Description
Hr_analz.sql
Collects statistics on the tables in the schema.
Hr_code.sql
Creates procedural objects in the schema.
Hr_comnt.sql
Creates comments for each object in the
The environment of modern enterprise is undoubtedly informationization, human resource management is the fundamental and key of competitiveness, and the system application of HR management function has become a powerful, mature, stable and perfect standard for measuring an integrated administrative platform. Therefore, the establishment of a collaborative OA system based on the integration of HR function pl
First Kindheight:2px; is the height of HRBorder:none; there is no borderborder-top:2px dotted #185598; is the style that sets the horizontal lineDotted dashed #185598 color--------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------- ---------The second Kind-----------------------------------
I. Made a major change to the system architecture and applied it to the HR system.1. added a large number of General scripts (JS/function. JS)Mainly some scripts for commonly used Ajax applications and custom control applications.Implemented the interface adaptive Function2. modified the style of the pop-up window.3. added custom controlsDrop-down control [features of hierarchical selection]Custom Textbox C
Practical job suggestions for graduates from eight years of recruitment experience of senior HR
Source: 51cto.com Release Date: Reading: 139 original link full screen reading [favorites]
Editor's comment: for work reasons, I have been responsible for the management of several units, such as Chinese and foreign companies. Recruitment is also a work of the author. Let's talk about some issues encountered during the actual recruitment interview and g
These two days found a site called to see, is known to the Big Neusuli Ann, which crawler use of node. js. Here, for the last blog of the United States play small reptile, switch to Nodejs to achieve, experience a powerful node. js.If you've never used JavaScript before, go to http://www.codecademy.com/to get started with JavaScript and JQuery and quickly get familiar with the basic syntax, and there's plenty of other languages to base your day. With a basic understanding, you will find two majo
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.