Client Tools :: Line Numbering For SQL Developer

Aug 28, 2013

I 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?

View 3 Replies


ADVERTISEMENT

Client Tools :: How To Open PL/SQL Developer With SQL WINDOW From Command Line

Sep 11, 2013

I am trying to run PL/SQL Developer from command line, So it can open with an opened SQL WINDOW by default, with a script (which I specify in the command ) already in it:

I've tried:

"C:Program Files (x86)PLSQL Developerplsqldev.exe" userid=andrey/andrey@mydb

but it just opens the application with a connection, no file.

*CORRECTION* While I was writing this post, I tried something , which is not so sophisticated, and it appeared to work...

C:Program Files (x86)PLSQL Developerplsqldev.exe" userid=andrey/andrey@mydb "C:Program Files (x86)PLSQL Developerandrey.sql"

View 1 Replies View Related

Client Tools :: Command Line Tools

Jan 22, 2011

I usually work in oracle using the different editors like toad, plsql developer etc. I felt command line is good utility because of various supporting points. I am not sure what kind of command line tools is available/used. I am using pretty straight command line
(run->cmd, then enter username and password).

The best command line tools available. What is generally used command line tools.

View 1 Replies View Related

Client Tools :: Getting Each Record To Output On To One Line

Apr 16, 2010

Using SQL*Plus and having trouble getting each record to output on to one line. The fields I'm querying are:

TEMPLATEID NOT NULL NUMBER(10)
EXPERIMENTID NOT NULL NUMBER(10)
NAME VARCHAR2(200)
CREATEDATE DATE

Obviously, it's the NAME field causing me problems? Have tried using FORMAT, but no change in look of output.

COLUMN TEMPLATEID FORMAT 999999
COLUMN NAME FORMAT A40 WORD_WRAPPED
COLUMN EXPERIMENTID FORMAT 999999

View 7 Replies View Related

Client Tools :: How To Input Line To Sql Script

Aug 27, 2011

I want to put some line in my .sql file. The below is my issue :-

SQL>spool /tmp/Tablespace_Remove.ksh
SQL>echo >#!/bin/ksh---- I want to enter this line to my Tablespace_Remove.ksh
SQL>spool off;

View 3 Replies View Related

Client Tools :: How To Get Rid Of First EMPTY Line Of Spooled File

May 30, 2011

how to get rid of the first EMPTY line generated by SQL*Plus when spool'ing to a file.

I tried using set pagesize 0 and while that get rid of the empty blank line, it also disabled the heading ...

Currently using sed as a work around. But unfortunately, can't use sed on Windows?

set pagesize 200
set heading on
set trimspool on
set lines 200
set verify off
set echo off
set feedback off

[code].......

As mentioned, using pagesize 0 remove the blank line but I also lost the heading.

View 4 Replies View Related

Client Tools :: How To Remove Dotted Line While Spooling

Jan 27, 2010

i have a issue that when i spool the sql command i get a doted lines below the heading. how to eliminate the doted line but need the heading.

Previous:
OCCUPACODE OCCUPADESC
-------------------- -----------------------------------
1 BUSINESS
2 SERVICE

Needed :
OCCUPACODE OCCUPADESC

1 BUSINESS
2 SERVICE

View 1 Replies View Related

Client Tools :: PL/SQL Developer And Tnsnames.ora 10g?

Apr 3, 2008

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 Related

Client Tools :: PL/SQL Developer - ORA-12514 TNS?

Sep 30, 2012

I 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?

View 4 Replies View Related

Client Tools :: Changing DB Password Using SQLPlus Command Line

Jul 21, 2010

I'm trying to change a password. I can connect to the db then at the SQL prompt I'm using:

alter user <name> identified by <new password>

The dos window comes back with '2' - then just sits there

View 4 Replies View Related

Client Tools :: Running CodeXpert Through Command Line Using Toad 9.0

Oct 20, 2010

I need to run Toad codexpert using command line I am trying the following command

"C:Program Files... oad.exe" CX="C:... CmdLineTest.ini"

When I execte the command from command line .Codeexprt run and stop after some time and it make entry in the error log as "ora-00942 table or view does not exist".

View 1 Replies View Related

Client Tools :: Change Separator Line Of Compute SUM Or Count?

Jul 9, 2013

Is that possible to modify the ***** and ----- in the TEXT report?

DEPARTMENT_ID JOB_ID LAST_NAME SALARY
============= ========== ========================= ==========
20 MK_MAN Hartstein 13000
************* ********** ----------
sum 13000

From above lines, you can see ****** and ----- which are above sum&13000.

Is that possible to change them as '='?

DEPARTMENT_ID JOB_ID LAST_NAME SALARY
============= ========== ========================= ==========
20 MK_MAN Hartstein 13000
============= ========== ==========
sum 13000
"set underline =" is only shot the headers.

View 3 Replies View Related

Client Tools :: Getting Error While Connecting To DB In PL/SQL Developer

Dec 5, 2012

I 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

View 1 Replies View Related

Client Tools :: Sql Developer Startup Is Slow?

Apr 15, 2013

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

View 4 Replies View Related

Client Tools :: Generating Tkprof From SQL Developer

May 8, 2013

How do i get tkprof trace file in sqldeveloper tool ? I donot have access sql in command mode.

View 5 Replies View Related

Client Tools :: Characters Differences Between SQL+ And SQL Developer

Sep 20, 2013

we 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.

View 8 Replies View Related

Client Tools :: SQL Developer Not Working Constantly

Aug 31, 2013

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 Related

Client Tools :: Oracle SQL Developer Connection

Feb 1, 2011

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.

View 6 Replies View Related

Client Tools :: Submit Request Via SQL Developer?

Oct 3, 2012

I'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?

View 8 Replies View Related

Client Tools :: List Of Tables In PL/SQL Developer

Feb 4, 2010

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.

View 5 Replies View Related

Client Tools :: Connect From Oracle 9i To Sql Developer?

Aug 30, 2011

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 Related

Client Tools :: Keyboard Shortcuts In PL/SQL Developer

Apr 29, 2010

In 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 Related

Client Tools :: Creating Procedure Using SQL Developer?

Jan 23, 2012

I 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].....

View 9 Replies View Related

Client Tools :: Unable To Use Toad And PL/SQL Developer

Jun 17, 2010

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 Related

Client Tools :: Create Shortcut On Desktop To Have SQLPLUS (command Line)

Sep 6, 2010

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)

View 7 Replies View Related

Client Tools :: Different Charactersets Show Line-break In Select Result

Mar 22, 2010

i have a little curiosity in result of a select statement.

One database has following characterset settings:

NLS_CHARACTERSET WE8ISO8859P15
NLS_NCHAR_CHARACTERSET AL16UTF16

and the following select statement results in multiple lines:

SQL> select INSTANCE_NAME,STATUS from v$instance;
INSTANCE_NAME
------------------------------------------------
STATUS
------------------------------------
BUP
OPEN

Another database has following characterset settings:

NLS_CHARACTERSET UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16

and the same select shows only a 2 line result:

SQL> select INSTANCE_NAME,STATUS from v$instance;
INSTANCE_NAME STATUS
---------------- ------------------------------------
HPSMP OPEN

Both databases are version 10.2.0.4 and both are running on HPUX 11.31.Why do we get this differents in showing the result?

Our problem is that the package-start scripts from HP, to start a database, check the result of the select statement above and if we have the multiline result the check gives an error and stops the package again.

View 3 Replies View Related

Client Tools :: Display Windows On Oracle SQL Developer?

Sep 10, 2013

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 Related

Client Tools :: Error When Trying To Connect Sybase Through SQL Developer

Nov 17, 2012

I 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 Related

Client Tools :: How To Export / Import A Table Using PL/SQL Developer

Aug 28, 2010

How to export and import table using Pl/Sql developer from one database to another.

View 9 Replies View Related

Client Tools :: SQL Developer Cuts CLOB Contents?

Aug 23, 2011

I'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 Related







Copyrights 2005-15 www.BigResource.com, All rights reserved