Is there a shortcut to get the Select Connection Dialog box in SQL Developer?
Every time I need to execute a Query I have to use the mouse to change the Connection, if there is any Shortcut then that would be easier for me to wotk with.
I have installed Oracle 11g R1 and have problem in connecting Oracle SQL Developer.
I have given user name: ora; pswd: ora.
In command prompt it works fine if I gave as below.
uid: ora as sysdba
pswd: ora
But when I am trying to connect to Oracle SQL Developer it says TNS listener does not know SID.
So I reinstalled this since i have doubt on myself whether I made mistake first time. Also I have doubt whether the un installation completely clears all the files from Registry. - What should I do to clear all the files from registry when un-installing.
1] What is SID. Is it session ID. If so how to find it.
2] Is there any way to confirm the values such HOST NAME: localhost, PORT: 1521, SID: (By default it has 'xe') which I gave for data base connection are correct.
I tried with SID value:135 (I got this value by executing [Select distinct sid from V$mystat;])
3] Is there any editor for practicing sql & pl sql queries. where I can download it.
I'd like to make a connection from Oracle SQL Developer to a MS SQL Server DB. How can I do that?
View 2 Replies View RelatedOracle Database: Oracle 11g Version: 11.1.0.6.0
Tool: Oracle SQL developer. Version : 1.1.3
Problem:
After completing debug of procedure from SQL Developer, whenever I try to compile that procedure or execute any query from the SQL worksheet, I get the closed connection error message. However I can debug that procedure for any number of times. Any other activity for that database connection gives closed connection error.
I have a problem with getting '|' sign in TOAD Editor. It is default for Croatian keyboard layout that I get '|' sign when I press Alt_gr+W key combination.
But in Toad, when I press Alt_gr+W combination Watches dialog is opened.I want to get '|' sign in Toad Editor when I press Alt_gr+W.
The way to create a short cut on desktop to have an sql*plus (command line).
i.e. I want to have an short cut on desktop when I click that short cut that would connect me to a specific database with a username and password (which i supply while creating the shortcut-I would provide the database name, username and password)
1> I installed "Microsoft Visual Studio Express 2012 for Web[32 Bit]" on Win-7[64 Bit] platform.
2> Then installed Oracle Database 11gR2 [64 Bit]
What else do i need to install, in order to Add a new database connection through Visual Studio 2012's Database Explorer.
I'm trying to connect to my DBs.I installed Oracle Client 10g, but PLSQL Dev. 7.1.4 doesn't find my tnsnames.ora.
View 4 Replies View RelatedI am using PL/SQL Developer.When i am trying to login with PL/SQL Developer i am getting the error
ORA-12514:TNS:listner does not currently know of service requested in connect descriptor
How to solve this one?
why are there in the Administration --> --> Session 2 entries for 1 database connection (here with benthic golden).But if I login in a browser, there is only 1 entry for this database connection
View 3 Replies View RelatedI am able to connect to the DB in TOAD , but I am not able to connect to the DB in PL/SQL developer.
PL/SQL developer
Version 8.0.1.1498
01.61091 - Unlimited user license
Windows 7 6.1 Build 7601 (Service Pack 1)
Oracle 11g
I am getting the below error
ORA-12154: TNS could not resolve the connect identifier specified
I am finding Oracle sql developer start up to be very slow.It takes more than 5 - 10 mins to startup.It seems for long startup.Its installed on Windows 7 machine in c: drive. Want to know what is causing it to be too slow.virus scanning, JVM startup.... ?
FYI
---------
Oracle Sql developer Version -- 3.2.20.09
Java(TM) Platform -- 1.6.0_43
How do i get tkprof trace file in sqldeveloper tool ? I donot have access sql in command mode.
View 5 Replies View Relatedwe have an issue on a server, where if we insert a value containing foreign characters from SQL+ we see it screwed up from SQLdev, whereas if we do the same insert from SQLdev it's then screwed up in SQL+.
All operations are performed on the DB server itself, SQLdev connection type is TNS and the entry being used is the same as the one used by SQL+.We checked v$nls_parameters and the values contained there are the same from both SQL+ and SQLdev.
sql developer tool which i am using to run query for every hour getting disconnected and to run a new query after an hour,i need to make a new connection again.Could you tell me an alternate way that should not disconnect the session in sql developer.
View 6 Replies View RelatedI'm using the below code in SQL Developer, trying to submit a request:
Declare
vRequest_id NUMBER;
BEGIN
Fnd_Global.apps_initialize(9205,20639,200);
[code]...
However, when i check the fnd_concurent_request table, nothing is there.as I just used the following code in SQL Developer and it worked:
Declare
L_NUMBER number;
BEGIN
L_NUMBER := WF_ROLE_HIERARCHY.AddRelationship('UMX|XXR|GLFSA_RADG_BA','FND_RESP|SQLAP|XXR_GL_JNL_ADMIN|STANDARD');
END;
Is it due to the different types of packages im using? i.e. public/private? or is there an api i can use in SQL Developer to submit the request?
I can do any sql commands against the schema I want (PSUSYS) with my username(SCHWAN) in the sql window, but when I want to export a table(created with a different schema) no tables are listed in the export window. This does work for my coworkers with the same access.
At one time this used to work so I'm wondering if it is a parameter that I inadvertently changed.
how i can add new connection to sql developer i had made a database name abb how i will connect that to sql developer.
View 12 Replies View RelatedIn plsql developer I could not find keyboard shortcuts. How to got to results after query is executed? Also need other key board shortcuts in plsql developer.
View 3 Replies View RelatedI am trying to get my stored procedures together again after many years of working on MS SQL server. I'm alternating between using SQL-Plus and Oracle SQL Developer for Mac. In SQL Developer - which I like to use - I keep getting errors at the point where the END command for the package header occurs and the create command for the package body starts.
I've found that if I run the following in SQL-Plus I'm OK but if I try it from SQL Developer I get a compile error such as following or else an error telling me that it expects function, or pragma or something to that effect:
Error(8,1):PLS-00103:Encountered the symbol "/"
The code is as follows:
--------------------------------------
CREATE OR REPLACE PACKAGE MACR_SAMPLE_PROC_4 AS
PROCEDURE sampleproc_4(
pParam1 in integer,
pParam2 out varchar2);
END MACR_SAMPLE_PROC_4;
[code].....
Due to company restrictions, i unable to use oracle third party tools such as toad, pl / sql developer etc except oracle sql developers. I heard Oracle Developer Tools for Visual Studio is best option to work oracle pl/sql and sql.
View 4 Replies View RelatedI have a question regarding SQL Developer. When opening a SQL Developer worksheet, there are two different panes or work areas; the upper pane contains the query code and the bottom pane contains the query results (output). Using the
Tools===Preferences tab, I was able to enable line numbering for the top pane (code) but I haven't figured out how to enable line numbering for the bottom pane (results area). how to enable line numbering for the bottom pane?
I am using dg4msql to connect to SQL server from Oracle(10.2.0.4, with AIX 5.3).
#from my laptop sqlplus (10.2.0.2)
SQL>select count(*) from table1@mssql; #works
SQL>select * from table1@mssql; #ERROR
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Driver]String data, right truncation
{01004}[Oracle][ODBC SQL Server Driver]String data, right truncation {01004}
#from my laptop, TOAD
Both queries works fine.
i have compared
"select * from nls_session_parameters;" values , TOAD and sqlpus gives same result.
find in the menu of Oracle SQL Developer how to display the result of explain plan for .. I have just "Succès de l'élément plan FOR".
View 3 Replies View RelatedI am getting bellow error message when trying to connect Sybase through Sql developer: status:failure-test failed:IO Error:The network adapter
View 1 Replies View RelatedHow to export and import table using Pl/Sql developer from one database to another.
View 9 Replies View RelatedI'm having a problem while exporting an DB to file. I have a certain table with a CLOB column which values are cut when I use the Export option on SQL Developer.
View 1 Replies View RelatedWhen I try to select euro symbol in a table it is showing as '¿' in pl/sql developer on windows 7 where as I am able to see in windows XP.
SQL> select '€' from dual;
'¿'
---
¿
suggest to get the euro symbol.
I have a table named invoice_info(INV_NUMBER number,BILL_TO_NAME char(55),SHIP_TO_NAME char(55)) which is having chines characters in the BILL_TO_NAME & SHIP_TO_NAME fields.
If i am displaying this tables data on my sql developer it's showing data like some junk chars like ?????????¨¬???? for the fields BILL_TO_NAME & SHIP_TO_NAME .
How can i display them as chines chars on sql developer.
I'm new to SQL Developer and am using the wizard to import a dataset with a non-standard row terminator.The row terminator is essentially 2 spaces back to back.
In SQL Server I specified the following in the SQL Server wizard and it worked:
{CR}{LF}{CR}{LF}
What's the equivalent for oracle?