SQL Developer : 2.1.1.64 When I generate DB doc on my tables my file system fills up with files like _Flashback.html. How can I prevent this? Who on earth might be interested in this data as part of a database documentation? IMHO this should not be included in 'DB Doc' This data is displayed : Operation VERSIONS_XID VERSION...
I need to retrieve quite a bit of data from our oracle DB and to do so I need to run 20+ queries. Is there any way to run more than one query at a time on the same connection? I tried using / to separate the queries, but that simply opens multiple tabs and queries still run sequentially, although I don't have to start them one by one. ...
I try connect to my oracle db with oracle SQL developer and received that message: pic (pictures 1 and 2) if i try connect with sql plus, all well. command : select userenv('LANGUAGE') from dual; result: Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production SQL> select userenv('LANGUAGE') from dual; *USERE...
I have PL/SQL function that returns cursor that holds 28 columns and 8100 rows. When I execute that function from SQL Plus I got the results right away and in SQL Developer I'm running script that takes looong time (about 80 seconds). The same happen from Java code. When number of columns reduced to 2 then I got response in less than 4...
I have installed jdk1.6.0_21 and sqldeveloper(using alien) on debian(lenny). Now when I run sqldeveloper it asks for J2SE installation path, after I type the jdk path it exits with the below error message. Oracle SQL Developer Copyright (c) 2008, Oracle. All rights reserved. Type the full pathname of a J2SE installation (or Ctrl-C t...
Hi I have installed SQL Developer in my system, but how can i utilize the GUI. I am new to this and i want to import datas from Excel to Oracle database using SQL Developer Thanks in advance ...
Hello! We have a lot of our business logic in an oracle database. So we use a lot of PL/SQL code. We build, test, and debug PL/SQL packages, procedures, triggers, and functions. Our current tool is the PL/SQL Developer (http://www.allroundautomations.com/). What are your tools for PL/SQL coding and why do you prefer it to the PL/SQL De...
I get this error: Errors: check compiler log How can I see compiler log in Oracle SQL Developer? ...
I have a table with a field named COMMENT, which appears to be a reserved word. Using SQLDeveloper, if I try: select [COMMENT], another_field FROM table_created_by_idiot_developer I get SQL Error: ORA-00936: missing expression How can I access this field in my select in SQL Developer? (Is this a problem with SQL Developer, or...
Hi, I am writing a small DB utility. I would like to give the user the ability to open an instance of Oracle sqldeveloper directly from this utility. Is it possible to open Oracle sqldeveloper IDE that already connected to a specific DB? Something like sqldeveloper USERID/PASSWORD@DATABASE ...
Hi, I'm using oracle sql developer, or oracle sqlplus. Thank, Mattan ...