Re: question

On Thu, 30 Oct 1997 21:17:08 -0500, "Raj Sankar" <rsankar_at_sundial.net> wrote:

>Please some one help me with the following problems.
>
>I am setting up Oracle 8 at Windows NT and exporting the data from MS SQL
>server.
>
>1. How to define money in Oracle 8 Table.

Oracle does not have a specific "money" datatype. You could use something like:

        number(9,2)

which would give you seven digits to the left of the decimal, and two digits to the right. In the above example, 9 represents the total number of digits precision. You can specify up to 31.

>2. How to define Boolean.

Oracle does not have a boolean datatype. I usually do something like:

	my_boolean_flag	char(1),
	constraint my_boolean_flag_yn 
		check (my_boolean_flag in ('Y','N'))

The above gives you a char field restricted to 'Y' or 'N'.

>3. How to solve more than one memo field per table.

If you are using Oracle8 you might look at the new LOB datatypes. The CLOB datatype lets you store large amounts of single-byte character data, and you can have more than one in table.

Jonathan