6 Replies Latest reply on Feb 4, 2019 9:21 PM by Manoj Dixit

    Way to display ROWID in Data or Query Result tab.

    Manoj Dixit

      Hi,

       

      We are using SQL Developer 4.0.3.16.

       

      Is there any way to display data with (and order by) ROWID in a database table's Data tab or Query Results pane without specifically mentioning it? I have searched for it in Preferences but could not find a way. But if anyone is aware of it, it will be great to know.

       

      We want to load data from an Excel file using 'Import Data...' interface. We have noticed that the order of the rows may not always be the same in case there are duplicates in the Excel file or events (which are contents of the Excel file) that are based on a sequential order.

       

      Our DBAs have advised us not to use a trigger to insert NEXTVAL value to the primary key of the "Import Data.." into table. So, unfortunately, there's no single column that identifies the PK.

       

      The contents of the Excel file will be prepared by business end users and uploaded by other IT staff who are experts in providing support to the ultimate application but may not necessarily know SQL Developer or concepts such as ROWID, PKs, etc.

       

      Thanks and regards,

       

      Manoj.