![]() ![]() 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). 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) ![]() Plus in the bonus game where coins come up from a pipe you can get at. 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. Taking part in Toad Rally requires special tickets, and if youre looking to play. 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 |