oracle-sqldeveloper

Does anybody know what encrypting technique is JDeveloper/SQL Developer using to persist credentials?

by

For the curious, what you’re actually seeing is the secret key concatenated with the encrypted password. For example, I tried encrypting the password “SAILBOAT” using: DatabaseProviderHelper.goingOut(“SAILBOAT”) In this particular instance, the result was: 0527C290B40C41D71139B5E7A4446E94D7678359087249A463 The first byte is constant: 05 The next 8 bytes represent the randomly generated secret key (for the DES cipher): 27C290B40C41D711 … Read more

Remove Column Header into the Output Text file

by

SQLPLUS COMMAND Skipped: set heading off That message is most likely because you are not executing it through SQL*Plus, but some GUI based tool. You are using SQLPlus command in SQL Developer. Not all SQL*Plus commands are guaranteed to work with SQL Developer. I would suggest you execute the script in SQLPlus and you would … Read more

copy from one database to another using oracle sql developer – connection failed

by

The copy command is a SQL*Plus command (not a SQL Developer command). If you have your tnsname entries setup for SID1 and SID2 (e.g. try a tnsping), you should be able to execute your command. Another assumption is that table1 has the same columns as the message_table (and the columns have only the following data … Read more

How can I insert into a BLOB column from an insert statement in sqldeveloper?

by

To insert a VARCHAR2 into a BLOB column you can rely on the function utl_raw.cast_to_raw as next: insert into mytable(id, myblob) values (1, utl_raw.cast_to_raw(‘some magic here’)); It will cast your input VARCHAR2 into RAW datatype without modifying its content, then it will insert the result into your BLOB column. More details about the function utl_raw.cast_to_raw

org.hibernate.QueryException: could not resolve property: filename

by

Hibernate queries are case sensitive with property names (because they end up relying on getter/setter methods on the @Entity). Make sure you refer to the property as fileName in the Criteria query, not filename. Specifically, Hibernate will call the getter method of the filename property when executing that Criteria query, so it will look for … Read more

how to modify the size of a column

by

Regardless of what error Oracle SQL Developer may indicate in the syntax highlighting, actually running your alter statement exactly the way you originally had it works perfectly: ALTER TABLE TEST_PROJECT2 MODIFY proj_name VARCHAR2(300); You only need to add parenthesis if you need to alter more than one column at once, such as: ALTER TABLE TEST_PROJECT2 … Read more

How can I keep Oracle SQL Developer from closing the DB connection?

by

Answer It’s most likely a firewall between SQL Developer and the database that breaks things. You can solve that from SQL Developer using the SQL Developer Keepalive plugin. You can also fix this from the Database Server by using the answers by Thomas and David Mann. Oracle Net can be configured with Dead Connection Detection … Read more