I gang

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.

Evner: Oracle, SQL, Database Administration, Microsoft SQL Server, Databaseudvikling

Se mere: 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

Om arbejdsgiveren:
( 3 bedømmelser ) Surrey, Canada

Projekt ID: #31940573

Tildelt til:

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 Flere

$25 CAD på 1 dag
(4 bedømmelser)
2.6

6 freelancere byder i gennemsnit $98 timen for dette job

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 Flere

$300 CAD in 2 dage
(12 bedømmelser)
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 Flere

$45 CAD in 3 dage
(1 bedømmelse)
3.6
(2 bedømmelser)
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 Flere

$60 CAD på 1 dag
(1 bedømmelse)
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 in 7 dage
(0 bedømmelser)
0.0