Zamknięty

Oracle Apex Express, simple inputs

Part One

For this assignment you will use the emp and dept tables that exist in your schema.

Projection - a relational database management system (RDBMS) definition of projection is the list of columns selected from a table. A projection will limit the limit the number of rows selected so that you only see that data you want in your result set.

Log in to your ApEx account.

1. Write a SQL query that will select the department number and department name from the dept table. You will have to do a DESCRIBE on the dept table to get the actual spelling of the columns. Copy and paste your SQL query code into your assignment. Run your SQL command and save a screen shot of the result set.

2. Write a SQL query that will select the employee number, employee name and job from the emp table. You will have to do a DESCRIBE on the emp table to get the actual spelling of the columns. Copy and paste your SQL query code into your assignment. Run your SQL file and save a screen shot of the result set.

Selection - a relational database management system (RDBMS) definition of selection means which rows are to be returned in a SQL query.

3. Write a SQL query using the emp table that will return only the employees that have ‘CLERK’ as their job. The columns to be included in the select are: the employee number, employee name and job. Copy and paste your SQL query code into your assignment. Run your SQL file and save a screen shot of the result set.

4. Write SQL query using the emp table that shows only the employees that have a salary greater than 1250. The columns to be included in the select are: the employee number, employee name, job and salary. Copy and paste your SQL query code into your assignment. Run your SQL file and save a screen shot of the result set.

Part Two

Objectives: learn to use the IN and NOT IN operators and the wildcard search operator. Along with a derived value as a column in a result set.

For this assignment we will be using the emp table.

Open ApEx and navigate to the SQL Workshop  SQL Scripts screen:

1. Create a file called [url removed, login to view] script. Write a SQL query that displays the employee number, employee name, manager and job for all employees that have a manger with the ID number of 7839, 7566 or 7902. Use the IN operator to obtain your result set. Copy and paste your query and result set screen shot into your assignment.

2. Create a file called ps3b.sql. Write a SQL query that displays the employee number, employee name job and salary for everyone not in the clerk or salesperson job description. Use the not in operator to filter the results in the result set. Copy and paste your query and result set screen shot into your assignment.

3. Create a file called ps3c.sql. Write a SQL query that will return the empno, ename, job and salary for any employees whose name begins with ‘M’. Copy and paste your query and result set screen shot into your assignment.

4. Create a file called [url removed, login to view] Create a SQL script will show the empno, ename, job, base salary and amount of salary after the raise amount of 20% is applied. The mathematical operation of the sal * 20% will be one of the columns in the result set. Create a column alias for this new derived column called ‘Raise.’ Copy and paste your query and result set screen shot into your assignment.

Umiejętności: Oracle, SQL

Zobacz więcej: arabic articles submit, top 100 articles submit site, travel articles submit, adult blog articles submit, travel articles submit seo, publication articles submit seo, winsock apex oracle, samples short articles submit, money oracle scripts, html css submit articles submit button, articles submit jomsocial, convert oracle scripts sqlserver, paypal simple express checkout tutorial aspnet, convert mssql script oracle scripts, Articles Submit, simple multi photo upload scripts, guitar articles submit, free articles submit website, convert oracle scripts, oracle scripts data entry

O pracodawcy:
( 5 ocen ) Lancaster, United States

Numer ID Projektu: #13200659

26 freelancerów złożyło ofertę na kwotę $27 do tego projektu

truongnguyen86

Hello there, i'm expert on Oracle SQL, let me help you with this. I think i can finish this in a couple of hours. Waiting for your response if interested. Thank you!!

$50 USD w ciągu 1 dnia
(134 Oceny)
6.3
bmartynvw

Hi, My name is Benjamin. I'm an Oracle Apex expert with over a decade of experience. Let me know if you'd like this assignment to be done by me. Regards,

$25 USD w ciągu 1 dnia
(8 Oceny)
4.0
gabidragoi

Hi, I am an Oracle APEX developer, used to work for Oracle Inc. I an also an Apex instructor. I can help you with all your SQL and Oracle assignments. Would love to discuss more with you. Best regards, Gabriel

$15 USD w ciągu 1 dnia
(3 Oceny)
3.5
mdakteruzzaman

Hi, I have been working as Database Analyst Programmer more than 10 years. I became OCP, CCNP, RHCE 3 years back. Earlier I completed B.Sc. Enng and M.Sc. Engg both in computer engineering. Check my works here Więcej

$50 USD w ciągu 2 dni
(10 Oceny)
3.9
lukepl

Hi, I've been developing a Java application cooperating tightly with Oracle for several years now, so I could quickly deliver everything you described in your project. I could start immediately and have it ready in Więcej

$20 USD w ciągu 1 dnia
(1 Ocena)
2.8
quickwriter24

We are highly experienced Post Graduate Engineers, Doctors, IT, ITES, Software, Infrastructure Professionals, Web Designers and IT Architects. We can redo, improve, and publish any engineering, scientific MATLAB, S Więcej

$25 USD w ciągu 1 dnia
(0 Oceny)
0.0
rajeetbgl

Having 16+ years of professional experience in Application Software Development including 4+ years in Oracle Apps 11i/R12. Working in Oracle Applications 11i/R12 Interfaces and Customization. Experience includes Deve Więcej

$25 USD w ciągu 1 dnia
(0 Oceny)
0.0
aab56461bd2338e4

This assignment is so easy. I glade to help you complete this work. I have done many assignments like yours before. I hope you will be happy with the work.

$10 USD w ciągu 1 dnia
(0 Oceny)
0.0
sweethelgrace13

I have already completed this,how will i send the file? I can also make an application on this in APEX, showing the requirements that you want.

$25 USD w ciągu 1 dnia
(0 Oceny)
0.0
$25 USD w ciągu 10 dni
(0 Oceny)
0.0
settconsultant

Greetings from Sett Consultant. Based in Kolkata,India, our team of 8 consists of Oracle Application Express(Oracle Apex) developers,Database designers,DBAs,UI/UX [login to view URL] have young,highly-experienced,professiona Więcej

$25 USD w ciągu 1 dnia
(0 Oceny)
0.0
alengodwin

I'm an SQL developer who has an experience of 6 years in oracle plsql. I can complete the task in a day and full fill your requirements

$10 USD w ciągu 1 dnia
(0 Oceny)
0.0
pauljamesryan

I have over 19+ years as an Oracle Developer/Database Administrator. That being said, based on the requirements listed, this seems to be trivial. Would like to discuss what the ultimate goal of this project is and how Więcej

$30 USD w ciągu 1 dnia
(0 Oceny)
0.0
Nabanitab09

A proposal has not yet been provided

$111 USD w ciągu 1 dnia
(0 Oceny)
0.0
kbilalsalim

Over fifteen years of database design, development and administration experience with oracle. Started as a developer to work with forms and reports. In addition to that I also used to take part in the schema manage Więcej

$20 USD w ciągu 4 dni
(0 Oceny)
0.0
banualexandru

Ready same day

$35 USD w ciągu 1 dnia
(0 Oceny)
0.0
$25 USD w ciągu 0 dni
(0 Oceny)
0.0
vaibhav18992

I will try my best I need experience

$12 USD w ciągu 3 dni
(0 Oceny)
0.0
silviu15

Hi, I have resolved, from part one, request 1 and 4 to show that I can help you with this: 1)select deptno,dname from dept 4)select empno,ename,job,sal from emp where sal > 1250 I have done a lot of appl Więcej

$10 USD w ciągu 0 dni
(0 Oceny)
0.0
quangdai178

Hi, I have 5 years experience in working with oracle 11 and 12G on banking and finance system I already do many things same like your job. - Contact me on skype: quangdai_bkit if you interest. Thanks

$28 USD w ciągu 1 dnia
(0 Oceny)
0.0