En cours

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.

Compétences : Oracle, SQL, Administration de Bases de données, Serveur SQL Microsoft, Développement de bases de données

En voir plus : 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

Concernant l'employeur :
( 3 commentaires ) Surrey, Canada

Nº du projet : #31940573

Décerné à:

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 Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% CAD en 1 jour
(4 Commentaires)
2.6

6 freelances font une offre moyenne de 98 $ pour ce travail

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 2 jours
(12 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 3 jours
(1 Évaluation)
3.6
(2 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(1 Évaluation)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(0 Commentaires)
0.0