Niesha Wright
Unit 5 Homework
SQLCourse: I got through Deleting Record Answers
W3school.com: I got through Combining and & OR
Which one do you prefer? Why
Over all I like them both, because they educate you on writing codes in different ways, but keeps the same format. SQLCourse allows you to try and answer the questions at the end of the course, while W3school lets you try and write code and gives you corrective answers.
Over all I like W3school because it allows more hands on teaching. W3school allows you to create your own code and run it, while providing results. When SQLCourse just gives you the answers to code questions. To me, SQLCourse is more like a study guide.
I learn a lot better when I complete my work hands on. And W3school.com makes me feel like I’m really learning.

Look up the data types for Oracle. How do they differ from SOL Server’s? Number datatype convert from Oracle to SQL Server | Oracle(source) | SQL Server(target) | number | Float | number([1-38]) | numeric([1-38]) | number([0-38],[1-38]) | numeric([0-38],[1-38]) | float | float | float([1-53]) | float([1-53]) | float([54-126]) | float | binary_float | float | binary_double | float(53) | int | numeric(38) | real | float |

Number datatype convert from SQL Server to Oracle | SQL Server(source) | Oracle(target) | bigint | NUMBER(19) | int | NUMBER(10) | smallint | NUMBER(5) | tinyint | NUMBER(3) | bit | NUMBER(3) | numeric | NUMBER(p[,s]) | money | number(19,4) | smallmoney | NUMBER(10,4) | float | FLOAT(49) | real | FLOAT(23) | Look up the ANSI data types. How do they differ from that of SQL Server and Oracle?
ANSI uses different names for data types than both Oracle and SQL Server. ANSI SQL Datatype | Oracle Datatype | CHARACTER(n)CHAR(n) | CHAR(n) | CHARACTER VARYING(n)CHAR VARYING(n) | VARCHAR2(n) | NATIONAL CHARACTER(n)NATIONAL CHAR(n)NCHAR(n) | NCHAR(n) | NATIONAL CHARACTER VARYING(n)NATIONAL CHAR VARYING(n)NCHAR VARYING(n) | NVARCHAR2(n) | NUMERIC[(p,s)]DECIMAL[(p,s)] (Note a) | NUMBER(p,s) | INTEGERINTSMALLINT | NUMBER(38) | FLOAT (Note b)DOUBLE PRECISION (Note c)REAL (Note d) | FLOAT(126)FLOAT(126)FLOAT(63) |