:
Sent by:Subject: RE: Pl/sql question
[EMAIL PROTECTED]
2002.01.28 11:20
Please respond to
ORACLE-L
Hi Roland,
Best way to do this is just set some variables at the start
/
Thomas, Kevin
Kevin.Thomas@cal To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
anais.com cc:
Sent by:Subject: RE: Pl/sql question
[EMAIL PROTECTED
http://www.itsystems.lv/gints/
Thomas, Kevin
Kevin.Thomas@cal To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
anais.com cc:
Sent by:Subject: RE: Pl/sql question
Hi i am trying to insert records into a table by selectiog from table 2, i
want to insert a sequence,, and the distinct values from table 1 but i get
an error:
Query used:
INSERT INTO contacts (cont_id,cont_contact_surname)
(SELECT seq_cont.nextval,distinct delegated_person
FROM sierras
Try this
distinct(delegated_person)
Chuck Speaks
Database Administrator
Lithonia Lighting
770-860-3450
http://www.lithonia.com
-Original Message-
Sent: Friday, January 18, 2002 12:51
To: Multiple recipients of list ORACLE-L
Hi i am trying to insert records into a table by selectiog
Try this:
INSERT INTO contacts (cont_id,cont_contact_surname)
(SELECT seq_cont.nextval, delegated_person from
(select distinct delegated_person
FROM sierras
WHERE delegated_person is not null));
-Original Message-
Sent: Friday, January 18, 2002 12:51 PM
To: Multiple
PROTECTED]]
Sent: Friday, January 18, 2002 11:51 AM
To: Multiple recipients of list ORACLE-L
Subject: SQL question
Hi i am trying to insert records into a table by selectiog from table 2, i
want to insert a sequence,, and the distinct values from table 1 but i get
an error:
Query
[EMAIL PROTECTED] wrote:
Hi i am trying to insert records into a table by selectiog from table 2, i
want to insert a sequence,, and the distinct values from table 1 but i get
an error:
Query used:
INSERT INTO contacts (cont_id,cont_contact_surname)
(SELECT seq_cont.nextval,distinct
Thankyou everyone for the quick and very useful responses...
-Original Message-
Sent: 21 November 2001 16:04
To: Multiple recipients of list ORACLE-L
Hi,
Can you tell me if its possible to write some sql to change some data.
Basically I need to run a scritp to change data of column:
Title: RE: SQL question
update table_name set id = substr(id,-4);
eg:
[EMAIL PROTECTED] select substr('48900322',-4) from dual;
SUBS
0322
1 row selected.
Nirmal.
-Original Message-
From: Malik, Fawzia [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, November 21, 2001 7:04 PM
Fawzia
How about:
update table
set column_name=substr(column_name,-4,4)
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, November 21, 2001 11:04 AM
To: Multiple recipients of list ORACLE-L
Hi,
Can you tell me if its possible to write some
Or if id is number
update table
set column_name=TO_NUMBER(substr(TO_CHAR(column_name),-4,4))
JP
On Wed 21. November 2001 17:45, you wrote:
Fawzia
How about:
update table
set column_name=substr(column_name,-4,4)
Tom Mercadante
Oracle Certified Professional
-Original
Fawzia,
You should be able to use mod(field,1) to get the remainder of the
number divided by 1, which should be the last four digits.
Cheers
Iain Nicoll
-Original Message-
Sent: Wednesday, November 21, 2001 4:04 PM
To: Multiple recipients of list ORACLE-L
Hi,
Can you tell
Malik, Fawzia wrote:
Hi,
Can you tell me if its possible to write some sql to change some data.
Basically I need to run a scritp to change data of column: id from 12345678
to the last four digits. Is this possible to do in sql/plsql??
Any advice/hints would be greatly appreciated
Hi,
Can you tell me if its possible to write some sql to change some data.
Basically I need to run a scritp to change data of column: id from 12345678
to the last four digits. Is this possible to do in sql/plsql??
Any advice/hints would be greatly appreciated
Rgds
Fawzia
:
tes.com Subject: PL/SQL question
Sent
create table AAA (NAME varchar2(30));
insert into AAA values ('Pelle T');
insert into AAA values ('Kalle S1000');
insert into AAA values ('Info missing');
insert into AAA values ('Pelle Svensson T3');
insert into AAA values ('Bad info');
select decode(name, 'Info missing',NAME,'Bad
For the final time Roland.
SQL select * from mytable;
FIELD1
Pelle T
No Info
Pelle Svensson T
Missing Info
Kalle S1000
SQL get lee.sql
1 SELECT field1, DECODE(field1,'No Info','No Info','Missing
Info','Missing Info',ltrim(substr(field1,1,instr(field1,' ')-1)))
Can you tell us what the last word in the field value mean (except 'Info
missing' and 'Bad info')
I mean is there a rule that those T, S1 does respect?
Something like this:
- first character is a letter and in this set of values ('S', 'T' etc)
- the rest are digits
etc.
Try to find out a
Thanks for all your repliesReally appreciate this..
next time I willtake more time to check the errors myself
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
select field1, decode(field1, 'Info missing', 'Info missing', 'Bad info',
'Bad info', substr(field1, 1, instr(translate(field1, '0123456789',
'@@'), '@')-3))
from your_table
HTH
Iulian
-Original Message-
Sent: Thursday, November 15, 2001 8:56 AM
To: Multiple recipients
Title: PL/SQL question
Can anyone can tell me how to use PL/SQL declared variables in a select statement where a . has to be between the owner and table name, and the owner and table name are variables, I'd be most appreciative. The answer is probably obvious... Feel free to point it out
Title: PL/SQL question
Hi
Linda,
You
cannot put a variable instead of an object name (where by object here I
meanowner, table_name, column_name). You have few options:
-
generate a sql hat you would run, e.g. do select 'select
max('||v_column_name||') from ' ||
v_owner
Title: PL/SQL question
Thanks very much!Myuse of EXECUTE IMMEDIATE is passing
the parser.
Linda
-Original Message-From: Djordje Jankovic
[mailto:[EMAIL PROTECTED]]Sent: Thursday, November 15,
2001 2:03 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: PL/SQL
Hej
Would like to have som help with this. Please give me an example of sql statement.
I have field1.
Pelle T
Kalle S1000
Info missing
Pelle Svensson T3
Bad info
and want this result after the selectstatement.
Pelle
Kalle
Info missing
Pelle Svensson
Bad info
which means that I dont
Can I somehow use a variable for the table name in a cursor select?
Here is the example:
--Declaration Section
sSrcTableName VARCHAR2(50) := iFeedNm||'_1_1_'
||TO_CHAR(SYSDATE,'YYMMDD')||'_SRC';
--cursor for tmo daily source records
CURSOR cTMODaily IS
SELECT*
Use DBMS_SQL or EXECUTE IMMEDIATE
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
Fuelspot
73 Princeton Street
North,
:
[EMAIL PROTECTED] Subject: pl/sql question
om
Spence To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cspence@FuelS cc:
pot.com Subject: RE: pl/sql question
List,
One of the developers here is using Procedure Builder to create and compile his PL/SQL
packages. It works file until he sends me the package in text format to compile on the
database. I call the package by @g:\packages\test1 where test1 is the test1.sql of the
package text.
Question.
Ron,
if you enter the line set define ~ command before you @g:\. you
should be fine.
this is a difference between sqlplus and pb. note that toad works like pb -
anything within
the /* */ is a comment.
wouldn't it be great if Oracle could produce two products that work
consistently
You could try
set define off -- stops SQL*Plus looking for substitution variables off
or
ser scan off-- much the same thing I think
-Original Message-
Sent: 05 September 2001 19:41
To: Multiple recipients of list ORACLE-L
List,
One of the developers here is using Procedure
Someone said to 'set feedback on' problem can be that feedback is normally on,
but set to a minimum of 6 rows before it starts talking, Consequently what you
probably need is 'set feedback 1'.
Dick Goulet
Reply Separator
Author: Djaroud Salim [EMAIL
hi every body,
I need to insert in the end of a sql script, the number of rows returned.
how can i do that ?
thanks !!!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djaroud Salim
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
set feedback on
Best Regards,
Nabila Mekkaoui
DBA Oracle
-Message d'origine-
De : Djaroud Salim [mailto:[EMAIL PROTECTED]]
Envoyé : lundi 3 septembre 2001 10:30
À : Multiple recipients of list ORACLE-L
Objet : a little sql question
hi every body,
I need to insert in the end
Greetings!
I don't see a lot of general sql questions on this list, so if this is the
wrong place to post this sort of thing, just let me know! This will
hopefully seem like a simple question, but I am a relative novice in sql
programming!
Here is the (simplified) scenario with three tables:
:
Sent by: Subject: SQL Question
[EMAIL PROTECTED
Your method is correct. The only issue is if you are processing huge amount
of data, this will take some (may be lot of) time. You can use not like
option for DO NOT contain query.
...
where title not like '%word%'
rgds
amar
-Original Message-
Sent: Tuesday, August 21, 2001 5:06 PM
To:
-
- Your method is correct. The only issue is if you are processing
- huge amount
- of data, this will take some (may be lot of) time. You can use not like
- option for DO NOT contain query.
- ...
- where title not like '%word%'
If you are suggesting a query such as:
select id from biblio
recipients of list ORACLE-L
Subject: SQL Question
Greetings!
I don't see a lot of general sql questions on this list, so
if this is the
wrong place to post this sort of thing, just let me know! This will
hopefully seem like a simple question, but I am a relative
novice in sql
recipients of list ORACLE-L
Subject: RE: An SQL question , not easy ;-)
Is this not flawed in that given these results:
eventtimeevent
-
01-AUG-2001 12:10:00 start add 1- 1
01-AUG-2001 12:15:00 start add 1- 2
01-AUG-2001 12:25:00 start
of Central England
-Original Message-
From: Thomas, Kevin [mailto:[EMAIL PROTECTED]]
Sent: 15 August 2001 16:11
To: Multiple recipients of list ORACLE-L
Subject: RE: An SQL question , not easy ;-)
Is this not flawed
Subject: RE: An SQL question , not easy ;-)
Or use a self-join
select a.call_start, count(b.call_start) interruptions
from phone_call a, phone_call b
where a.call_start = b.call_start and a.call_end b.call_start
group by a.call_start
-Original Message-
Sent: 15 August 2001 16:02
: Thomas, Kevin [mailto:[EMAIL PROTECTED]]
Sent: 15 August 2001 15:07
To: Multiple recipients of list ORACLE-L
Subject: RE: An SQL question , not easy ;-)
David,
Here's the output from your suggestion based on a table
with the following rows;
CALL_STARTCALL_END
Yes, and this morning my manager just asked me for something similar
too. How fortunate :0)
g
-Original Message-
Sent: Wednesday, August 15, 2001 7:26 PM
To: Multiple recipients of list ORACLE-L
Hi All:
There's one really neat thing about this thread...it's helped me solve
an
August 2001 16:46
To: Multiple recipients of list ORACLE-L
Subject: RE: An SQL question , not easy ;-)
Or use a self-join
select a.call_start, count(b.call_start) interruptions
from phone_call a, phone_call b
where a.call_start = b.call_start and a.call_end b.call_start
group
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 conversations.
Please help !!!
Thanks a lot in advance !
Andrey.
--
Please see the official ORACLE-L FAQ:
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 conversations.
Consider there are 4 calls ,
one started at 12:10 and ended at
Quick and dirty solution:
Pick a time and look for all calls which started before that time and
ended after that time. That will tell you how many calls were in
progress at that time.
Repeat this at, say, half hour intervals, and graph the results. This
will show you a trend. Where it looks
Give me some time :-)))
Jan Pruner
Dne st 15. srpen 2001 12:40 jste napsal(a):
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
1. Create table CC with 2 fields: DT DATE, CALL_COUNT NUMBER .
2. Fill table CC with tuples with DT started from MIN(CALL_START) up to
MAX(CALL_END) and CALL_COUNT = 0. Step of DT value is 1 minute (or second =
36mil tuples/year).
3. for every tuple in a table of phone calls update table CC
Pursuing Guy's method in a non-procedural way:
select
ts.timestamp,
count(*)
from
(
select
to_date('1-jan-2001','dd-mon-') +
(rownum / 1440) timestamp
from short_narrow_table_of_numbers
where rownum = 1440
)ts,
phone_calls
where
Thanks Guy !
The problem is that i need it in one non-interactive PL/SQL block .
Thanks a lot !!
-Original Message-
Sent: Wednesday, August 15, 2001 1:00 PM
To: Multiple recipients of list ORACLE-L
Quick and dirty solution:
Pick a time and look for all calls which started before that
recipients of list ORACLE-L
Subject: An SQL question , not easy ;-)
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 conversations.
Please help
recipients of list ORACLE-L
Subject: An SQL question , not easy ;-)
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 conversations.
Please help
[mailto:[EMAIL PROTECTED]]
Sent: 15 August 2001 11:21
To: Multiple recipients of list ORACLE-L
Subject: An SQL question , not easy ;-)
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
I'm working on this one, almost got a solution... ;-)
Kev.
-Original Message-
Sent: 15 August 2001 14:05
To: Multiple recipients of list ORACLE-L
Thanks Guy !
The problem is that i need it in one non-interactive PL/SQL block .
Thanks a lot !!
-Original Message-
Sent:
:[EMAIL PROTECTED]]
Sent: 15 August 2001 15:07
To: Multiple recipients of list ORACLE-L
Subject: RE: An SQL question , not easy ;-)
David,
Here's the output from your suggestion based on a table
with the following rows;
CALL_STARTCALL_END
PROTECTED]]
Sent: 15 August 2001 15:07
To: Multiple recipients of list ORACLE-L
Subject: RE: An SQL question , not easy ;-)
David,
Here's the output from your suggestion based on a table
with the following rows;
CALL_STARTCALL_END
- -
01-AUG-2001 12
PROTECTED]]
Sent: 15 August 2001 15:07
To: Multiple recipients of list ORACLE-L
Subject: RE: An SQL question , not easy ;-)
David,
Here's the output from your suggestion based on a table
with the following rows;
CALL_STARTCALL_END
- -
01-AUG-2001
England
-Original Message-
From: Andrey Bronfin [mailto:[EMAIL PROTECTED]]
Sent: 15 August 2001 11:21
To: Multiple recipients of list ORACLE-L
Subject: An SQL question , not easy ;-)
Dear gurus !
I have a table of phone
: 15 August 2001 15:07
To: Multiple recipients of list ORACLE-L
Subject: RE: An SQL question , not easy ;-)
David,
Here's the output from your suggestion based on a table
with the following rows;
CALL_STARTCALL_END
- -
01-AUG-2001 12:10 01-AUG
Andrey,
At first glance, I think this SQL statement gives you the answer. It gives you
a count of the simultaneous calls for each call. If you like this, then all you
have to do is find the row with the maximum count.
select a.call_start,a.call_end,count(*)+ 1
from pc a, pc b
where
(l_max_count) );
end;
Regards
David Lord
-Original Message-
From: Thomas, Kevin [mailto:[EMAIL PROTECTED]]
Sent: 15 August 2001 15:07
To: Multiple recipients of list ORACLE-L
Subject: RE: An SQL question , not easy ;-)
David,
Here's the output from your suggestion based on a table
: Thomas, Kevin [mailto:[EMAIL PROTECTED]]
Sent: 15 August 2001 15:07
To: Multiple recipients of list ORACLE-L
Subject: RE: An SQL question , not easy ;-)
David,
Here's the output from your suggestion based on a table
with the following rows;
CALL_STARTCALL_END
Hi All:
There's one really neat thing about this thread...it's helped me solve an
on-going problem. I've
got managers who want to see graphs of their system's usage. Using this
mechanism applied
against the DBA_AUDIT_TRAIL view works perfectly.
Thanks!
Mike
---
select table_name from dba_tables where table_name like 'EDL_WORK_%'
and I received the following
TABLE_NAME
-
EDL_WORKSTATION_LOCATION
EDL_WORK_AR_ENTITIES
Why would I be receiving the first record (EDL_WORKSTATION) if I
try EDL_WORK_A% I get the correct
Darren,
You would need to use the escape character.
Try this,
select table_name from dba_tables where table_name
like 'EDL-_WORK-_%'ESCAPE'-';
Suhen
I have a simple query, but the results are somewhat puzzling
select table_name from dba_tables where table_name like 'EDL_WORK_%'
and I
% match any number of chars == * in dos
_ match one character == ? in dos
joe
Browett, Darren wrote:
I have a simple query, but the results are somewhat puzzling
select table_name from dba_tables where table_name like 'EDL_WORK_%'
and I received the following
TABLE_NAME
Darren,
Just as the % character is a wildcard that matches any number of characters,
the _ character is a wildcard that matches any single character. So it matches
the S in WORKSTATION, and then the % sign matches TATION_LOCATION.
hth,
Yosi
Browett, Darren wrote:
I have a simple query, but
To add to this thread, you can make it only return the second record by changing
the statement to:
select table_name from dba_tables
where table_name like 'EDL\_WORK\_%' escape '\';
This will force the _ character to be used as a literal.
Yosi Greenfield wrote:
Darren,
Just as the %
:
[EMAIL PROTECTED]Subject: PL/SQL Question after migrating
from
om7.3.4 to 8.1.7
07/27/2001
01:45 PM
Please respond
to ORACLE-L
Hi,
I just
Hi,
I just migrated from 734 to 817, I used migration utility. Migration went fine. Some
of my package specification have become
invalid.
When I tried to recompile, I got the following error
30/41PLS-00206: %TYPE must be applied to a variable, column, field or
attribute, not to
Deen,
shouldn't the statement be:
TYPE tb_uc9_corres_type IS TABLE OF uc9_correspondence.COLUMN_NAME%TYPE
INDEX BY BINARY_INTEGER;
??
The %TYPE in your PL/SQL is being applied to the table which, I think, is
not valid. A PL/SQL table is a one-column data type, indexed via the
Deen,
If you want a table with the structure of a row in your uc9_correspondence, use THE
'%ROWTYPE'as follows:
TYPE tb_uc9_corres_type IS TABLE OF uc9_correspondence%ROWTYPE
INDEX BY BINARY_INTEGER;
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
:
[EMAIL PROTECTED]Subject: PL/SQL Question after migrating
from
om7.3.4 to 8.1.7
of list ORACLE-LSubject: SQL
Question
Good morning,
Env't: Oracle 8.1.5, HP-UX 11.0 (64
bit)
Given the following tables:
emp with 100 rows
dept with 10 rows
and this SQL:
select emp.ename,
initcap(dept.deptname)
fromemp.dept
where emp.deptno = emp.deptno
the easiest would be to have a function based index on the column.
joe
Steve Haas wrote:
Good morning,
Env't: Oracle 8.1.5, HP-UX 11.0 (64 bit)
Given the following tables:
emp with 100 rows
dept with 10 rows
and this SQL:
select emp.ename, initcap(dept.deptname)
from emp.dept
, the function should be ran once for each record in the result
set.
-Original Message-From: Steve Haas
[mailto:[EMAIL PROTECTED]]Sent: Friday, July 13, 2001 7:21
AMTo: Multiple recipients of list ORACLE-LSubject: SQL
Question
Good morning,
Env't: Oracle 8.1.5, HP-UX 11.0 (64
I want to get every date between two user entered date's whether or not it
exists in the table and then the quantity of data for the date if any
exists.
My table t1 has date and quantity values (may be more than one quantity
field per date)
and I want 0 for all dates in the range where no data
Title: RE: Sql question
John,
I see two options. Both include a cross reference table with every date in it.
1. Outer join the dates table with the data table and nvl after the sum to replace nulls with 0's.
Or
2. Simply union-all your query as it stands right now with
SELECT
John,
just fooling around, I came up with this. run it thru sqlplus.
obviously, change the table reference to your table.
set serveroutput on
spool results.xls
DECLARE
l_date DATE;
start_date DATE := to_date('s_date','mm/dd/');
end_Date DATE := to_date('e_Date','mm/dd/');
loc_sum
: Friday, June 29, 2001 2:37 PM
To: Multiple recipients of list ORACLE-L
Subject: Sql question
I want to get every date between two user entered date's
whether or not it
exists in the table and then the quantity of data for the date if any
exists.
My table t1 has date and quantity values
recipients of list ORACLE-L
Subject: Sql question
I want to get every date between two user entered date's whether or not it
exists in the table and then the quantity of data for the date if any
exists.
My table t1 has date and quantity values (may be more than one quantity
field per date
Shaw, John B wrote:
I want to get every date between two user entered date's whether or not it
exists in the table and then the quantity of data for the date if any
exists.
My table t1 has date and quantity values (may be more than one quantity
field per date)
and I want 0 for all dates
I am sure you can get this with one of analitical functions.
Alex Hillman
-Original Message-
Sent: Friday, June 29, 2001 2:37 PM
To: Multiple recipients of list ORACLE-L
I want to get every date between two user entered date's whether or not it
exists in the table and then the
I have a LOG
table with LOG_ID, TIME and TEKST columns
I want to get
records for the last hour (or certain time) (x records) and if less then N
records in last hour, then get also last N-x records so that Iget N
records alltogether. And I wnat them ordered descening (last record
first)
I
List hi!
Oracle 8.1.7 EE on AIX.
One of our developers wrote a procedure. Inside that procedure he wants to
know instance and schema, while executing that procedure.
Do you have any suggestions?
TIA,
Sonja
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
[EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Pl/SQL question
Date: Mon, 25 Jun 2001 04:45:28 -0800
List hi!
Oracle 8.1.7 EE on AIX.
One of our developers wrote a procedure. Inside that procedure he wants to
know instance and schema
Sonja,
Instance is easy enough. Either grant the person SELECT access to the
V_$INSTANCE view under the SYS account, or create another view owned by the
DBA that returns the same information.
By schema, do you mean the schema where the procedure exists, or of the
person executing the
I need to whip out a PL/SQL procedure real quick today and have a quick
question for fellow-listers ( since today is Friday, hopefully I don't get
RTFMed on this one :) )
The purpose of my procedure is to collect stats from v$session_wait
periodically ( every second for example) and pump the data
Use dbms_lock.sleep()
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an
There is indeed a sleep, in dbms_lock, taking a single argument seconds.
-Original Message-
Sent: Friday, May 11, 2001 11:20 AM
To: Multiple recipients of list ORACLE-L
I need to whip out a PL/SQL procedure real quick today and have a quick
question for fellow-listers ( since today is
Dennis,
How about dbms_lock.sleep(seconds) ?
Jared
On Friday 11 May 2001 08:20, [EMAIL PROTECTED] wrote:
I need to whip out a PL/SQL procedure real quick today and have a quick
question for fellow-listers ( since today is Friday, hopefully I don't get
RTFMed on this one :) )
The purpose
while trunc(sysdate, ss) = 30 loop
I think this should do whatever's in the loop every minute on the 30 second
point.
-Original Message-
Sent: Friday, May 11, 2001 11:20 AM
To: Multiple recipients of list ORACLE-L
I need to whip out a PL/SQL procedure real quick today and have a quick
Dan,
While this does not work as is, but probably could be in
some fashion, you win the days raspberry for the most
obfuscated answer. :)
Jared
On Friday 11 May 2001 09:56, Dasko, Dan wrote:
while trunc(sysdate, ss) = 30 loop
I think this should do whatever's in the loop every minute on
[EMAIL PROTECTED] wrote:
I am wondering if there is a similar
function in PL/SQL similar as the Unix 'sleep' command.
Use dbms_lock.sleep -- it's pretty much like Unix sleep, but requires you to
grant execute on dbms_lock to whichever account needs it.
Bill
--
dbms_lock.sleep(second in number);
[EMAIL PROTECTED] 05/11/01 11:20AM
I need to whip out a PL/SQL procedure real quick today and have a quick
question for fellow-listers ( since today is Friday, hopefully I don't get
RTFMed on this one :) )
The purpose of my procedure is to collect stats from
Hi:
use the procedure:
dbms_lock.sleep(seconds);
HTH
--
Von: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
Gesendet: Freitag, 11. Mai 2001 17:20
An: Multiple recipients of list ORACLE-L
Betreff: PL/SQL Question
I need to whip out a PL/SQL procedure real quick today
Try
DBMS_LOCK.SLEEP (
seconds IN NUMBER);
Regards
Karthik Ramachandran
[EMAIL PROTECTED] 05/11/01 11:20AM
I need to whip out a PL/SQL procedure real quick today and have a quick
question for fellow-listers ( since today is Friday, hopefully I don't get
RTFMed on this one :) )
The
301 - 400 of 421 matches
Mail list logo