Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>It isn't the SQL !</p> <p>The perl code shows two loops. </p> <p>The outer loop is traversed for each entry in the @raw_data array. The value of each @raw_data 'record' is passed as the SITE_NAME parameter to a SELECT statement. </p> <p>You are executing multiple SELECT statements, one for each different site. Each individual SELECT returns an ordered row set, but they are all returning a single row for a single site. It is the order of the site names in the @raw_data array that is driving the order of the output.</p> <p>&lt;----------------------------------------------------------------------> Old entry which was totally misleading.</p> <p>I'll offer a few possibilities.</p> <p>(1) It is a bug. DISTINCT often, but not necessarily, does a sort to remove duplicates. It MAY have, for some reason, determined that the ORDER BY is redundant because of the query plan chosen.</p> <p>To determine this, check the query plan. EXPLAIN PLAN is simplest, but it is better to use DBMS_XPLAN.DISPLAY_CURSOR with the sql_id from v$sql for that SQL.</p> <p>(2) The data is being sorted but there is something causing the sort order to be other than what you expect. Try replacing PE_FQDN with DUMP(PE_FQDN) PE_FQDN. This will show the bytes that it is actually using.</p> <p>(3) the SELECT doesn't look exactly how you have said. For example</p> <pre><code>SELECT FRED BILL, BILL BILL_TOO FROM table ORDER BY BILL </code></pre> <p>will actually order by the column that has the alias BILL (which is the column FRED) and not by the column BILL.</p> <pre><code>SELECT FRED, BULL FROM table ORDER BY 'FRED' </code></pre> <p>will sort by the string 'FRED', not the value in the column FRED (and since everything is sorted by the same value, it won't actually do anything).</p> <p>&lt;--------------------------------------------------------------------------------------></p>
    singulars
    1. This table or related slice is empty.
    1. POUsing ORDER BY to sort data
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USGary Myers
    1. USGary Myers
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COyou can also use the number of the column - as ORDER BY 3
      singulars
      1. PO
      1. USRandy
    2. COthis is the result of the DUMP(PE_FQDN): Typ=1 Len=37: 115,117,114,48,49,46,101,98,97,108,116,105,109,111,114,101,115,116,46,109,100,46,98,97,100,46,99,111,109,99,97,115,116,46,110,101,116
      singulars
      1. PO
      1. USjmg0880
    3. COMaybe I should add that the first column is coming from the user and not from the database.
      singulars
      1. PO
      1. USjmg0880
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload