The sys.all_source or simply all_source identified correctly but for some reason DataGrip gets the info from data source that is not open/active at the moment. However if we check the same input in a SQL file (not a console) - confirmed. Please check screenshot from Oracle SQL Developer with correct autocomplete and there's not need to enable any option to make it works. As long as PL/SQL Developer and Oracle SQL Developer tools identifies the views and suggest columns correctly I believe its a DataGrip issue. I didn't see someone indicating SYS schema name before a system view in a script or code. Please check below screenshot: a) Console window does not know SYS schema b) there's no suggested columns from the system view, though I think it's because SYS was unresolved. Executed Synchronize command against the data source in Database panel. I checked Data Source properties -> Options tab -> SYS schema is checked. I would like to confirm DataGrip has been improved since I first met it. JVM: OpenJDK 64-Bit Server VM by JetBrains s.r.oĢ. Subscription is active until September 24, 2017 Sublime or Notepad have an advantage - no useless noise warnings.īuild #DB-163.13906.13, built on February 21, 2017
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |