Recent content by jrow

  1. J

    Exporting to SQL file puts commas "," in numbers over 1M - bug

    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
  2. J

    Partition Support?

    Is this a planned enhancement? Thanks - JR
  3. J

    Partition Support?

    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.
  4. J

    Partition Support?

    Any chance that full partition support will be available in the future. I hate having to use TOAD to handle partitions! JR
  5. J

    My Invalid Objects (type & type body)

    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...
  6. J

    ORA-01882: timezone region %s not found

    Thanks, when I run the query from sqlplus on my desktop, the error occurs. JR
  7. J

    Add a Toolbar Button that performs a SQL query

    I don't know about a tool button, but I use menu item TOOLS/SESSIONS for a few of those type of queries.
  8. J

    ORA-01882: timezone region %s not found

    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...
  9. J

    Oracle Logon pop-up...

    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
  10. J

    Setting to save the desktop environment?

    That did it. Thanks - JR
  11. J

    Setting to save the desktop environment?

    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
  12. J

    Where is "key word" file?

    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.
  13. J

    PLSD 8: Partitions?

    Is real partition support on the agenda for a future version of PLSQLD? Thanks - JR
  14. J

    v8. Things that don't seem to work.

    That did it. Thanks - JR
  15. J

    Keyboard Mapping... v8

    Never mind. Your suggestion to check for multiple preference set with the same name fixed the problem. Thanks - JR
Back
Top