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.