Client Tools :: Repeat Last Series Commands In SQL PLUS

Aug 8, 2007

In SQL plus
<SQL>

i need to repeat last six or seven commands instead of typeing

is there any command to using arrow keys o backward and forward last typing comamnds

i know / to execute last command

how to do that in SQL plus.

View 5 Replies


ADVERTISEMENT

Client Tools :: Spool Without SQL Statement And Commands In PLSQL?

Jan 3, 2011

I have a PLSQL script.

sqlplus
$DB_ACCT << EOSQL
set heading off
set termout off
set pagesize 0

[code]....

My output in FILE.txt looks like this
SQL>
SQL> Select col_with_a||col_with_b||col_with_c from
2 alphabet_table;
abc

[code]....

I tried several options by putting set echo off, etc.What do I include in the sql script to get the output as :
abc
abc
abc

without the SQL prompt and the statement, and the spool off command?

View 2 Replies View Related

Application Express :: Separate Link For Each Series On Multiple Series Bar Chart From One Query

May 13, 2013

I have a query that selects multiple series for a bar chart (I have defined only one chart series, and have 3 columns selected to represent 3 series). The series display on Bar Chart is fine. Now I want to create a separate link target depending on which series is clicked on the chart. I am not able to do this.

View 1 Replies View Related

Windows :: Client Logging - See What Commands Are Being Sent By Process?

Nov 4, 2011

I am trying to trouleshoot an issue with Oracle and want to see what commands are being sent by by process. By reading the documentation it appears there is client logging to do this but I can not get it to work. I added the following commands to my SQLNET.ORA file but no log file is created:

tnsping.trace_directory = C:appproduct11.2.0client_4
etwork race
tnsping.trace_level = admin
trace_level_client = user
trace_directory_client = C:log
log_directory_client = C:log
trace_unique_client = on
trace_timestamp_client = on

Ths TNSPING works just fine it logs the information I expect. The client logging, however, never creates a file .

View 2 Replies View Related

Client Tools :: Tools For Load Testing On Oracle - J2EE Application?

Jan 5, 2012

which are recommended Tool for load testing (for performance) on Oracle-J2EE, 3 Tier applications?

Is 'Oracle Application Test Suite' the best for such test where we can simulate numbers of users and their various actions?

Does it come with Oracle Database license or we have to buy it separately?

View 1 Replies View Related

Client Tools :: Basic Tools For Oracle Version Control

Aug 26, 2011

I'm looking for 3 simple things.

1) A reverse engineering tool that I can point to an Oracle schema and get a "baseline" script to re-create that schema from scratch, with decently formatted DDL files (1 per object) neatly organized in a directory tree (by object type) and called in the correct order. Icing on the cake would be an option to pass the tool a list of tables containing static data and get DMLs to populate (insert) those tables as part of the script.

2) a diff tool that I can point to a pair of Oracle instances (source and target) containing a given schema and get a "delta" script to alter the target schema so that it becomes identical to the source schema. If data loss occurs on the target instance (i.e. drop a column) I would like to find a warning comment inserted in the script (e.g. "-- Attention: data migration DML needed here?"). Icing on the cake would be an option to pass the tool a list of tables containing static data and get DMLs to update (delete, update and insert) the data in the target tables to become identical to the contents in the source tables *without* deleting and re-inserting all rows (or dropping, recreating and repopulating the table).

3) I would like the above two tools (that, as you will have recognized, are basic to putting your database design under version control) to be open-source, with a command-line interface and a vibrant community backing them.

View 9 Replies View Related

Client Tools :: Cannot Connect Using JDBC Oracle Thin Client With (New Method)?

Feb 21, 2013

The problem is that this connection errors when I try to connect using my SQuirreL client. My developers want to connecting using the SID or the SERVICE_NAME and by using the "New Method" syntax, not the "Old Method" syntax. According to the documentation the "New Method" syntax works with the SERVICE_NAME or the SID. The "Old Method" only works with the SID.

# Host name is vmwwin7634.na.SAS.com
# SID is sting2
# SERVICE_NAME is sting2.na.sas.com

PROBLEM using SID errors ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2
THIS WORKS using SERVICE_NAME ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com

I am using SQuirreL Client version 3.4.0

# Here is the tnsnames.ora entry on the server.
STING2 =
(DESCRIPTION =

[code]...

# In this documentation it says, "On new syntax SERVICE may be a oracle service name or a SID."You can find this on the orafax wiki under JDBC#Thin_driver.

# I was able to connect with the "old method" using the SID only, SERVICE_NAME errors jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2.na.sas.com
(SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.")
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2 (this works)

# "New Method"
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com (this works)
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2 (this errors)
(SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.")

View 10 Replies View Related

Client Tools :: Can Use Oracle Client Version To Create A Database In That Server

Jan 13, 2011

can we use oracle client version to create a database in that server.

View 3 Replies View Related

Client Tools :: How To Connect From Client To Oracle Database In Unix

Dec 11, 2012

I have new virtual UNIX machine and I installed oracle client on /usr/lib/oracle. Also I have a oracle database and I am able to connect to this database from my desktop sql developer.

So now I am trying to connect from new UNIX machine. Where I created tnsnames.ora file under /usr/lib/oracle/network/admin and before connecting did export the following

export TNS_ADMIN=/usr/lib/oracle/network/admin
export ORACLE_HOME=/usr/lib/oracle/
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$HOME/bin:/sbin:$ORACLE_HOME/bin
export ORACLE_SID=VFIODSD1

when I try

# sqlplus
username :xxxxxxx
password : xxxxxxx

ORA-12545: Connect failed because target host or object does not exist. Not sure what I missed here. using same tns file I am able to connect from sql developer on windows.

View 1 Replies View Related

Client Tools :: Oracle Client 32 Bit On Windows Server 2008 R2 64 Bit

Jul 20, 2012

Can i install Oracle 10g Client 32 bit on our Windows Server 2008 R2 64 bit?

View 1 Replies View Related

Client Tools :: Install Oracle To Get Latest SQL Plus Working On Client PC

Jul 11, 2012

I need to install Oracle client to get latest sql plus working on client pc as the problem is, i am not able to find out where i can download this , i just need the sql plus as i am not able use many commands because when i installed oracle forms 6i client tool , sql plus 8.0 got installed.

View 4 Replies View Related

Client Tools :: BR*Tools Appearance Not Complete

Jan 16, 2013

I want to use BR*Tools to administer an Oracle database. I have installed BrGUI local, set the JAVA Home variable and edited the brgui.properties file accordingly.I am able to login, but the menues are mising. The login screen is incomplete.

View 5 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 :: ODBC Instant Client Oracle 10g

Jun 28, 2010

The version is Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi. for Unix AIX 5

I install the ODBC Driver Manager, Basic Instant Client, ODBC Instant Client packages (libsqora.so, odbc_update_ini.sh).

The error:

[oracle@d4 oracle] $ isql OracleODBC-10g user passtemp -v
[01000][unixODBC][Driver Manager]Can't open lib '/home/oracle/instantclient_10_2/libsqora.so' : file not found
[ISQL]ERROR: Could not SQLConnect

Configuration

odbcinst.ini
[Oracle10gODBCdriver]
Description = Oracle ODBC driver for Oracle 10g
Driver = /u01/app/oracle/product/10.2.0/db_1/lib/libsqora.so
Setup =
FileUsage =
CPTimeout =
CPReuse =

The documentation explic with exists the file libsqora.so.10.1 but not exists in the ODBC Instant Client packages.

I applied ln -s libsqora.so.10.1 libsqora.so but the connection not function

odbc.ini
[oradns]
Application Attributes=T
Attributes=W
BatchAutocommitMode=IfAllSuccessful
CloseCursor=T
[code].......

View 1 Replies View Related

Client Tools :: How To Connect To Oracle 7 Using Client

Dec 15, 2011

I have Oracle 7 database on Server1. I need to connect this using Oracle client from windows XP.

I have downloaded Oracle client 3.0 and when I am trying to connect it saying "Unable to connect: Unsupported Oracle version".

View 8 Replies View Related

Client Tools :: Identify Oracle Client

Oct 3, 2011

I would like to know if there is some specific file who identifies the installation of Oracle Client in some machine.

View 4 Replies View Related

Client Tools :: How Can Isqlplus Available For Windows Client

Sep 23, 2010

I have an Oracle server on CentOS 5.4, I can visit isqlplus on server, but I can't visit isqlplus on a windows client. ping works between server and client. I remember client doesn't need to install software via isqlplus, but I am not pretty sure.

View 2 Replies View Related

Forms :: Lov Should Not Repeat The Value?

Nov 30, 2011

I am using lov for one item on my form the form is in tabular format

when i select the value in lov for the item in first row it should not be present agin in that lov for the next item

thus i want to prevent the duplication on Lov level

View 1 Replies View Related

PL/SQL :: Repeat Values From Min To Max Value?

Mar 5, 2013

CREATE TABLE TEST
(
 NAME  VARCHAR2(100),
STR   NUMBER,
ED    NUMBER
)
Insert into TEST (NAME, STR, ED)
Values ('raj', 2, 4);
Insert into TEST (NAME, STR, ED)
Values ('kri', 1, 3);

COMMIT;i want output like below

raj 2
raj 3
raj 4
kri 1
kri 2
kri 3

View 11 Replies View Related

SQL & PL/SQL :: Repeat Interval For DBMS_SCHEDULER?

Oct 13, 2011

I have created a job using DBMS_SCHEDULER and I want it to run every 30 seconds:

begin
dbms_scheduler.create_job(job_name => 'jobu',
job_type => 'PLSQL_BLOCK',

[Code]....

My question is how can I take the value 30 from a configuration table? Let's say I have a query like select value from config_table where property = 'job_interval' that returns the number 30. How can I set this value to be the repeat interval for my job?

View 9 Replies View Related

Forms :: LOV Should Not Repeat Values

Dec 29, 2010

I need my Forms 10g List of Values(LOV) not to repeat values.

Test Case : MY Lov record Group Query is : select student_name from students;

Students Table contains Id:1 student_name : Deepak ;
Id:2 student_name : Rajeev ; Id:3 student_name : Rohit

now on selecting the LOV thru forms i select "Deepak". On creating one more record i want that LOv should show only two records Rajeev and Rohit and thereon with more records creation.

It should function all this without committing the records to database.

View 1 Replies View Related

SQL & PL/SQL :: Repeat Rows Based On Column Value

May 19, 2010

I have a select statement

select name, address, qty
from names_table

and it returns a result such as

name|address|qty
alan,1 the street,5
bert,2 the road,3

what I want to do is create an output that takes the value in the qty column and repeates the number of rows e.g. the alan record 5 times and the bert record 3 times

name|address|qty
alan,1 the street,5
alan,1 the street,5
alan,1 the street,5

[code]...

how I might go about acheiving this?

View 14 Replies View Related

SQL & PL/SQL :: Print Fibonacci Series

Nov 8, 2006

I want to print Fibonacci Series like :-

0,1,1,2,3,5,8,13,21,34..........

How can i do it.Can i do it by procedure or function?

View 4 Replies View Related

Forms :: Repeat Same Values To Next Record From Previous?

Jun 16, 2011

How do you repeat the same values to the next record from the previous record to reduce the user entry in d2k ??

View 1 Replies View Related

SQL & PL/SQL :: How To Find Next Closest Number In Series

Jan 21, 2012

i have a data something like

010030
110495
210960
311425

[code]...

and user enters the figure like 13025now i would like to find the closest next value to the number entered by user, which is 713285 .how can i get this result, i have search a lot on Internet and i found some analytic functions can work out. but don't know how ..

View 14 Replies View Related

Client Tools :: How To Add Value From Sqlplus

May 14, 2013

I want to add a value from sqlplus.

My scenario is like that i want to add the following value

select count(*) x from tab1

i need to connect several database, and each time i need to add with previous one. like that

connect a/a@db1;
select count(*) x from tab1;

then when i connect another db

connect b/b@db2;
select count(*) x from tab1;

x will add with previous one.

View 6 Replies View Related

Client Tools :: How To Connect To Sql Plus

Nov 18, 2010

I have to connect to sql*plus to get explain plan.When I conect in Toad, the credentials are as:-
User/schema :- TestDb
Password :- TestDb

Under direct tab:-
Host :- 172.17.252.96 Port :- 1521

Service Name :- xe

I am not able to connect to sql*plus using:-

Username :- TestDb
Password :- TestDb
Host String :- 172.17.252.96

Not sure how to login when I have IP address

I also tried login as:-

Username :- TestDb
Password :- TestDb
Host String :- xe

View 5 Replies View Related

Client Tools :: How To Use Isql*plus

Jan 30, 2010

I want to work on isql*plus but i don't know how?!!?. whether i have to install it anywhere or what is the procedure to use it.?

View 2 Replies View Related

Client Tools :: Unable To Run SQL *Plus?

Oct 5, 2012

I'm not able to run SQL *Plus on my machine. It is giving me below error.

Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

Setting of PATH environment variable is as below. If I remove below highlighted part I'm able to run SQL * Plus. I cannot remove this because it is required to run my application.

C:oracleproduct10.2.0client_1in;C:OSIBANKDLLBIN;C:OSIBANKBat_Exe;C:OSIBANKDLL;c:Program Files (x86)InteliCLS Client;c:Program FilesInteliCLS Client;C:Program Files (x86)AMD APPinx86_64;C:Program Files (x86)AMD APPinx86;%SystemRoot%system32;%SystemRoot%;%SystemRoot%System32Wbem;%SYSTEMROOT%System32WindowsPowerShellv1.0;c:Program Files (x86)Microsoft SQL Server90Toolsinn;%TFSPowerToolDir%;%BPADir%;C:Program FilesIntelIntel(R) Management Engine ComponentsDAL;C:Program FilesIntelIntel(R) Management Engine ComponentsIPT;C:Program Files (x86)IntelIntel(R) Management Engine ComponentsDAL;C:Program Files (x86)IntelIntel(R) Management Engine ComponentsIPT;C:Program Files (x86)IntelOpenCL SDK2.0inx86;C:Program Files (x86)IntelOpenCL SDK2.0inx64

View 5 Replies View Related

Client Tools :: New TOAD After Old One

Sep 26, 2011

I was downloaded new version of TOAD for Oracle version 10.6 and I try to connect to my current database (oracle xe) and TOAD raise an error ORA-12154 Could not connect to XE..., but with old version of TOAD 9.6 all works fine. What can be an solutions?

View 6 Replies View Related







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