Find Jobs
Hire Freelancers

Oracle Apex Express, simple inputs

$10-30 USD

Closed
Posted about 7 years ago

$10-30 USD

Paid on delivery
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 [login to view URL] 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 [login to view URL] 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.
Project ID: 13200659

About the project

23 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
23 freelancers are bidding on average $26 USD for this job
User Avatar
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 in 1 day
5.0 (11 reviews)
5.4
5.4
User Avatar
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 in 1 day
5.0 (4 reviews)
3.6
3.6
User Avatar
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 few hours. Regards, Luke
$20 USD in 1 day
5.0 (2 reviews)
3.0
3.0
User Avatar
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 application in APEX and have experince in SQL and PL/SQL and I can help you with this project. Please reply me and tell me if you are interested and I'll start right away. Good look picking the right coder! P.S. If you have any questions, suggestions or you already chosed another coder to do this project for you please reply me! Best Regards, Silviu
$10 USD in 0 day
5.0 (1 review)
3.0
3.0
User Avatar
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 https://www.freelancer.com/projects/Software-Architecture-Engineering/Entity-Relationship-Diagram-ERD.html https://www.freelancer.com/projects/PHP-HTML.1/Database-Project.html https://www.freelancer.com/projects/database-administration/Database-Coursework.html I'm assuring you that you will score more than 90% I'm looking forward to hearing from you very soon
$50 USD in 2 days
4.0 (10 reviews)
3.9
3.9
User Avatar
Hi... I am a computer engineer. I have done much work with database and I am also having certificates for the same. I can surely complete this task within timeline. Do text me if you find this suitable. Thank you. :)
$10 USD in 1 day
5.0 (3 reviews)
1.5
1.5
User Avatar
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 management. Worked as a regular DBA for 9i database on Windows. It was a production system for a textile company and was supposed to run 24x7. In addition to configuration and monitoring, I also did tuning of the system both at database and application level. Later had the opportunity to work as a consultant with a defense organization that was working with a variety of domains. Started as a team lead and built application for MIS component of the project. Later assigned to manage the database running on RHEL. Since 2010, I have been configuring, monitoring and tuning 10g/11g RAC databases data center. I have also been managing 10g application server for about seven years.
$20 USD in 4 days
5.0 (1 review)
1.3
1.3
User Avatar
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, SIMULINK, PSPICE, NS2, NS3 based IEEE papers. We can give remote support in Wintel, ADS, Unix, Storage, Backup, Network, Security tracks. Have experience in Active Directory, DNS, DHCP, FTP, IIS, SharePoint, CRM, SQL, WDS, ADRMS,ADFS,ADLDS, SCCM, Citrix Xenserver, Citrix XenApp, CRM,CRM Outlook connector IFD, Linux, Apache, My SQL, Postfix, VM Ware, Vcenter, VCO, VOIP (3CX)WHM, cPanel, H-Sphere, Hosting Controller, Plesk, DirectAdmin based web hosting support. We work in PHP, JAVA, ASP, DOT NET, Prestashop, Magento, woo commerce, OSCommerce, WordPress, Joomla, Web Hosting Panels Programming, LAMP, Android java development, Backend Server APIs, Android, Java, C/C++, Linux, PHP, MySQL, AJAX, JavaScript, C#, Visual Basic, PHP, MS SQL, My SQL, PHOTOSHOP, CSS, Bootstrap, HTML, JQUERY, JAVA, SCRIPT. We specialize in business, technical, academic, commercial, fiction, and Blog Writing, Dissertations, Academic papers, eBooks, Fiction, Sci-Fi thriller, Technical content, Articles, Web content, and blogs
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
6 years experience in software applications development, maintenance and deployment using techologies like , C#, SQL Server, Oracle,MySQL,IIS, Strong skills in HTML, CSS, JQuery, XML with special skills in debugging and I'm also very good at solving difficult non-standard tasks and development.
$10 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Im currently work with apex, sql and plsql since 2009 (3, 4 and 5 version) on many projects of various sizes for a government department of Nayarit, Mexico
$25 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
for example first create table department ( deptno number(10), department_name varchar2(100) constraint department_deptno_pk primary key(deptno) ) ______________________________________________________________________________________- Excellent knowledge of Database: SQL Server 2000, Access, My SQL, Oracle 9i Developer, Oracle 9i SQL,Oracle 9i PL/SQL
$10 USD in 2 days
5.0 (1 review)
0.0
0.0
User Avatar
Hello Madam / Sir, I am a detail-oriented software QA tester having Master degree in computer science and 5+ years of experience in Retail, Telecom, Health and Logistics industries. Currently I am using Oracle Apex for one of my health project. Let me know if you are interested. Thanks, Pankaj S.
$51 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I will try my best I need experience
$12 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Ready same day
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 Development and Customization of Forms, Reports and Interfaces. Expertise in Oracle, Reports 6i, SQL and PL/SQL database programming. Having Good Knowledge on Development skills in developing RICE Components in the domain of Oracle Applications E-Business Suite. Exposure to Oracle E-Business Suite in PO, INV, AP, AR, OM and GL Modules. Having good knowledge in Other Utilities TOAD, SQL LOADER, SQL*PLUS, UTL_FILE. Involved in different stages of project Life Cycle like design, development, testing. Good understanding of the entire Procure to Pay Process, Order to Cash Process and Bills of Material. Good Exposure to Development of Forms, Reports and Customization of Reports. Has worked and have good Knowledge of XML Publisher/BI Publisher Reports. Worked on development of SQL Queries, procedures, functions and packages as per business requirement. Experience in the Creation of value sets and registering the concurrent programs, alerts in AOL.
$25 USD in 1 day
0.0 (1 review)
0.0
0.0
User Avatar
A proposal has not yet been provided
$111 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Lancaster, United States
5.0
14
Payment method verified
Member since Feb 1, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.