Is this what you're looking for?
w_nseqline := lpad(to_char(w_seqline),6,'0');
Ch
"Eriovaldo do Carmo Andrietta" [EMAIL PROTECTED] on 02/27/2001 10:05:27 AM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc:
ts of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Chaim Katz/Completions/Bombardier)
Is there any way to read a CD created on a MAC machine from my NT Desktop?
Ron Smith
Database Administration
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron
List,
Recently there was a discussion concerning the cost of Oracle licenses vs MS Sql
Server licenses wasn't there? That discussion was not an issue at my job - until
today which is why I'm wondering if there were any postings that in any shape or
form justified some of the price differential
recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Chaim Katz/Completions/Bombardier)
Dear Guru's,
We have to have some of our users also be users on another system. The
folks who are running this system said we should add another
NAMES.DEFAULT_DOMAIN= NEW_DOMAIN
to our
On windows NT, we had tns-12500 because the Oracle executable was trying to
grow beyound 2gb...
Chaim
"Deshpande, Kirti" [EMAIL PROTECTED] on 04/15/2001 08:30:20 PM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc:
I had the same problem. Our maintenance license had expired :(
Chaim
"Miller, Jay" [EMAIL PROTECTED] on 04/19/2001 12:11:15 PM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Chaim Katz/Completions/Bombardier)
We
David,
I don't know sqlldr that well, but a possible quick and dirty solution -
is to load the text file into a one column oracle table, and then in a
subsequent step, use SQL to move the data to the proper columns of the
proper Oracle table. The ctl file from the first step would be something
but there is a create index ... desc?
ASC | DESC
specifies whether the index should be created in ascending or descending
order.
Oracle treats descending indexes as if they were function-based indexes.
You do not need the QUERY REWRITE or GLOBAL QUERY REWRITE privileges to
create them, as you
On Nt, you can define tns_admin by right clicking on my computer and
going to the properties.
You can also define the variable in a command window: set tns_admin=path.
Oracle will also use a tnsnames file if it exists in the current
directory (or in the start in directory used by the
Here's an even more kludgy guess. Maybe you can execute the alter
tablespace in the pl/sql job queue. If it runs too long (how long is too
long?), then you know that it's waiting (i.e., failing), and you could do
something appropriate action?
Fink, Dan [EMAIL PROTECTED]@fatcity.com on
Naba,
I think you need something like this
CREATE OR REPLACE TRIGGER triggername
AFTER INSERT OR UPDATE OR DELETE
ON tablename
FOR EACH ROW
WHEN (NVL(new.fldname1,old.fldname1)is not null and
NVL(new.fldname2,old.fldname2)is not null)
DECLARE
BEGIN
processing goes here
END;
hth,
Chaim
[EMAIL PROTECTED]@fatcity.com on 10/17/2002 03:13:26 AM
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
I guess, the problem you're having is that, ':new'||v_column is understood
as a string and not as
I think the problem is that you can't do an operation (like concatenate) on
a long field.
But another way to get the same output is to set colsep '|' , and then use
plain old select list
chaim
[EMAIL PROTECTED]@fatcity.com on 07/30/2002 09:23:20 AM
Please respond to [EMAIL PROTECTED]
Sent
Hannah
Maybe you could temporarily change the insert trigger to an update trigger
(create or replace trigger before insert or update on...)
and then simply update the table setting some column to itself. This will
will fire the trigger (and will not change any data in the table).
I didn't
OEM jobs will also work for you, if you're comfortable with Tcl.
I use OEM jobs
to run rman,
to run exports
to monitor alter logs
to schedule and run some sqlplus copy scripts
to schedule some data-loading and pl/sql routines
to run orakill if needed ...
I usually have
Bob,
We've had a symtoms like that (Oracle 7.3 and windows NT). In our case it
was related to the size of the Oracle executable on windows - it grows
dynamically based on the number of connections (and how much work the
connections are doing?) but it normally can't grow larger than 2Gb because
Michael,
Not that this has anything to do with your specific question...
but...looking at the SQL statement you posted, I don't think it needs the
table with the alias b. It already has the information from the inline
view. Also, the object's pctincrease isn't used in the calculation although
Raj,
Is this what you meant and what you would get?
SQL get 1
1 select m.id, cast(multiset(select fname
2 from t s
3 where s.id = m.id) as mystrtype) as fnamelst
4 from t1 m
5* group by id
SQL /
ID FNAMELST
--
Patrice,
I've just tried your idea out and it seems to work well. I tried on Oracle
9.0 but it should be the same on 816 or 817.
Here is the procedure that kills the sessions. It uses ora_login_user to
identify the calling username.
create or replace procedure endsession2 (sid_in in number)
John,
Maybe the buy_price_pkg.cnv_bpt_to_bp_id(5) function is returning a
string? From what you provided, it looks like its returning null or maybe
a blank character. Null shouldn't be a problem, but a blank string
Judging by the position of the * in the error message(?) ,it seems that
I once noticed this code which is executed (for each column?) when you
create a table. Would it be related to replication?
BEGIN
2. /* NOP UNLESS A TABLE OBJECT */
3. IF dictionary_obj_type = 'TABLE' THEN
4.
Jeff,
I don't know anything specific about that about performance of the tool
you're using, but in a general way, make sure that the application can use
bind variables for the INSERT statement (if possible), and also check if
the application can be built in a way that allows the SQL processing
Initcap?
What about:
abc garage
att
Mcneil and McNeil
Sivan Rabinovitz [EMAIL PROTECTED]@fatcity.com on 09/12/2002
03:33:18 AM
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Do you know initcap
Dan,
It's the chr(10).
SQL select ename||chr(10)||to_char(empno) title
2 from emp
3* where rownum 3
TITLE
---
SMITH
7369
ALLEN
7499
SQL set recsep off
SQL /
TITLE
---
SMITH
7369
ALLEN
7499
Try:
select osuser
fromv$session
where sid in (select sid
from v$mystat);
Chk
[EMAIL PROTECTED]@fatcity.com on 05/22/2002 01:14:52 PM
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:Multiple recipients of list ORACLE-L [EMAIL
Raj,
Would the temp have gotten the same result by counting the frequencies of
the letters in the game of scrabble?
Chaim
Jamadagni, Rajendra [EMAIL PROTECTED]@fatcity.com on
05/22/2002 11:53:22 AM
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:Multiple
Rahul,
This isn't exactly what you're asking but,
If OEM is set up:
You can use the intelligent agent on win2k.
Write a script that identifies the file and then calls the PL/SQL
procedure.
Schedule the job in OEM.
Chaim
Rahul [EMAIL PROTECTED]@fatcity.com on 05/27/2002 02:18:18 AM
Sean,
[4] If the problem is in the application, maybe you could trace it for a
bit, and see what the SQL looks like.
A select * from emp where rowid = '1' will give the ORA-01410 error.
A select using an Oracle7 type rowid against an Oracle8i database will also
give the error.
Hth,
Chai
With reference to the postings about quick learning and all that, I remembered a
story: There was a Talmudist - no job and no money. His wife confronted him. It
bothered her that she alone was worrying about their situation and he didn't
seem concerned at all. Not true, he says, I just worry
]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Chaim Katz/Completions/Bombardier)
Dear gurus !
I have a table of phone calls , 2 fields : CALL_START DATE , CALL_END
DATE .
I need an SQL statement or a PL/SQL block to calculate the maximum number of
SIMULTANIOUS phone
Lisa,
I use Tcl and OraTcl that comes with Oracle Enterprise Manager.
Chaim
Koivu, Lisa [EMAIL PROTECTED] on 08/19/2001 05:15:21 PM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Chaim Katz/Completions/Bombardier)
Bonjour
Barry
Make sure that your substitution variable is in single quotes '1' and then
pass the parameter in single quotes, (or in single quotes surrounded by
double quotes)
hth
chaim
Barry Deevey [EMAIL PROTECTED]@fatcity.com on 09/10/2001 11:15:25
AM
Please respond to [EMAIL PROTECTED]
Sent
Raj,
Maybe another option would be to audit session for the database. For
each logon/logoff you would see the logical/physical reads and the logical
writes ( in dba_audit_session) by Oracle username (or osusername).
Chaim
Aponte, Tony [EMAIL PROTECTED]@fatcity.com on 01/16/2002 06:15:24 PM
I tried a different way once - with the PL/SQL extensions to export
package. It isn't described in the docs, but there is a file (dbmsexp.sql)
in rdbms/admin directory. Basically for each table that needs special
treatment, you insert a row in sys.expact$ and identify the PL/SQL code you
want
11:16:00 PM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Chaim Katz/Completions/Bombardier)
Instead of trying to do this in SQL Loader, why not just
try to clean up the data?
This can be done at least 2 methods:
1. Get
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Chaim Katz/Completions/Bombardier)
On Friday 25 May 2001 01:05, Saurabh Sharma wrote:
i feel this is at the full database export level.
once u export ur database, u can import
PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Chaim Katz/Completions/Bombardier)
Hi all,
I am getting a PLS-320 the declaration of the type of this expression is
incomplete or malformed.
This is ORACLE V7, PL/SQL V2.1.4. I know I am missing something
If
novicedba [EMAIL PROTECTED] on 06/06/2001 09:30:36 AM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Chaim Katz/Completions/Bombardier)
Hi,
The readme file that comes with OEM has a compatibility matrix - OEM 2.1 has
ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Chaim Katz/Completions/Bombardier)
CREATE or replace TRIGGER record_destructive_ddl_trigger before drop or alter
or truncate ON DATABASE
Declare
pcolumn_name dba_tab_columns.column_name%type;
cursor get_column_name is
select column_name from
happened after that
Chk.
Mercadante, Thomas F [EMAIL PROTECTED] on 06/15/2001 02:49:14 PM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Chaim Katz/Completions/Bombardier)
I remember when I was in 10th grade, and we had
]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Chaim Katz/Completions/Bombardier)
David,
Is FA_IDNT a view that you didn't know about that the package uses?
Just a thought.
ROR mª¿ªm
[EMAIL PROTECTED] 06/18/01 03:16PM
Hope everybody had a good weekend -
Working on HP-UX
Here's something that worked in Oracle7.1 It will still work although it's
a bit long-winded and uses dbms_sql. (See attached file: chkcase.sql)
Chaim
Lyuda Hoska [EMAIL PROTECTED]@fatcity.com on 03/14/2002 02:03:32 PM
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
Raj,
Audit table will create an audit trail for DELETE as well as TRUNCATE (as
well as CREATE), even in 7.3 (I just tried) Maybe you were logged in as
SYS or maybe it's one of those things that you have to log out and back it
for it to be effective?
Chaim
[EMAIL PROTECTED]@fatcity.com on
that there aren't any of them around (unless
it was coming over a db link?)
Hope this is a bit of help to you.
Chaim
O'Neill, Sean [EMAIL PROTECTED] on 07/05/2001 11:55:55 AM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Chaim Katz
, Donna (SEA) [EMAIL PROTECTED] on 07/25/2001 07:25:19
PM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Chaim Katz/Completions/Bombardier)
Hi Guys,
I was hoping to use the new 8i triggers to prevent
new users from getting assigned
]
cc:(bcc: Chaim Katz/Completions/Bombardier)
Larry, et. al.,
I'm running 8.1.7.1.1 on Win 2K Pro SP2. I did the following:
alter session set cursor_sharing=force;
select 'x' from dual;
select 'X' from dual;
select ' x' from dual;
select ' X' from dual;
select 'x ' from dual;
select ' x
Rachel Carmichael [EMAIL PROTECTED] on 07/31/2001 11:48:02 AM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Chaim Katz/Completions/Bombardier)
Rachel,
I don't know how to retreive the locking sql either, but reading
Hillman, Alex [EMAIL PROTECTED] on 08/01/2001 02:16:31 PM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Chaim Katz/Completions/Bombardier)
All,
I just tried a log miner test (without the logminer dictionary). It wasn't
SQL*PLus
set colsep ,
spool x.csv
select
hth
chaim
Deepender Kr Gupta [EMAIL PROTECTED]@fatcity.com on 09/13/2001
09:20:25 AM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list
Arup,
How about select * instead of select count... Maybe the data is there but
something is wrong with sql*plus set up (numwidth) so that you don't see
the count.
( I know that sounds stranger than the original question, but from the
query you posted it looks like the count(*) is null which
In rdbms/admin there's a file called scott.sql, there's also a utlsampl.sql
in the same place.
[EMAIL PROTECTED]@fatcity.com on 01/21/2003 11:24:32 AM
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
I
from metalink note: 28018.1
5.14 Symmetric Replication
---
Bob,
I think the job is just missing the begin and end to make it a pl/sql
block.
dbms_job.submit
(:jobno, 'begin UPDATE TIME SET STATUS = ''O'' WHERE STATUS = ''I'' ;
end;',
trunc(sysdate+1),
'trunc(SYSDATE+1)',
TRUE, :instno);
(If there are no rows in TIME, the job will fail with an
You could probably fake this by renaming the table or playing with
synonyms, or by revoking privileges, but I don't know of a pl/sql command
or procedure that can prevent a user from performing SELECT against a
table. Even then, I don't think the SELECT statement will ever pause until
the lock
richard,
select name
from user_dependencies
where referenced_name = table_name
and type = view
chaim
Ferenc Mantfeld [EMAIL PROTECTED]fatcity.com on 02/21/2003
01:14:00 PM
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:Multiple recipients of list ORACLE-L
Sam,
SQL select *
2 from sys.filext$;
FILE# MAXEXTENDINC
-- -- --
9 256000 64000
17 256000 64000
The result must be oracle blocks
Chaim
[EMAIL PROTECTED]@fatcity.com on 02/21/2003 02:09:39 PM
Please respond to
How about
alter system set _system_trig_enabled =false
chaim
Thomas Day [EMAIL PROTECTED]@fatcity.com on 03/14/2003 12:04:33 PM
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Any way to do that?
Hi,
Is there a way to see whose function a user is executing?
Development and production schemas exist on the same database and both
accounts have granted object privileges to the user roles. (I think public
synonyms are being used). I'm wondering if there is a way to check that a
user is
Carol,
As long as the triggers aren't declared as autonomous transactions, they'll
see all the previous changes that the session made.
Are the two columns in the where condition maybe two date columns loaded
with different times?, or is one a varchar and the other a char so that the
comparison
Charu,
Allthough the trigger text is stored as a long, you can take the long
field, chop it at the linefeed characters and print it out (with line
numbers). The lines you get will match the line numbers in the error
message. Somewhere I have a pl/sql anonymous block that does that using
instr.
Check that you have the newest Oracle streams manual - the one on OTN
(released towards the end of last year). It's much better than the manual
that shipped with the version of Oracle 9 that we received.
There's also an OTN technical forum dedicated to streams.
chaim
Robson, Peter [EMAIL
Fermin,
The pl/sql manual has an appendix on char versus varchar2 semantics.
I guess SQL*Plus isn't as restrictive(?) and I gues the behaviour might
have changed since 7.3.
I wonder why baan uses char datatypes
chaim
Guido Konsolke [EMAIL PROTECTED]
@fatcity.com on 09/10/2003 10:14:24 AM
Raj,
I'm not speaking from experience, but why don't you start the trace the
same time you send the email. And maybe by limiting the size of the trace
file you don't have to worry about turning the trace off.
chaim
Jamadagni, Rajendra [EMAIL PROTECTED]@fatcity.com on
10/22/2003 03:44:34 PM
63 matches
Mail list logo