Hi All,
This question pops up once in a while. I did not pay much attention to
replies before (not much of an NT person), but I think I will now, since I
am also running into similar situation and it's always good to learn a few
new things.
If anyone has a step-by-step procedure to do this
Yes, but how does one do that? I was really hoping someone would post an answer since
there were other people wanting to be able to the same or something very similar.
Failing to get a response. I wrote my own; actually, I took some code provided by
Steve Adams for a different purpose and
You could try something like
select item,
sum(decode(sign(transaction_date - trunc(sysdate,'Month'),-1,0,
0,nvl(value,0),
1,nvl(value,0)) mtd,
sum(decode(sign(transaction_date - trunc(sysdate,'Year'),-1,0,
0,nvl(value,0),
Title: Current Osuser
select
sys_context('USERENV', 'OS_USER') FROM DUAL;
Ian MacGregor
Stanford Linear Accelerator
Center
[EMAIL PROTECTED]
-Original Message-From: Behar, Rivaldi
[mailto:[EMAIL PROTECTED]]Sent: Monday, June 11,
2001 2:26 PMTo: Multiple recipients of list
Helen,
try this instead,, It should help
select substr(mystring,1,(instr(mystring,'%') -1))
from mytable
eg below
DEVcreate mytable (mystring varchar2(10));
Table created
DEVinsert into mytable values ('abcdefgh%jkl');
1 row created
DEVinsert into mytable values ('a%cdefghjkl');
1 row created
Not exactly sure what you're after
but possibly the below if you're simply looking to stop before the first
occurence of '%'
select substr('CS-%-ABC-%-%', 1, instr('CS-%-ABC-%-%','%') - 1) from dual;
-Original Message-
Sent: 12 June 2001 00:07
To: Multiple recipients of list ORACLE-L
Keep in mind though, I have two versions of oracle running and just want to
remove the older version.
I think there are issues with the registry. I'll be trying it tonight.
Ken
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 11, 2001
By
using the instr function.Here is an example. N.B.,
the space between the words "and" and "seven" is
returned.
select substr('Four score and seven years
ago',1, instr('Four score and seven years ago', 'seven')
-1) from dual
SUBSTR('FOURSCO---Four score and
Ian
Title: Current Osuser
Hi,
Can we use the following commands inside the pl/sql procedure.(due to
application requirement)
set feedback off
set fedback on
If yes at what point in procedure.
Thanks
Harvinder
Thanks a lot, that works.
"MacGregor, Ian A." [EMAIL PROTECTED] wrote:
By using the instr function.Here is an example. N.B., the space between the words "and" and "seven" is returned.
select substr('Four score and seven years ago',1, instr('Four score and seven years ago', 'seven') -1)
In fact, I use these fully qualified views all the time. A couple of notes:
- V$ views are, in fact, synonyms for the V_$ views.
- V_$ views are indeed views on the GV$ views which, as has been previous
been stated, are views on the X$ tables.
- There is no real performance gain to using the
Greetings All,
I am using Oracle 81630 on Solaris 7 and I have a table which contains
a
LOB (CLOB actually). The DDL statement is as follows ...
CREATE TABLE B_STATEMENT_TEXT_ORA (stmtnum NUMBER(10) NOT NULL,
statement_content CLOB)
STORAGE (INITIAL 100M NEXT 100M PCTINCREASE 0)
TABLESPACE
uh - Stripe And Mirror Everything.
what's a tablespace?
add more NVRAM (cache).
he he he he ... its going to be another late one ...
sales critter.
-Original Message-
Sent: Monday, June 11, 2001 9:51 PM
To: Multiple recipients of list ORACLE-L
Greetings All,
I am using Oracle
Kevin's point is probably, that if each index has a depth (blevel) of
three, then each index will add three LIO's to any DELETE or INSERT
statement. For UPDATE statements, only the indexes on the updated columns
count. LIO's mean cpu usage and latch pressure, which is why we want to
mininize them
Alex,
I think most everyone knew it was a joke.
Not everyone will get your jokes.
Not everyone gets my jokes.
I wouldn't have it any other way. ;)
Jared
On Monday 11 June 2001 13:36, Hillman, Alex wrote:
I hoped that everybody understand that this was a joke. I use damagement
and :-)
harvinder..these are sql*plus commands...and will not work inside a pl/sql
block...
--
From: Harvinder Singh[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Tuesday, June 12, 2001 6:50 AM
To: Multiple recipients of list ORACLE-L
Subject: set
Anshuman,
whenever u add a constraint to a table, oracle will make sure all the data
(if any)
confirms to the constraint added
you can enable or disable a constraint (even defer)... dont confuse urself
with the term enforcing a constraint.
Regards
Rahul
--
From:
Hi friend,
i didn't succeed it with the format X'9' for the datafile delemited by
'tab'.
Could u help me in this.
the followin is the control file of mine:
load data
infile *
into table abba1
fields terminated by X'9'
(a,b)
begindata
2384'vnb'
398489 'dke'
create table abba1(a number, b
Hi List
The following is config on my initsid.ora on NT4 /Oracle 816, DB size 25GB.
shared_pool_size = 52428800 # INITIAL
large_pool_size = 614400
java_pool_size = 20971520
Now my Question is Can I reduce java_pool_size to 0 as I am not using any
Java module. I am using BLOB in my db also I
can a version earlier than 8.1.7 be used as the database server in the
3-tier-architecture.
i have 8.1.5 on NT 4.0 service pack 5.
saurabh
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 11, 2001 9:11 PM
Got it working at home on
if u r a member of oracle.com web account(u can simply register at the site)
u can download a free version of iSQL * Plus from
www.oracle.com/download
select from tools section and just fill the acceptance form. its in zip
format.
- Original Message -
To: Multiple recipients of list
Title: RE: Changing Java pool size to 0
Hi Ramesh
The java_pool_size is use want you work with the JServer. Do you have a Java stored proc, EJB or CORBA in your DB ? If not, you don't need the java_pool_size.
You could set it to 0. The default is 1m.
Luc
-Message d'origine-
101 - 122 of 122 matches
Mail list logo