What is the difference between Access and Filter predicates in Oracle execution plan? If I understand correctly, "access" is used to determine which data blocks need to be read, and "filter" is applied after the blocks are read. Hence, filtering is "evil". In the example of Predicate Information section of the execution plan below: 10 ...
How can I view the results returned by a pipelined function in Oracle SQL Developer ? I'm invoking the function using a simple select..from dual like select piaa_extract.FN_PIAA_EXTRACT('01-JAN-00','01-JAN-12') FROM DUAL and the result I get is IQCFINAL.REC_PIAA(IQCFINAL.REC_PIAA,IQCFINAL.REC_PIAA,.....,IQCFINAL.REC_PIAA) Allround...
I am using Oracle Sql Developer I have a huge script that creates tables, indexes, primary key constraints and such. my DB name is: dbo_other I logged into this dbo_other as sysdba. If I run my script then tables do not show up on left panel under 'Tables' However, if I append the script by adding 'dbo_other.' in front of every tab...
Suddenly all my keyboard shortcuts in the "Run" menu are disabled and I have no idea why. They were working yesterday, but not today. I can click on the toolbar menu options to run these commands (Run, Trace, etc), but they key bindings don't work. I tried this suggestion and even went so far as to re-install it. Still no luck. Anyone ha...
I recently upgraded to Oracle Sql Developer 2.1 It's far better, but the query results window automatically makes itself really big each time I run a query, covering most of my worksheet. Does anyone know a way to turn this off, so that it stays the same size when a query is run? ...
I am using Oracle SQL Developer, but I am having an issue seeing results from a package that returns a ref cursor. Below is the package definition: CREATE OR REPLACE package instance.lswkt_chgoff_recov as type rec_type is record ( source_cd lswk_tpr.gltrans.tpr_source_cd%TYPE, ...
I need to be able to run an Oracle query which goes to insert a number of rows, but it also checks to see if a primary key exists and if it does, then it skips that insert. Something like: INSERT ALL IF NOT EXISTS( SELECT 1 WHERE fo.primary_key='bar' ) ( INSERT INTO schema.myFoo fo ( primary_key, value1, va...
I have an Oracle script that looks like the following: variable L_kSite number; variable L_kPage number; exec SomeStoredProcedureThatReturnsASite( :L_kSite ); exec SomeStoredProcedureThatAddsAPageToTheSite( :L_kSite, :L_kPage ); update SiteToPageLinkingTable set HomePage = 1 where kSite = :L_kSite and kPage = :L_kPage; Supposedly th...
I need to export urf-8 data to a text file in form of insert statement. I've tried Oracle SQL developer's export data tool. But it use ansi encoding to export data to txt file so utf-8 characters turn to "?" mark. I wonder how whether it's possible to use utf-8 encoding to export data ? Thank you. ...
Hey Guys, I'm trying to create a connection inside Oracle SQL Developer to a SQLExpress database I have Everything I have resides on the same machine so there isn't any network issues I should have to deal with but everytime I follow the instructions and I try to connect I get the following message "Failure - Unable to get informatio...
Specifically, the three extensions below. I have added them to the list in Tools/Preferences/Database/User Defined Extensions but I can't figure out what types to set them to, and where they should appear in the GUI. http://htmldb.oracle.com/pls/otn/f?p=42626:54:1251612617416849%3A%3A%3A%3AP54_ID:661 http://htmldb.oracle.com/pls/o...
I am trying to debug a stored procedure using Oracle SQL Developer. The DB is on another box. I have granted privileges using GRANT debug any procedure, debug connect session TO <user>; I have placed the break point inside the procedure on one of the assignment lines. I have tried other places too out of desperation. When I click deb...
Dear all, I've upgraded to Oracle SQL Developer 2.1 and installed JTDS extension to work with SQL Server. But when I open the Data tab of a table, I cannot use filter features. I've check with an Oracle db, it works fine! Is there anyone get this trouble? Any suggestions are welcome! Thanks, ...
I have a select query producing a big output and I want to execute it in sqldeveloper, and get all the results into a file. Sql-developer does not allow a result bigger than 5000 lines, and I have 100 000 lines to fetch... I know i could use SQL+, but let's assume I want to do this in sqldeveloper. ...
In the free application SQL-Developer (provided by Oracle), I tried searching around for this but couldn't immediately find a solution. I find the opening of multiple SQL query result window/tabs mildly annoying. I'm sure there are very useful cases for this feature, but my question is: Can we turn the multiple query result windows to ju...
When I try to execute this statement in Oracle SQL Developer 2.1 a dialog box "Enter Substitution Variable" pops up asking for a replacement value for TOBAGO, update t set country = 'Trinidad and Tobago' where country = 'trinidad & tobago'; How can I avoid this without resorting to chr(38) or u'trinidad \0026 tobago' which both obscur...
I'm using Oracle SQL Developer. I'd like to key in dates with hours and minutes, but the GUI doesn't appear to allow that. While I'm at it, it would be nice to display all date fields as 'YYYY-MM-DD HH24:MI:SS' within the Oracle SQL Developer GUI as well. Thanks! ...
Hi, How to export oracle DB data with sql developer? I need all data, tables, constrains, structure and so on. Thanks ...
Hello! I have been tasked with comparing two oracle schema with a large number of tables to find the structural differences in the schema. Up until know I have used the DB Diff tool in Oracle SQL Developer, and it has worked very well. The issue is that now I need to compare tables in a user that I cannot log into , but I can see it thro...
When I execute a package body DDL statement SQL Developer warns, Warning: PLW-06015: parameter PLSQL_DEBUG is deprecated; use PLSQL_OPTIMIZE_LEVEL=1 How can SQL Developer be configured to not use PLSQL_DEBUG? PLSQL_DEBUG is set to false in an sql*plus session using the same connection details, > show parameters plsql NAME ...