Let the user type his first and last name

Assignment Help PL-SQL Programming
Reference no: EM13311869

The program should let the user type his first and last name.

Please can you make this by using.
- File processing
- class
- search by name.
- make choice to delete users.
- display user and his/her answers.


Attachment:- Friend-finder.jpeg

Reference no: EM13311869

Questions Cloud

Explain the rate will be quadrupled : For the zeroth-order reaction: A ? products, what will happen to the rate of reaction if the concentration of A is doubled? A) The rate will be halved B) The rate will be doubled C) The rate will be quadrupled D) The rate will remain the same
What ids the speed of the galaxy relative to earth : Wavelengths of light from a remote galaxy are found to be 1.5 % longer than the corresponding wavelengths measured here on earth. What ids the speed of the galaxy relative to earth
Explain the rate of reaction if the concentration of b : For a reaction that follows the general rate law, Rate= k[A] [B]^2, what will happen to the rate of reaction if the concentration of B is increased by a factor of 3.00?
Determine the length of each side of the cube : On average, each American produces 20,000 kg of CO2 per year, mostly through the consumption of fossil fuel such as oil, coal, and natural gas. determine the length of each side of the cube
Let the user type his first and last name : The program should let the user type his first and last name.
What is the potential difference between the birds feet : A bird sits on a high-voltage power line with its feet 4.6 cm apart. What is the potential difference between the bird's feet
What is the current in the solution : Two electrodes are placed in a calcium chloride solution and a potential difference is maintained between them. what is the current in the solution
Explain ethers react with hi to form two cleavage products : Ethers react with HI to form two cleavage products. One of the products might react further with HI. In the first box below draw the two major products that could be recovered after treatment with one equivalent of HI
Explain what is the poh of 0.05 m ba(oh)2 : At a certain temperature, Kw = 1 x 10-13. This means that pH + pOH = 13 at this temperature. Given this, what is the pOH of 0.05 M Ba(OH)2 at this temperature

Reviews

Write a Review

PL-SQL Programming Questions & Answers

  Display all the lastnames from the customers

Display all the LastNames from the Customers table and any associated OrdersIDs from the Orders Table. Show the LastName even if they do not have any associated orders. Order the results by LastName in ascending order.

  Write command to list all the employees in year

Write the command to list all the employees hired in 2003 and 2004. Sort the rows by the hire_date column in descending order.

  An er diagram for the system

An ER diagram for the system. Show all entities, relationships, cardinalities and optionalities. Also, include all intersection entities. You must use the Finkelstein methodology as per the study book and tutorials.

  Add three rows to the downloads

Add three rows to the Downloads table: one row for user 1 and product 2; one for user 2 and product 1; and one for user 2 and product 2. Use the GETDATE function to insert the current date and time into the DownloadDate column.

  Write the queries in sql

Write your queries so that the final answers will never include duplicates, but add the keyword DISTINCT only in cases where duplicates would otherwise be produced.

  Write programme in oracle to make employee table

List the employee_id and employee_name of the employees form the l_employees table with the top 4 credit limits.

  Create student sorting table

Student.txt in the attachment contains the roster of a class. Each student object has the following fields: student id, last name, first name, academic level.Create a RosterClass to store the student database in vector.

  Create a view named productsummary

Create a view named ProductSummary that uses the view you created in exercise 4. This view should return some summary information about each product.

  Write sql create table statement to create pet table

Write an SQL CREATE TABLE statement to create the PET table without referential integrity constraint on OwnerID in PET.

  Write pl-sql block that displays last name

Write PL/SQL block which displays last name and salary of following people. Each of these can be done separately as PL/SQL, first to test and get output lines.

  Decomposition for r = (a,b,c,d,e )

Give a good decomposition for R = (A,B,C,D,E ) with the following functional dependencies:

  How does the order of joins in an sql statement

How does the order of joins in an SQL statement affect the performance of the join and what can the DBA do to determine the preferred order of joins for an SQL statement that includes the join of at least three tables?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd