New answers tagged oracle-sql-developer
In SQL*Plus, execute external scripts using @filename (http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_five.htm#i1210918). This also works in SQL Developer, just be aware of the differences between relative & absolute directory.
Yes, but it's expensive. If you fetch all the rows down to the client, then the export will use that recordset for the export. If it's a long running query of a few rows, no big deal. If it's a long running query of millions+ of records, you might exhaust the JVM or upset the network guy/gal. I talk about this more here.
There are some SQL Developer specific comments/"hints". For example if you run the below as a script (F5) and not a statement (Ctrl-Enter): select /*csv*/ * from table; You will get the results in CSV format the first time already. You can even spool the output just as in SQL*Plus. So you could just run the below block of code as a script (select lines ...
The closest thing you can do is defining procedures in anonymous blocks, for example: Declare val number; Procedure P1(abc in number, def out number) is begin def := abc*abc; end; begin For i in 1..10 loop P1(i,val); dbms_output.put_line(val); End loop; end; / Another feature is defining PL/SQL functions for a ...
If by 'compatible' you mean 'certified by Oracle', I think you'll need to go back to SQL Developer 1.5: Developed in Java, Oracle SQL Developer runs on Windows, Linux and the Mac OS X. With the default connectivity to the database is through the JDBC Thin driver, no Oracle Home is required. To install Oracle SQL Developer simply unzip the downloaded ...
You don't need to use a regular expression for that. Instead, you could use the replace function in SQL like this: replace(MODEL, ' ', ' ') where MODEL is your column, ' ' is the character(s) that you want to replace and ' ' is the character(s) you want to replace with.
The listener works as expected. It is configured to listen at localhost (127.0.0.1) and so it cannot accept connection from another host. I assume that the listener runs on host with IP 192.168.1.130 . So in the listener configfile change localhost to 192.168.1.130 and restart the listener. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = ...
Top 50 recent answers are included