Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 565
  • Last Modified:

Oracle SQL Developer tool and data import

I have an Oracle database on UNIX with Table1 and Table2 created by user1. I have connected to that database via SQL Developer and imported data into Table1 and Table2 from different csv files. When I run select statement on SQL Seveloper on either table, it shows correct data. But when I attempt to run a query from SQL Plus on another computer, my selects do not return any records. Why is this happening?
0
YZlat
Asked:
YZlat
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
Did you commit the records from inside SQL Developer?  If not, then only the session that inserted them can see them.
0
 
YZlatAuthor Commented:
I tried executing commit;
0
 
YZlatAuthor Commented:
Oh, I didn't check the select statements after executing commit; statement:)
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now