Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Indicate number as asterisk

roymakaayAug 15 2011 — edited Aug 16 2011
I have given employees table as
SQL> desc employees
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------

 EMPLOYEE_ID                               NOT NULL NUMBER(6)
 FIRST_NAME                                         VARCHAR2(20)
 LAST_NAME                                 NOT NULL VARCHAR2(25)
 EMAIL                                     NOT NULL VARCHAR2(25)
 PHONE_NUMBER                                       VARCHAR2(20)
 HIRE_DATE                                 NOT NULL DATE
 JOB_ID                                    NOT NULL VARCHAR2(10)
 SALARY                                             NUMBER(8,2)
 COMMISSION_PCT                                     NUMBER(2,2)
 MANAGER_ID                                         NUMBER(6)
 DEPARTMENT_ID                                      NUMBER(4)
The question is
Create a query that displays the first eight characters of employees '
last name and indicates the amounts of the salaries with asterisks.
Each asterisk signifies a thousand dollars .sort the data
in desending order of salary . Label the column as Employees and Their salaries
Employees and Their salaries
King            ******************
Kochchar     *********************************
De Haan      *************************
Thank you.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 13 2011
Added on Aug 15 2011
5 comments
5,471 views