What is mysql data type of Oracle “NUMBER”?

Oracle data type: NUMBER
The “NUMBER” data type stores fixed and floating point numbers. It can store virtually any numerical value. If your system is running Oracle Database, portability between systems is guaranteed with up to 38 digits of precision.

The NUMBER column can contain the following numbers:

A positive number in the range 1 x 10 – 130 to 9.99 … 9x 10125

Oracle guarantees the portability of numbers with the precision of 38 digits or less. When specifying numeric fields, it is better to specify precision and scale.

MySQL Data type
BIG INT:NUMBER (19, 0)
INT:NUMBER(10,0)
MEDIUMINT:NUMBER(7, 0)
NUMERIC:NUMBER
SMALLINT:NUMBER(5,0)
TINYINT:NUMBER(3,0)
YEAR:NUMBER

primary keyのIDでnumberを使われていれば、intでいいでしょうね。

Oracle Long

Columns defined as Long can store variable-length character data containing up to 2 GB of information. Long data is text data which is converted properly even if it moves between different systems.

Columns of the LONG data type are used in the data dictionary to store the text of the view definition. You can use the Long column of the SELECT list, the SET clause of the UPDATE statement, and the VALUES clause of the INSERT statement.

java.util.Properties props = new java.util.Properties();
props.put("user", "scott");
props.put("password", "tiger");
props.put("server", "myserver");

Driver myDriver = (Driver)
  Class.forName("weblogic.jdbc.oci.Driver").newInstance();

Connection conn = (weblogic.jdbc.oci.Connection)
	myDriver.connect("jdbc:weblogic:oracle", props);

	conn.waitOnResources(true);