hth
Ross
-Original Message-
From: Viraj Luthra [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 4 December 2001 16:11
To: Multiple recipients of list ORACLE-L
Subject: simple sql problem
Hello all,
Why cannot I do :-
sqlplus -s scott/tiger select * from emp;
or sqlplus -s scott
)
Subject: RE: simple sql problem
:[EMAIL PROTECTED]]
Sent: Tuesday, 4 December 2001 16:11
To: Multiple recipients of list ORACLE-L
Subject: simple sql problem
Hello all,
Why cannot I do :-
sqlplus -s scott/tiger select * from emp;
or sqlplus -s scott/tiger select * from emp;
Both the cases I get :-
Usage
Viraj - Your SQL isn't terminated. You need to end your SQL with either a
semicolon or a / on the next line.
Jared - Thanks for passing along this technique.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, December 04, 2001 12:35 AM
To: Multiple
From the unix command line you can run:
sqlplus -s scott/tiger EOF
select * from emp;
EOF
Viraj Luthra wrote:
Hello all,
Why cannot I do :-
sqlplus -s scott/tiger select * from emp;
or sqlplus -s scott/tiger select * from emp;
Both the cases I get :-
Usage: SQLPLUS [option]
As Scott said, in Unix you can use Input Redirection. If you are in
windows, you could always build the command as a .sql file and use the
sqlplus -s scott/tiger @myfile.sql
Command.
-Original Message-
Sent: Tuesday, December 04, 2001 10:01 AM
To: Multiple recipients of list ORACLE-L
After testing prompted by Jared's reply, you can use 1 of the 2 alternatives
from Windows.
That is, under windows the following works:
echo select * from dual; | sqlplus scott/tiger@abcd
I often use this type of syntax under NT to (say) log the time as below, but
had never thought to try it
Thanks to all who responded, Appreciate it.
The grok approach was not working so had to go with the following one.
Now just 1 more problem is that how I do I set the environment, say if I want to do
set head off, in the following command can I do that?
The following command I had to do :-
Hello all,
Why cannot I do :-
sqlplus -s scott/tiger select * from emp;
or sqlplus -s scott/tiger select * from emp;
Both the cases I get :-
Usage: SQLPLUS [option] [user[/password] [@host]]
[@startfile [parm1] [parm2] ...]
where option ::= { -s | -? }
: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group)
Subject: simple sql problem
: simple sql problem
Hello all,
Why cannot I do :-
sqlplus -s scott/tiger select * from emp;
or sqlplus -s scott/tiger select * from emp;
Both the cases I get :-
Usage: SQLPLUS [option] [user[/password] [@host]]
[@startfile [parm1] [parm2] ...]
where option
The way you're doing it sqlplus is trying to parse the SQL
as a command line argument, which will not work.
Try these:
1.
echo select * from dual; | sqlplus scott/tiger
2.
sqlplus scott/tiger EOF
select * from dual;
EOF
Jared
On Monday 03 December 2001 21:10, Viraj Luthra wrote:
Hello
Jared,
Using the 2nd option:-
sqlplus system/manager@orcl815 !
SELECT a.username, substr(sql_text,1,100), substr(sql_text,101,250),
substr(sql_text,601,250),substr(sql_text,851,250),
substr(sql_text,1101,250)
FROM sys.dba_users a, v$session, v$sqlarea
where parsing_user_id=user_id AND
of list ORACLE-L
[EMAIL PROTECTED]
cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group)
Subject: simple sql problem
Hello all,
Why cannot I do :-
sqlplus -s scott/tiger select * from emp;
or sqlplus -s scott/tiger
Title: RE: simple sql problem
Hi...
You cann't run sql statement in command line directly However you can in case of script file.
Make the query as a script file. Then run it on SQLPLUS.
-- c:\test.sql
-
select * from emp
/
exit
Hello all,
Sorry I was sick, therefore not able to answer.
I followed suggestions from Pulikkol, Swapna and Jon, and it works just fine now.
Thanks to all for getting me out of this one.
rgds,
raja
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
--
No, I mean, if (x+y) 1, that is a value of .92 which it prints out, but I want it
to print out like, 0.92, that is a 0. is concatenateed to the result.
therefore, when i have,
select x+y from blah
I should get 90 when the value is really 90
and I should get 0.92 when the value is really
Title: RE: simple sql problem
Hello Raja,
You can try this way
1)select x+y sum1 from blah
2)col sum1 format 09.99
3)select x+y sum1 from blah
rgds
swapna
-Original Message-
From: Viraj Luthra [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 12:31 PM
To: Multiple
Title: RE: simple sql problem
or,
set
numformat '0.99' (in sql*plus)
-Original Message-From: Swapna_Chinnagangannagari
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, July
31, 2001 12:26 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: simple sql problem
Hello
OR
SELECT LPAD(TO_CHAR(x+y),LENGTH(x+y)+1,'0') FROM BLAH
Raja:
Let me put my two cents into the idea bin. How about:
select decode(sign(num-1),-1,'0' || to_char(num), to_char(num)) as num
from t1;
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 31, 2001 1:10 AM
Hello all,
sql problem
Hello all,
If I have a situation, where I have the following:-
select x+y from blah
and if x+y 1, eg 5 then the output can be 5,
but if x+y 1, eg, .92, then I need the output as 0.92.
How do I do this?
rgds,
raja
Get 250 color business cards for FREE!
http
Title: RE: simple sql problem
but this will append 0 to numbers 1 (sum (a+b) 1)
which is not the requirement
-Original Message-
From: Pulikkol Kumar [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 4:10 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: simple sql problem
Hi
This will work out
SELECT DECODE(SIGN(x+y-1) , 1,LPAD(TO_CHAR(x+y),LENGTH(x+y),'0'),
LPAD(TO_CHAR(x+y),LENGTH(x+y)+1,'0')) FROM
blah
Hello all,
If I have a situation, where I have the following:-
select x+y from blah
and if x+y 1, eg 5 then the output can be 5,
but if x+y 1, eg, .92, then I need the output as 0.92.
How do I do this?
rgds,
raja
Get 250 color business cards for FREE!
Title: RE: simple sql problem
I believe what you meant is if it is less than one then the output should be 1.
if so:
select (case when x + y 1 then x + Y
else 1
end) from blah;
-Original Message-
From: Viraj Luthra [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 9:10
26 matches
Mail list logo
