Sqlplus annotation BUG

Source: Internet
Author: User

Sqlplus annotation BUG: www.2cto.com [SQL] 23:24:13 @> conn oe/oe @ cry is connected. 23:24:25 OE @ cry>/* test */23:24:38 OE @ cry>/* test */select count (*) from orders; COUNT (*) ---------- 105 used time: 00: 00: 00.05 you can directly write comments or comments in front of them. Note that there is a space after/* (why do you need to explain this space). If we enter ed, when you call the editor to edit commands, write the content/* test comment */select count (*) from orders or write/* test comment */select count (*) in this way (*) from orders or -- test comment select count (*) from orders will prompt an error: ORA-24374: The definition is not completed before reading or executing and reading, as follows: [SQL] 23:24:53 OE @ cry> ed has been written to file afiedt. buf 1 */* test comment */select count (*) from orders 23:25:15 OE @ cry> // * test comment */select count (*) from orders * 1st row error: ORA-24374: Definition of used time not completed before reading or executing and reading: 00: 00: 00.01 23:25:18 OE @ cry> ed has been written to file afiedt. buf 1/* test comment */2 * select count (*) from orders 23:28:27 OE @ cry> // * test comment */* row 1st error: ORA-24374: definition of use time not completed before reading or executing and reading: 00: 00: 00.01 23:35:03 OE @ cry> ed has been written to file afiedt. buf 1 -- test commment 2 * select count (*) from orders 23:35:17 OE @ cry>/-- test commment * row 1st error: ORA-24374: before reading or executing and reading the data, define another one (explaining the case where space is required after/*) as follows: [SQL] 23:28:29 OE @ cry> select count (*) from orders; COUNT (*) ---------- 105 used time: 00: 00: 00.00 23:30:34 OE @ cry>/* test001 */select 123 from dual; COUNT (*) ---------- 105 used time: 00: 00: 00.01 different SQL statements are actually generated The same result (note that there is no space behind/* Here). If there is space, then [SQL] 23:31:06 OE @ cry>/* test001 */select 123 from dual; 123 ---------- 123 used time: 00: 00: 00.01 or above should be regarded as a small BUG in sqlplus comments.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.