Preview

Nt1330 Unit 3 Assignment 1 Data Analysis

Good Essays
Open Document
Open Document
193 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Nt1330 Unit 3 Assignment 1 Data Analysis
SET ServerOutput on

declare a_count number; a_max number; a_min number; a_avg number(4); begin

Select count(*),max(salary),min(salary),avg(salary) into a_count, a_max, a_min, a_avg from hr.employees; dbms_output.put_line('Today our company has ' || a_count || ' employees'); dbms_output.put_line('The average salary in the company is ' || a_avg); dbms_output.put_line('The maximum salary in the company is ' || a_max); dbms_output.put_line('The minimum salary in the company is ' || a_min); end; /

SET ServerOutput on > By default, SQL*Plus doesn’t display output from PL/SQL, execute this command can unblock this function Declares > this is the statements that declare variables, constants, and other code elements, which can then be used within that block
…show more content…
Just add a sentence following this command, You can also use this command to display the value of the

You May Also Find These Documents Helpful

  • Satisfactory Essays

    The following IP schema is designed to fit the needs of the Warehouse Company. The company has purchased and installed all of the required equipment for the network infrastructure. After consulting with their design team and gathering the required documentation and network designs, we are ready to proceed.…

    • 248 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    Is it possible to plug any cable into the wrong connector? If so, which one(s)? What do you think would happen if you plugged something into the wrong connector?…

    • 384 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Nt1310 Unit 3 Summary

    • 734 Words
    • 3 Pages

    Although Zigbee implements a wide assortment of security measures, there are still a variety of vulnerabilities and attack methods that can be used. These attacks and how they can be carried out will be described in this Section.…

    • 734 Words
    • 3 Pages
    Good Essays
  • Good Essays

    The project contains two parts, photogrammetric survey, and GIS analysis. The photogrammetric survey part was done by Agisoft photoscan software. This kind of survey is desired in many fields, such as Archeology field. This is because of the tendency of collapsing in Archeology’s targets. On the other hand, ArcMap and ArcScene are responsible for the data analysis part. With GIS, the complexity of the 3D data can be simplified, the data can be interpreted, and new data can be generated. Plus, we can comfortably work on improving our model by digitizing, coloring, outlining, and updating data even after we finish the project.…

    • 909 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Assignment 4 – Write a one-page executive summary reviewing DevOps Automation tools: Ansible, Chef, Puppet and Saltstack.…

    • 482 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    IS3110: Unit 1 Role Scenario 1) Identify threats to the seven domains of IT within the organization: A. User: Destroy data B. Workstation: Loss of data, not updated C. LAN: Unauthorized user, weak password D. LAN –WAN: Hackers, weak traffic filtering E. WAN- FTP anon uploads, DoS/DDoS F. System Application: Fire, DoS/DDoS, SQL injection corrupting data G. Remote: user virus, remote from office unsecure, VPN tunnel hack 2) Identify vulnerabilities in the seven domains of IT within the organization. A. User: Infected media, social engineering B. Workstation: OS vulnerability, browser vulnerability C. LAN: Worms, LAN OS vulnerability D. LAN-WAN: malicious websites, unblocked ports E. WAN: network outages F. System Application: ISP…

    • 259 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Result Log area: This is a text field where the log or the results of the system is printed so that user is able to know the status of the…

    • 464 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Part 1 1. Write a script which will Create the needed tables as follows: a. Table name : DEPT i. Column datatype Mandatory? PK? FK?…

    • 1169 Words
    • 5 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Visual Promethee main window is displayed that uses a typical spreadsheet to manage the data of effectiveness multi-criteria problem (Figure 4.7). The main window contain all the data have related to the PROMETHEE method (preference function, statistics and evaluation, weights…), this information can be easily input and defined by the decision maker.in addition to that Visual PROMETEE can provide additional features like quantitative criteria as well as qualitative criteria. Besides Visual PROMETHEE software can also handle the definition of variable thresholds in the preference functions (q, p, s), can also…

    • 388 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Data collection would be accomplished by the assigned individual who would screen the emails in the support distribution email box, then move all the misdirected emails to a separate email folder labeled “Misdirected” each day, then and there forwarding a copy to the correct department. The moving of the emails allows a total to be collected each day, so at the end of the week they would be totaled and recorded to measure the effectiveness of the new process. There was a study conducted using research from comparable organizations, using a similar process that concluded that we should have a benchmark of 1 misdirected email a week. Furthermore, we would need someone to monitor the total number of non-technical support request that come in to…

    • 736 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    ISO 17025 Certification, the general requirements for the competence to carry out tests and calibrations, including sampling. It handles testing and calibration carried out using standard methods, non-standard methods and laboratory-developed methods. It applies to all organizations that tests and calibrations. These include, first, second and third - party laboratories, and laboratories where testing and calibration forms part of inspection and product certification.…

    • 498 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    It210-Appendix G

    • 436 Words
    • 2 Pages

    Write “The purpose of this program is to calculate tax for a given salary range”…

    • 436 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    BMIS 325 Phase II Part A: Table Creation and Data Loading Part B: Reports 1.) Human Resources: Select Regions. RegionName, Countries. CountryName, concat(Employees. LastName, ', ' ,Employees.…

    • 485 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Mis562 Week 2

    • 2131 Words
    • 9 Pages

    2. SQL> --2. List employees name, job, and salary that is a manager and has a salary > $1,000…

    • 2131 Words
    • 9 Pages
    Satisfactory Essays
  • Satisfactory Essays

    The three-assessment chosen is John Maxwell Leadership Levels Assessment (JMLL), Myers Briggs Type Indicator (MBTI), and DISC Assessment (dominance, influence, steadiness and compliance). JMLL Preslar focused on lifelong lessons clients will experience through: position, permission, production, people development, and pinnacle (2012. MBTI examined Rashid and Duys the perception and judgement toward different situation that could strengthen or weaken a person ability to live a fulfilling life or career (2015). DISC Newsome examined the influence personality traits have on decision concerning relationship, careers, and life (2000).…

    • 111 Words
    • 1 Page
    Satisfactory Essays