Question : I am connecting to same db from 2 different machines using SQL Developer and querying a table which […]
Tag: oracle-sql-developer
SqlDeveloper: ora-12505 TNS listener does not currently know of SID given in connect descriptor
Question : Info connection name: ziv username:sys password: xxxxxxx connection type: basic role: sysdba host name : localhost.localdomain port: 1522 […]
Sometimes getting quotes in Oracle spool sometimes not
Question : Using Oracle SQL Developer, I do: spool c:tempfile1.csv select /*csv*/ id, version, key, pattern, name from mydatabase.edition; spool […]
how to connect SQL server from oracle in SQL developer
Question : I have two connections in SQL developer that one of them is SQL server (A) and the other […]
sql or hql query to find all parents of a particular record
Question : I need a sql or hql query to find all parents of a particular record, that should work […]
Multiset operators on nested tables with non scalar types
Question : I have a function, which performs multiset operation on two nested tables and returns result: function odejmijEgz(tab typ_NT) […]
ORA-01031 Insufficient Privileges Raised From Within Function
Question : When I run a CREATE USER statement within Sql Developer, the user is created just fine. When I […]
Oracle not available error with Oracle XE 11.2.0-1.0
Question : I have downloaded Oracle XE 11.2.0-1.0 and installed it on a CentOS 6.3 virtual machine with 1.5GB memory […]
Oracle sqldeveloper Database Diff – not seeing indexes/sequences
Question : I am using Oracle SQL Developer’s database diff tool to compare schemas. (SQL developer version : 3.2.09) It […]
How can I create a trigger that prevents column delete, data deletion and table truncate in the same time?
Question : Having written this trigger create: CREATE OR REPLACE TRIGGER PROTECT_DB BEFORE DROP OR TRUNCATE ON X.SCHEMA How can […]