HR Schema Question and Answer in Oracle Database 11g.

Hi Friends Today i am share Oracle 11g Database Some Qusetion and Answer.
                                   

1. Display details of jobs where the minimum salary is greater than 10000.

        SELECT * FROM JOBS WHERE MIN_SALARY > 10000

2  . Display the first name and join date of the employees who joined between 2002 and 2005.


        SELECT FIRST_NAME, HIRE_DATE FROM EMPLOYEES

        WHERE TO_CHAR(HIRE_DATE, 'YYYY') BETWEEN 2002 AND 2005 ORDER BY HIRE_DATE



3. Display details of employee with ID 150 or 160.




       SELECT * FROM EMPLOYEES WHERE EMPLOYEE_ID in (150,160)


4. Display first name and join date of the employees who is either IT Programmer or Sales Man.


      SELECT FIRST_NAME, HIRE_DATE

      FROM EMPLOYEES WHERE JOB_ID IN ('IT_PROG', 'SA_MAN')


5. Display employees who joined after 1st January 2008.




SELECT * FROM EMPLOYEES where hire_date > '01jan2008'


6. Display first name, salary, commission pct, and hire date for employees with salary less than 10000.



SELECT FIRST_NAME, SALARY, COMMISSION_PCT, HIRE_DATE FROM EMPLOYEES WHERE SALARY < 10000


7. Display job Title, the difference between minimum and maximum salaries for jobs with max salary in the range 10000 to 20000.


SELECT JOB_TITLE, MAX_SALARYMIN_

SALARY DIFFERENCE FROM JOBS WHERE MAX_SALARY BETWEEN 10000 AND 20000


8. Display details of jobs in the descending order of the title.



SELECT * FROM JOBS ORDER BY JOB_TITLE


9. Display employees who joined in the month of May.


SELECT * FROM EMPLOYEES WHERE TO_CHAR(HIRE_DATE, 'MON')= 'MAY'



10 Display employees where the first name or last name starts with S.



SELECT FIRST_NAME, LAST_NAME FROM EMPLOYEES WHERE FIRST_NAME LIKE 'S%' OR LAST_NAME LIKE 'S%'



11. Display details of jobs in the descending order of the title.



SELECT * FROM JOBS ORDER BY JOB_TITLE


12. Display first name and experience of the employees.


SELECT FIRST_NAME, HIRE_DATE, FLOOR((SYSDATEHIRE_

DATE)/365)FROM EMPLOYEES

13  Display details of the employees where commission percentage is null and salary in the range 9000 to 10000 and department is 30.


SELECT * FROM EMPLOYEES WHERE COMMISSION_PCT IS NULL AND SALARY BETWEEN 9000 AND 10000 AND DEPARTMENT_ID=30



14 Display first name and experience of the employees.

SELECT FIRST_NAME, HIRE_DATE, FLOOR((SYSDATEHIRE_

DATE)/365)FROM EMPLOYEES

15. Display the length of first name for employees where last name contain character ‘b’ after 3rd position.



SELECT FIRST_NAME, LAST_NAME FROM EMPLOYEES WHERE INSTR(LAST_NAME,'B') > 3

SQL SERVER – 2008 R2 – Step By Step Installation Guide With Images

installed  SQL SERVER – 2008 R2 on Window / Window Server 2008.

Step 1  Install IIS 7 see previous blog.

 you Download   SQL SERVER 2008 R2.

Step 2 Go to SQL Server and right click on Setup.

Step 2  Select Planning and check security.

Step 3  View Details and click ok.

Step 4 Select Installation and click new Installation.

Click Next.

Select Check Box and click Next.

Click Install.

Click Next.

Click Next.

Click Next.

Select check Box and click Next.

Click Next.

Enter Instance Id and click Next.

Click Next.

Enter account name and password  click ok then click Next.

Click use the same account for all SQL Server services and click Next.

Click Next.

Click Next.

Click Next.

Click Install.

Click close.

Go to window Firewall with advanced and select inbound Rules.

Port 1433

Select Domain  and Public.

Enter User         sa 

                             Enter Password               Welcome1  

click connect.

if you want to connect ip then local ip 127.0.0.1

your SQl server is connect. 

If you used SQL Server other Machine the 

Go to  SQL server configuration manager

 and click Protocols and Enter IP Address your System

click Apply and ok .

THANKS.

Install IIS 7 on Windows Server 2008 R2

Hi Friends. Today i share how to install IIS 7 on windows Server 2008 R2


Step 1   Click Start -> All Programs -> Administrative Tools -> Server Manager.

Steps 2             Go to Roles

Select Web Server  IIS and Click to Next

Step 3 Go to Role Services .     

Select the Check Box and Click Next.

Select Confirmation. 

Click Next Select  Results.

Click Close.

Click Install.

Enter Url       http://localhost/

Finely you have installed IIS7 on window server 2008 R2.

Installing Oracle WebCenter Content 11g.

Hi Friends


Today I am sharing how to Installing Oracle WebCenter Content 11g.

In this blog I would like to briefly show the steps to install Oracle WebCenter Content 11g. Oracle WebCenter 11g is based on Weblogic server now and they also need database schema created just as other Oracle Fusion applications.
 
You can download Oracle XE, Weblogic 10.3.6 and RCU 11.1.1.7 from this url:
 http://www.oracle.com/technetwork/middleware/soasuite/downloads/index.html

You can download Oracle WebCenter Content from the url:
http://www.oracle.com/technetwork/middleware/webcenter/content/downloads/index.html 


If you already have Weblogic installed you can skip this step.

Step 1: Install Weblogic.

Go to Window and write cmd then enter.
provide path where you have Weblogic Server.

Now start the installer just use the following command.

java ‐jar wls1036_generic.jar 

 

 

                                                            Click Next.

                                    Select the path and click Next.

                             
                                         Click Next.

                                     Select the JDK and click Next.
                                          

                                     Click Next.

                                         Click Next.

                                           Click Done.

Step 2: Install database schemas using RCU.

You download is ofm_rcu_win_11.1.1.6.0_disk1_1of1.zip. Unzuip this file into the folder RCU and
run the following command.

 Here it is assumed that Oracle XE 11g is installed already see previous blog.

 Go to RCU  path  C:\rcuHome\BIN\rcu.bat and run.

                                                        Click Next.

                                                    Enter User name sys
                                                    Enter Password  welcome
                                                    Click Next.

                                                          Click Next.

                                                   Click Ok.

                
                                                  Click select and click Next.

                                                Click Ok.
                                                Enter the password  welcome.
                                                click Next.

                                                 Click Next.

 Step 3: Install Oracle WebCenter Content 11g.

The download of WebCenter Content 11g are two zip files: 

ofm_wcc_generic_11.1.1.8.0_disk1_1of2.zip and ofm_wcc_generic_11.1.1.8.0_disk1_2of2.zip.

cd  C:\UCM(11.1.1.8)\ofm_wcc_generic_11.1.1.8.0\Disk1.

setup ‐jreLoc C:\Java\jdk1.7.0_06.

                                               Click Next.

                                               Click Next.
 

                                                Click Next.

                                               Click Next.

                                                    Click Next.

                                                  Click Next.
 

                              

                                                  Click Finish.

 Step 4: Create WebCenter Content Domain.

 Go to Window and open CMD.
 Enter path  C:\Oracle\Middleware\Oracle_ECM1\common\bin\config.cmd

                                                Click Next.

                                              Choose the products which you have need and click Next.
                                               

                                  
                                                      Enter Domain name and click Next.

                                               User name: weblogic and password: welcome1
                                               

                                                 Select Jdk and click Next.

                                               DataBase Sid Name  orcl or XE.
                                               DataBase Host Name  localhost
                                               DataBase port number  1521.
                                                Password  Welcome1. and Click Next.

                                                    Click Next.

 
                                                         Click Next.
                                             

                                                    Enter the name of server and Click Next .

                                                     Click Next.

                                                       Click Next.

                                                         Click Next.

                                                  Click Next.

                                                    Click Create.

                                                   Click Done.

 Step 5: Start WebCenter Content 11g

Now WebCenter Content 11g can be started.
This command is used to start the Admin server.

 

C:\Oracle\Middleware\user_projects\domains\ecm_domain\bin\startWebLogic.cmd.

 This commands are used to start the managed servers.

C:\Oracle\Middleware\user_projects\domains\ecm_domain\bin\startManagedWebLogic.cmd UCM_server1

if you want to start IPM_server1 then.

C:\Oracle\Middleware\user_projects\domains\ecm_domain\bin\startManagedWebLogic.cmd IPM_server1

if you want to start IPM_server1 then.

C:\Oracle\Middleware\user_projects\domains\ecm_domain\bin\startManagedWebLogic.cmd IBR_server1