Oracle SQL Developer is a free and fully supported graphical tool for Oracle database development.
How to export Oracle DB data using SQL Developer? I need all data, tables, constraints, structure and so on.
sql oracle oracle-sqldeveloperI'm trying to connect to a database using SQLDeveloper and I get the following error: An Error was Encountered performing …
database connect oracle-sqldeveloperI have a transdate column of varchar2 type which has the following entrees 01/02/2012 01/03/2012 etc. I converted it in to date …
sql oracle oracle-sqldeveloperWhen I try to execute this statement in Oracle SQL Developer 2.1 a dialog box "Enter Substitution Variable" pops up asking …
oracle oracle-sqldeveloperIn Sql Server, often times when I'm testing the body of a stored procedure, I copy the body into SSMS, …
sql-server oracle tsql plsql oracle-sqldeveloperI have exported database from Oracle SQL developer tool into .sql file. Now I want to run this file which …
sql oracle oracle-sqldeveloper* EDIT6: * This is what ended up working for me (from accepted answer): var ret1 number var tran_cnt number var …
oracle stored-procedures plsql oracle-sqldeveloper sys-refcursorI have recently installed sqldeveloper but i'm getting the below warning window when I try to launch it. This is …
java oracle11g oracle-sqldeveloperIs there a way to display all the views currently set on an oracle database via sql developer? Thanks.
database oracle view oracle-sqldeveloperI have few SQL queries which has very low query running performance and I want to check the query execution …
sql oracle oracle-sqldeveloper sql-execution-plan