Coskan’s Approach to Oracle

April 23, 2007

Oracle Idiosyncrasies

Filed under: Tips — coskan @ 5:33 pm

Again stumbling upon  internet, I found interesting staff about Oracle by Yong Huang who claims we can’t find anywhere else about what he wrote. Before checking out his web page lets prove one bug like thing he wrote about comments in Oracle.

hr@XE> drop table t PURGE;

Table dropped.

sys@XE> drop table t purge;

Table dropped.

sys@XE> create table t (a number);

Table created.

sys@XE> insert into t values (123);

1 row created.

sys@XE> /*update T set a=321 where a=123;*/

1 row created.

sys@XE> /*insert into T values=456 */

1 row created.

sys@XE> /*example comment*/

1 row created.

sys@XE> /* working comment because of the beginning with space character*/
sys@XE> –this is what a comment must begin with
sys@XE> REM and again this is what a comment must begin with
sys@XE> select * from t;

A
———-
123
123
123
123

sys@XE>—you have 3 more rows and guess what will happen when you commit
sys@XE> commit;

Commit complete.

sys@XE> select * from t;

A
———-
123
123
123
123

This case is working for all statements you execute before the comment because the interpreter runs the previous command if you don’t have space after asterix. Woooow think about what this can cause for your commented batch operations

If I were you I would be careful before commenting and would use — instead of /* */

Now its time to read all off the Oracle Idiosyncrasies

About these ads

4 Comments »

  1. :twisted: incredible !

    Comment by laurentschneider — April 26, 2007 @ 11:25 am

  2. This paragraph provides clear idea designed for the
    new users of blogging, that actually how to do blogging.

    Comment by earn cash with files — April 26, 2014 @ 5:00 am

  3. I read this paragraph fully regarding the comparison of most up-to-date and preceding technologies, it’s remarkable article.

    Comment by Krysteltrain.over-blog.com — May 18, 2014 @ 2:54 am

  4. If some one wants to be updated with latest
    technologies afterward he must be visit this web site and be up to date all the time.

    Comment by قصة قصيرة — August 7, 2014 @ 4:17 am


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Silver is the New Black Theme. Create a free website or blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 203 other followers

%d bloggers like this: