Sedang Disiapkan

SQL Oracle HELP/ASAP please! 7hrs

1. Create a table called EMPLOYEES with the following column. (If you already have an EMPLOYEES table, drop it.)

*SSN, a number with 9 digits

*Lastname, to hold text up to 25 characters in length

*first name, to hold text up to 25 characters in length

*MI, a fixed-length single character

*hire date, a date with a default value of SYSDATE

*address, to hold text up to 24 characters in length

*City, to hold text up to 20 characters and a default value of 'Columbia'

*state, a fixed length character field with two characters with a default value of 'SC'

*zip, a number with 5 digits

2. Drop the column MI from the EMPLOYEES table

3. Add a column middlename to the EMPLOYEES table with the same data type as firstname. You will be using this EMPLOYEES table in a future assignment.

4. Create a table called WRITERS with the first and last names of the authors and the titles of the books they wrote. Get the data for the table from the existing tables in the database.

5. Delete the table WRITERS from the database permanently.

Kemahiran: Oracle, SQL, Pentadbiran Pangkalan Data, Pelayan Microsoft SQL, Pembangunan Pangkalan Data

Lihat lagi: sql oracle converter, getafreelancer message sql query help needed, convert sql oracle, sql oracle convertor, freelancer sql oracle project, dal sql oracle, str decrypt sql oracle javascript, sql statements help, crystal report modifications migrating data source sql oracle, dotnet sql oracle, convert sql oracle sql, database sql query oracle help, top 1 sql oracle, oracle sql developer help center, consider the following data answer questions 9 15 13 15 16 17 18 18 20 21 22 23 23 23 24 25 26 26

Tentang Majikan:
( 3 ulasan ) Surrey, Canada

ID Projek: #31940573

Dianugerahkan kepada:

WebCodeCorner

Respected Sir/Madam, I have read your project description and got a very much idea of what you want. I am an experienced web developer. I have 6+ years experience in this field and i have expertise Custome PHP, Laravel Lagi

$25 CAD dalam sehari
(4 Ulasan)
2.6

6 pekerja bebas membida secara purata $98 untuk pekerjaan ini

Developershub002

Hi There...! Note : I give you 25% off on my all services. So grabs this special limited discount offer. Let’s get to the Project. I came to know that your  Looking a developer which have rich knowledge about sql d Lagi

$300 CAD dalam 2 hari
(12 Ulasan)
4.0
liveexperts123

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the Lagi

$45 CAD dalam 3 hari
(1 Ulasan)
3.6
(2 Ulasan)
3.4
Shablu4u

Hi, I have a deep understanding and experience in PL/SQL Oracle Server. I can get started right now and will deliver the result in some hrs. ************************************************************************ I'm Lagi

$60 CAD dalam sehari
(1 Ulasan)
1.5
tariqmubashir99

I am a computer engineer and working in a software house for more than 2 years i can help you with table creation in SQL and as i have already worked on it. Plesae feel free to chat so that i could start working on it.

$35 CAD dalam 7 hari
(0 Ulasan)
0.0