Results 1 to 14 of 14
  1. #1
    Join Date
    Oct 2012
    Posts
    5

    Arrow ROLL in HELP INDEX SQL 10g

    I have found Problem in ROLL....
    b'coz all SQL*PLUS commands are works WITHOUT semicolon'',
    but in HELP INDEX command ROLL is not listed....
    so what exactly ROLL does...and WHY IT IT SUPPORTED WITH OUT SEMICOLON';'...

  2. #2
    Join Date
    Jun 2004
    Posts
    745
    I have never come across the 'ROLL' command before, and I, too, would be interested to know what it does.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,427
    unless he means ROLLUP?
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Mar 2010
    Location
    Vienna, Austria
    Posts
    149
    it is supported without the semicolon, because it's the old (< Oracle V6) version of the command and kept for compatibility.

    Concerning what exactly it's doing:

    Guess:

    Code:
    SQL> roll
    Rollback complete.
    SQL>
    "There is always an easy solution to every problem - neat, plausible, and wrong."
    -- H.L. Mencken

  5. #5
    Join Date
    Oct 2012
    Posts
    5

    Correct answer

    Difference between rollbac and rollback


    What is the difference between rollbac and rollback?


    SQL> create table t as select 1 x from dual;

    Table created.

    SQL> update t set x=2;

    1 row updated.

    SQL> savepoint a;

    Savepoint created.

    SQL> update t set x=3;

    1 row updated.

    SQL> rollbac to savepoint a;
    Rollback complete.
    SQL> select * from t;
    X
    ----------
    1

    WTF! rollbac does not seem to work correctly

    Actually, ROLL, ROLLB, ROLLBA and ROLLBAC are not valid SQL statements. However, SQLPLUS recognizes it a sqlplus statement but this behavior is not documented.


    SQL> del *
    SQL> roll
    Rollback complete.
    SQL> list
    SP2-0223: No lines in SQL buffer.

    The statement does not end with semi-column and is not stored in the SQLPLUS buffer.

    So it is not a SQL command.

  6. #6
    Join Date
    Oct 2012
    Posts
    5
    Quote Originally Posted by cis_groupie View Post
    I have never come across the 'ROLL' command before, and I, too, would be interested to know what it does.
    see i have posted the right answer...

  7. #7
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,005
    You must be very proud of yourself. Too bad that it is just an exact copy/paste of someone else's answer. It would be fair if you specified that you, actually, found that on the Internet, posted a link and mentioned the original author.

  8. #8
    Join Date
    Nov 2003
    Posts
    2,815
    Quote Originally Posted by Littlefoot View Post
    You must be very proud of yourself. Too bad that it is just an exact copy/paste of someone else's answer. It would be fair if you specified that you, actually, found that on the Internet, posted a link and mentioned the original author.
    Looking at the language (what's that "b'coz" thing anyway?), the senseless overuse of dots to end a statement and the formatting of the initial question from darshan30589 here and user "967590" in the Oracle forum, I'd say they are both the same person (the copied answer from OTN is also from user "967590" - just like the question)
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  9. #9
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,005
    OK then, I'll correct myself (after some more digging): I agree, darshan30589 on dBforums is the same person as user 967590 on OTN Forums. I also agree that he copied & pasted here what he already wrote there.

    However:I'm pretty sure that darshan30589 / 967590 is NOT Laurent Schneider who posted that in 2008. So, in my opinion, credits go to Laurent Schneider, not our plagiarist.

  10. #10
    Join Date
    Nov 2012
    Location
    Switzerland
    Posts
    1
    Quote Originally Posted by Littlefoot View Post
    I'm pretty sure that darshan30589 / 967590 is NOT Laurent Schneider

    Indeed he is not Thank you littlefoot for the credit.

    I am always having fun with sqlplus

    Code:
    SQL> ROLL AND ROCK
    SQL> DISCO
    Cheers
    Laurent

  11. #11
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,005
    LOL! Ayatollah of disco, roll and rock!

  12. #12
    Join Date
    Oct 2012
    Posts
    5
    Credit always goes to That Author and that is You....but i posted it here for reference of right answer only...and posted it only after Trying it...so no worry....i have already telling thanks to you.. ...Thanks to YOU for Great answer again...

  13. #13
    Join Date
    Oct 2012
    Posts
    5

    Thanks for Great Answer....

    It was your original posted answer...it's GREAT one....Sorry for formatting the Name under the Answer...

  14. #14
    Join Date
    Nov 2003
    Posts
    2,815
    What's the matter with your keyboard? It seems the key with the . character repeats too many times when you press it. You should get that fixed.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •