Console - DISPLAYS RAW RECORD

Displays details on the given record from the last returned result-set in a binary format.

Syntax

DISPLAY RAW RECORD <record-number>
  • <record-number> Defines the relative position of the record in the last result-set.

Example

  • Query the database on the class V to generate a result-set:

    orientdb {db=GratefulDeadConcerts}> SELECT song_type, name, performances FROM V LIMIT 6
    
    -----+-------+--------+----------+-------------------------+--------------
     #   | @RID  | @CLASS | song_type | name                   | performances
    -----+-------+--------+----------+-------------------------+--------------
     0   | #9:1  | V      | cover     | HEY BO DIDDLEY         | 5                 
     1   | #9:2  | V      | cover     | IM A MAN               | 1                 
     2   | #9:3  | V      | cover     | NOT FADE AWAY          | 531               
     3   | #9:4  | V      | original  | BERTHA                 | 394               
     4   | #9:5  | V      | cover     | GOING DOWN THE ROAD... | 293               
     5   | #9:6  | V      | cover     | MONA                   | 1                
     6   | #9:7  | V      | null      | Bo_Diddley             | null       
    -----+-------+--------+-----------+------------------------+-------------
    LIMIT EXCEEDED: resultset contains more items not displayed (limit=6)
    6 item(s) found. Query executed in 0.136 sec(s).
    
  • Display raw record on the song "Hey Bo Diddley" from the result-set:

    orientdb {db=GratefulDeadConcerts}> DISPLAY RAW RECORD 0
    
    Raw record content. The size is 292 bytes, while settings force to print first 150 bytes:
    
    ^@^BV^Rsong_type^@^@^@^G^Hname^@^@^@^G^Htype^@^@^@ ^G^Xperformances^@^@^@ ^A^^out_followed_by^@^@^@ ^V^\out_written)by^@^@^@ ^V^Vout_sung_by^@^@^@ ^V^\in_followed_by^@^@^@ ^V^@civer^\HEY Bo D
    

For more information on other commands available, see Console Commands.