I just upgraded to 9.0.2.
When I export query results from an SQL Window to an sql file, the numbers over 1,000,000 have embedded commas. This precludes using the file to insert into another table as the insert looks like too many columns.
JR
Not completely. PLS 8 creates and displays them, but there is no functionality to create or maintain partitions on indexes,split indexes, maintain subpartitions. Probably more if I think about what I do with partitions.
This is a little thing.
An invalid "type" or "type body" does not show up in the browser when the My Invalid Objects option is selected.
They do show as 'INVALID' in the dba_(all_, user_)objects view.
I'm running:
PL/SQL Developer
Version 8.0.3.1510
01.60194 - 1 user license
Windows XP...
This topic has be brought up before. You referenced Oracle Note 414590.1.
I'm running 11.2.0.1. The patch references 9.x thru 10.2.x.
Also when I run the query:
SELECT * FROM DBA_SCHEDULED_JOBS;
from sqlplus (both 10g and 11g client versions), it runs without errors.
I receive this error...
My Oracle Logon pop-up no longer gives me the option to choose the login type, i.e. Normal, SYSOPER or SYSDBA.
I guess I flipped a switch. Anyone have any idea which one?
Thanks - JR
I know there has to be a setting that will save the desktop when you exit and restore it when Developer is started again.
Anyone know where I'd find it?
Thanks - JR
In v8.0...
Where would I find the file that has the key words in it? I want add words like "greatest" to be recognized as a key word.
I know there's probably a setting in Preferences for it someplace.