![]() ![]() Many of our departments support the educational and research missions of the four University of Colorado campuses, but System Administration is not considered a campus. System Administration, which also houses the Office of the President, is located in the uptown neighborhood of Denver with a few smaller offices located on the campuses. Go to Tools->preferences->database->NLS parameters.įor putting some light on this behaviour, Enviornment in our case was Oracle eBusiness Suite which has lots of language specific views (only returns records where userenv(‘LANG’) matches an installed language in eBusiness).Senior Drupal Developer - 29265 University Staff SQL Developer : SELECT USERENV (‘LANG’) FROM dual => GBĪfter following below steps for changing LANG settings on sql deveoper issue resolved □Ģ. TOAD : SELECT USERENV (‘LANG’) FROM dual => US ![]() I checked USERENV(‘LANG’) settings in both the tools & found that : Which states this issue happens when the query is dependent on the results of USERENV(‘LANG’). □Īfter searching on metalink I found : SQL Developer Returns Zero Rows on Table while SQL*Plus Returns Positive Count (Doc ID 415920.1) Means When I run the one query directly on SQLPLUS or TOAD then it displays complete results, while I run the same query with SQL Developer then it does not provide me any result. Unexpectdely I got 300 rows with same query. I tried executing same query by logging with her credentials on my PC but through TOAD (not SQL developer). According to her it was an unexpected behaviour & expecting some rows from that query.Īfter having some chat got to know that she was using SQL Developer as tool for running that query. One of the developer in my company was complaining that, she is getting “no rows selected” after executing some select query. Some days before I came across very weird issue with SQL Developer. ( 13 Comments ) SQL Developer providing incorrect query results than TOAD/sql*plus. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |