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;


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;


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



  1. 😈 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 — 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

  5. An outstanding share! I have just forwarded this onto a co-worker who had been doing a
    little research on this. And he in fact bought me dinner
    simply because I discovered it for him… lol.

    So let me reword this…. Thanks for the meal!!
    But yeah, thanx for spending some time to talk about this topic here on your site.

    Comment by wasc accredited program — September 3, 2014 @ 3:05 pm

  6. Userul information. Lucky me I discovered your
    website unintentionally, and I’m shocked why this twist of
    fate didd nnot happened iin advance! I bookmarked it.

    Comment by http://hostgatorcoupon.Today/ — October 5, 2014 @ 6:57 am

  7. My partner and I stumbled over here from a different website
    and thought I may as well check things out.
    I like what I see so now i am following you. Look forward to going over your web page yet again.

    Comment by blogging tips — May 26, 2017 @ 4:31 pm

RSS feed for comments on this post. TrackBack URI

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

Create a free website or blog at

%d bloggers like this: