Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: opposite of oracle decode

Re: opposite of oracle decode

From: <jkstill_at_gmail.com>
Date: 6 Oct 2005 09:23:39 -0700
Message-ID: <1128615819.643997.109360@f14g2000cwb.googlegroups.com>

Adam Sandler wrote:
>
> Doug... thanks for the reply. I have a follow-up question. Isn't
> UPDATE SET dependent upon the data already existing? If the GUI sends
> this to the data access layer
>
> INSERT INTO T_TEST (Status) VALUES 'Open'
>
> won't I get an error? The status column is set to hold 1 char. If I
> send "Open" to a new row, that busts the properties of the status
> column.

Much typing of questions and answers would result by creating examples and learning if and how these things work. :)

If you are new to Oracle, you really need to create test cases to play with and observe the results.

What causes an error?

What does not cause and error?

What does not cause an error, but still does not work?

etc...

If you really want to learn how Oracle works, print the PDF versions of the following Docs, take them to Kinko's and get them bound. I like the comb binding - easy to replace pages if needed.

Read all of these.

Get this book:
http://www.amazon.com/exec/obidos/tg/detail/-/1590595300 Read all of this one too.
( I just ordered it myself - A definite must read, as   were the previous ones by Tom)

Also this one if you really get into PL/SQL: http://www.oreilly.com/catalog/oraclep4/

HTH Jared Received on Thu Oct 06 2005 - 11:23:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US