(Answered) Create emp and dept tablesfirstly how to create a tableq1

Engineering

Create EMP and DEPT tables.

Firstly How to create a table?
Q1. Display all the records in emp table.
Q2. Display total number of records in emp table?
Q3. Display emp table with salary descending order
Q4. Display all the employees those who were joined in year 1961?
Q5. Display all the employees where employees hired before 01-MAR-2014
Q6. How to display current date?
Q7. Display the employee's names with first letter capitalized and all other letters lowercase for all employees whose name starts with J, A, or M
Q8. Display employees where length of ename is 5
Q9. Display maximum salary in emp table
Q10. Display all employees where ename start with J and ends with S

View complete question

Computer Engineering, Engineering

Category:- Computer Engineering
Reference No.:- M91536766
Price:- $10

Verified Expert

Priced at $20 Now at $10, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Computer Engineering

Question erd assignmentcreate a crows foot erd following

Question: ERD Assignment Create a Crow's foot ERD following the business rules for the ProdCo Company. 1. Each sales representative writes many invoices 2. Each invoice is written by one sales representative 3. Each sale ...

Recall that a floating-point number can be expressed as-1s

Recall that a floating-point number can be expressed as (-1) s (1 + f) 2 e where s, f and e are binary numbers. Recall that s is the sign indicator, f the mantissa (or fractional part), and e the exponent. Suppose the si ...

Push technologythis week covered the emerging trends and

Push Technology This week covered the emerging trends and technologies that may affect businesses as well as consumers. The increase in physiological interaction is another trend that may change how businesses and consum ...

Assignmentthe rebel alliance has secretly been linking

Assignment The Rebel Alliance has secretly been linking planets together via a series of unstable wormholes to enable escape from the Imperial Fleet. The following table lists the wormholes together with the number of pe ...

Test 1 - open loop level step response test1objective to

Test 1 - Open Loop Level Step Response Test 1)Objective: To get familiar with the process vessel and to measure the time constant. Procedure 1 1) Start the CE2000 software and load ?le ‘exp4-1.ict'. You will see the soft ...

Starting out with cpp 8th edition pg 449 7 with

Starting out with Cpp 8th edition Pg 449 #7 WITH MODIFICATIONS! Write a program that asks the user for a file name, and then ask the user for up to 100 input values. Write the user input values to the file. Then read the ...

Question suppose that you are working with gps data from an

Question : Suppose that you are working with GPS data from an Excel spreadsheet and that you map it in ArcMap. However, you are surprised that the data points are in Australia instead of Chile? What could be the possible ...

Question what concerns should be understood about data

Question: What concerns should be understood about data communications being sent over wireless networks? Discuss the pros and cons of one method of transmission, such as Wireless Application Protocol. The response must ...

1 what would be the purpose for a user to protect a

1. What would be the purpose for a user to protect a file from "read" or "write" access by other users? 2. Is there a reason why it would be safer for administrators to use two different accounts when working with a comp ...

In c languageread a double number as 2 digits after the

In C language: Read a double number as 2 digits after the decimal point. The number should have at least 6 digits BEFORE the decimal point. Extract all digits at even positions. Print them in reverse order. Extract all d ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Computer Engineering Expert