Updating tinyint columns in oracle
To migrate data and database schema from a My SQL database use SQLines Data tool.
First, some conventions: Tip For performance reasons, it is often a good idea to set BLOB and CLOB columns as lazy Loaded.
A resultset containing one of more very large columns takes time to transit between the database and the PHP server, so you want to make sure this only happen when you actually need it.
With SQL Server we have the following options based on the size required. The Oracle equivalent of these datatypes would be the NUMBER datatype specifying a precision based on the size required and a scale of 0.
Specifying precision and scale should ring a bell for SQL Server DBAs when it comes to the decimal and numeric datatypes we use in SQL Server.
DECIMAL[(p[,s])] and NUMERIC[(p[,s])] in SQL Server can be represented by NUMBER(p,s) in Oracle.