Jacques,
What about using the following script to measure actual amount of redo in
the log file:
---
--
-- Script: log_file_usage.sql
-- Purpose: to see how much of the current log file has been used
-- For:
Case*Method Entity Relationship Modelling by Richard Barker; 1990; ISBN
0-201-41696-4;
Data Model Patterns / Conventions of Thought/ David C. Hay
The Data Model Resource Book by L. Silverston, W.H.Inmon, K. Graziano;
1997; ISBN 0471-15364-8;
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
Peter,
The tables are permanent but the data within them is temporary - the data
life is either until you commit or until you logoff depending upon the
option chosen when you create the table.
This is initially confusing as it is different to how (say) Rdb handles
temporary tables.
Somewhat
Hello Shuan
If I am not mistaken you need to run a configuration program before you can
start using OEM on 8.1.6.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: C.S.Venkata Subramanian [SMTP:[EMAIL PROTECTED]]
Sent: Thu, January 10, 2002 6:55 AM
Bruce,
I have a question on this? How do you create a temp table which
automatically
clears the data after usage. Because I had faced the same problem.
I insert data into a temp table and I commit it.
I say select * from table Name
I get the data.
I come out of that SQL session and again
Hello All
I use TOAD version 7.1.
When I run a select with (like where id = id) a pop up window ask for the
replacement value.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: Jacques Kilchoer [SMTP:[EMAIL PROTECTED]]
Sent: Thu, January 10, 2002
Your boss is right.
Oracle dropped support for 8.1.6.
We have the same problem, but I think that I will wait another 2-3 months
and move to 9i.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: David Ehresmann [SMTP:[EMAIL PROTECTED]]
Sent: Wed,
Windows XP Security Hole Lets Attackers 'Plug and Prey'
Microsoft has issued a security patch to fix a vulnerability on its new
Windows XP operating system. Enterprises must act at once to deter malicious
attacks on their networked PCs.
Hello again,
thanks all that have replied.
I have another question. Is it possible to clone a database just only through
OS operations? For example, is it possible to overwrite the files related
with one database (.dbf, .ctl..) with the one related with the database to
'clone'?
Maybe it sounds
Sorry, forgot the start. It is :WE8ISO8859P1.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: [SMTP:[EMAIL PROTECTED]]
Sent: Thu, January 10, 2002 12:00 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: US7ASCII, UTF8, characters
Yes it is quite possible to do just that.
The only thing is that you have to generate a CREATE DATABASE command
from the source DB by ALTER DATABASE BACKUP CONTROLFILE TO TRACE command.
Note the CONTROLFILE does not have a space in it !
You then alter the contents of the Trace file to SET the
OS : WINNT , DB : 8.1.7
I have a java class embedded in database and I am
calling it with a procedure.
The procedere executes a bat file .
In the bat file there 2 copy commands . First of
them copying a file from a local directory to another local directory.
Second command copy's a file
O'Neill, Sean wrote:
We perform disk-to-disk offline backups on a nighlty basis. Database is
running in archived log mode. Due to space contraints (don't ask =:-[ ) we
are currently forced to backup only some of the data files. The data files
excluded belong to specific schema owners and
Hi,
I would want to ensure that the datafiles being exluded have READ ONLY
Tablespaces
to ensure that they do not change.
This would ensure that in the event of a recovery there will not be an SCN
issue
Martin
-Original Message-
Sean
Sent: 10 January 2002 12:05
To: Multiple recipients
Where is your door?
Ken
-Original Message-
Sent: Wednesday, January 09, 2002 7:40 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Database jobs still hot
Ya, can you send them to my door?
-Original Message-
WILLIAMS
Sent: Wednesday, January 09, 2002
So I have to use the ip-addresses? I cant use the name of the computer, for instance
hakon5.
Thanks in advance
Roland
Gogala, Mladen [EMAIL PROTECTED]@fatcity.com den 2002-01-09 07:11 PST
Sänd svar till [EMAIL PROTECTED]
Sänt av: [EMAIL PROTECTED]
Till: Multiple recipients of list
[EMAIL PROTECTED] wrote:
Ya, you are right, some unix having no GUI for the first installation like
FreeBSD 4.
vi is the only one availabe there for you to configure your xwindows or KDE.
it also helps if you have a lot of the commands hardwired into your
fingers.;-)
and one of the first
Good morning,
We are having a problem load a file containing dates in MON DD format
into a database having and nls_date_format=MMDD. Is there a way to do
an alter session command in the control file or the parameter file to that
we can load this data?
We have had the production
The fact, that it works under 9i, is really
interesting. I didn't have chance to play with it yet.
As for 8.1.7, Oracle runs under NT 'SYSTEM' account
(just look at startup options of Oracle service in
ControlPanel/Services).
Hence, your .bat file, called from Oracle,is
executed under
and mc.
:-)
On Thu 10. January 2002 13:50, you wrote:
[EMAIL PROTECTED] wrote:
Ya, you are right, some unix having no GUI for the first installation like
FreeBSD 4.
vi is the only one availabe there for you to configure your xwindows or
KDE.
it also helps if you have a lot of the
I've had some problems with the Change Manager.
For some databases it doesn't see any of the objects that would fall in
the last few item categories in the navigator pane on the left - including
tablespaces.
There is a bug with the JVM, sometimes the Oracle Java tool colours go
beserk
That is correct, you will need to run the enterprise Manager Configuration
Assistant. It will configure your oms to work with a OEM repository.
When you run the oms for the first time you will use username sysman password
oem_temp it
will prompt you to change this value.
John
[EMAIL
Ruth Gramolini wrote:
Good morning,
We are having a problem load a file containing dates in MON DD format
into a database having and nls_date_format=MMDD. Is there a way to do
an alter session command in the control file or the parameter file to that
we can load this data?
There is a site on the 'net somewhere that inventories who is using what OS
and Web server for major Web sites, but I can't remember what the URL for
that is.
It only reflects what they are using to serve pages to the Web, though.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Ok, so to get a better feel for what's going on, is everyone still using
US7ASCII?? Have sites started switching over to UTF8?? Have there been any
conversion problems?? Do the websites(like Amazon, Yahoo, BN, etc) that
have an Oracle backend enforce UTF8 as a standard, so that they can store
Hallo,
Can anyone tell me why I get this errormessage when I run this script. I know that
there are files in the directory
prod/sas/data/bilbo/indata
Files that exists in that directory are for example customer.txt, cars.txt. I want to
copy those files. But it doesnt sem to find them.
The
Chris,
We have started using UTF8 on our new databases as a standard.
All of our old, existing databases use US7ASCII.
We need to convert a couple of existing databases such as our
200Gig data warehouse from US7ASCII to UTF8.
I am concerned about conversion problems. I asked a few weeks
Anyone care to comment on the following, IMHO it's about time:
---
Introducing two new levels of Oracle Certified Professional (OCP) Achievement
A recent *IDC report on IT Education and Training Services quoted
It is not the file prefix it is the file suffix. Try moving your '*' to
before the variable name (this is keeping your variable name... which I
would change to reflect what it really is. Your script thinks it is
.txtcustomer .txtcars
echo mget *$fileprefix
#echo mdelete *$fileprefix
I
Change mget $fileprefix* to mget *$fileprefix
- Kirti
-Original Message-
Sent: Thursday, January 10, 2002 7:50 AM
To: Multiple recipients of list ORACLE-L
Hallo,
Can anyone tell me why I get this errormessage when I run this script. I
know that there are files in the directory
www.netcraft.com
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 opinion is
My guess is : No.
Can you run a quick test and let us know ??
Thanks.
- Kirti
-Original Message-
Sent: Wednesday, January 09, 2002 3:45 PM
To: Multiple recipients of list ORACLE-L
8.1.7 on W2000
I would like to know if there is a way to group more than one parfile into
one file? I
Ruth:
Are you using a delimited flat file via SQL Loader? Would the to_date
function do the trick?
My 0.03 Euro's worth,
Ken
-Original Message-
Sent: Thursday, January 10, 2002 7:25 AM
To: Multiple recipients of list ORACLE-L
Subject:nls_date_format problem in sqlldr
Hello Ruth
The answer is not to change the nls_date_format but to tell the loader the
format you use for your date.
We use the following in our ctl files:
xx_xx_TAR_NECHONUT date(8) 'MMDD',
maybe you can use: my_date date(8) 'MMMDD' .
(I did not check if it works).
Sean,
First of all, datafiles actually belong to a
tablespace - not a schema.
1. You could place the tablespace into read-only
mode, take a backup of the tablespaces datafile(s),
then no additional backups are required for those
datafile(s) (and you are assured that no one updates
the data).
Put your * before the fileprefix variable.
Regards
Lee
-Original Message-
Sent: 10 January 2002 13:50
To: Multiple recipients of list ORACLE-L
Hallo,
Can anyone tell me why I get this errormessage when I run this script. I
know that there are files in the directory
Ruth,
If the source file is being loaded with SQL LOADER that you
can format the date load in the controlfile. We get our dates in the MMDD
format and load in to the database default by defining the source
data:
SaleDate TERMINATED BY ","
"TO_DATE(:SALEDATE,'MMDD')",
...Good
To be honest, I think this is actually lowering the bar. Oracle finally
realized that the OCP has no value to an organization unless you induce the
word Master. This has been taken from their former certification, the
Oracle Master's Certification, which was worthless and only showed that you
Title: RE: The OCP bar is being raised
I'd say the cost is being raised. Look at the requirements for each. You can't just take the OCM exam. No we would first have to get the OCA. Whether or not we need the entry level cert we have to have it. Then, and only then, can we take the OCP. Then
Portland, OR
-Original Message-
Sent: Thursday, January 10, 2002 5:00 AM
To: Multiple recipients of list ORACLE-L
Where is your door?
Ken
-Original Message-
Sent: Wednesday, January 09, 2002 7:40 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Database
Thanks Igor ,
I am trying it but when I want to log on to db , it
gives
ORA-12500: TNS:listener failed to start a dedicated
server process
error.
Will I do another change ? For example the startup
account of TNSLISTENER Service .?
Bunyamin
- Original Message -
From:
Igor
Title: RE: The OCP bar is being raised
Chris,
Am not clear on this.
To b an OCP, we require to pass 5 examsright ?? So, if we get
the
OCP Associate after passing
2 exams, we need to pass only another 3 exams for getting
OCP
or do we have to go through
all the 5 exams all over again ??
Dick,
I see value in the addition of the two levels of
certification.
With the addition of the OCA certification it will allow
"junior" DBA's to start on the read to successful certification. Learning and
understanding the basics of SQL and ADMIN should be promoted, displayed, and
Now that I finally have all of our databases upgraded to 8.1.7 I am taking some time
to look at our method of gathering statistics for CBO. It looks like I should move
towards using DBMS_STATS to gather statistics, but I may want to use ANALYZE if I need
to gather stats on individual columns
They offered the Oracle Master certification before, I was told from Oracle
Canada two years ago that to earn it one had to have taken courses
specifically from Oracle.
I asked because they offered NT Core Technologies, and I had taken the same
course from a Microsoft-certified training center.
Title: Message
From
the website:
--To become an Oracle Certified Professional, you must pass all
required exams --in your selected job role, including
those at the Associate level.
The
way I read that, you have to have the OCA exams before you can get the
OCP. So if you take and pass the
We got around this issue but if anyone knows whether this is possible I
would like to know for future reference.
Thanks anyway,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 10, 2002 8:25 AM
Good morning,
We are having a
OCP, OCA, OCM, OCD = ?
How can you bring money?
-Original Message-
Sent: Thursday, January 10, 2002 9:16 AM
To: Multiple recipients of list ORACLE-L
Anyone care to comment on the following, IMHO it's about time:
Title: Message
H...so all we have
to do is appear for 2 exams and get OCA and then appear for
the
remaining 3 exams and
upgrade ourselves to OCP...or do we need to take all the 5 exams
all over again
??
Samir
Samir Sarkar
Oracle DBA - Lennon
Team SchlumbergerSema
Email :
Well, A number of folks have weighed in on this matter I appreciate each point
of view, especially those about Oracle Education just trying to justify itself.
What IMHO is good in this is the praticum exam. It lends a true degree of
certified hands on professionalism to the certificate, not
Of course, those of us who already have the OCP and want to be called a
'master'
just need to take the 2 required courses and then the OCM exam.
When looking at the details, they just split the previous 5 exam OCP into
two tiers,
a 2 exam OCA, and a 2 exam OCP which has the OCA as a
hi SQL wizards,
Can any body help me with the tjis SQL. I need a SQL records with top 100 values of a
table ( not rownum 101 ).
Thanks
Deen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deen Dayal
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
Hello, i don't know if it's a bug, but probably, yes.
The case is the following:
We're using Oracle server 8.1.6, running on MS Windows 2000, and Oracle
OLEDB Provider version 8.1.7.02 on the client side.
We're tried to use ADO 2.6 sp1 to create ADO Command objects to insert data
values to BLOB
Some correction.. Please...
and only showed that you had taken all of the courses within a
specific track.
and only showed that you had paid for all the courses within a specific
track and were present for 1st and the last day of the courses.
(
1st Day : to make sure your name was spelled
I would highly recommend that you move to DBMS_STATS if you are running at
least 8.1.6.3 -- especially if you are estimating statistics.
The reason is that DBMS_STATS generates more and better statistics than
analyze. I've seen queries go from hours to minutes just by changing from
ANALYZE to
Oh yeah, that's absolutly the idea behind it. For Oracle to grab more money.
Personally I never gave a crap about certification. We don't need an entity like
Oracle or MS to tell us how much we know. We learn stuff because we love to
not because of the certificates. Yes, I do know the
Title: RE: The OCP bar is being raised
ENRON
-Original
Message-
From: orantdba
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002
9:36 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: The OCP bar is being
raised
Hmmm,
Imagine that, a publicly traded company
If you already have the 8i OCP, there is a single upgrade exam to
become a 9i OCP.
I'm studying for it now.
-Joe
At 07:40 AM 1/10/02 -0800, you wrote:
H...so all we have to do is appear for 2 exams and get OCA and
then appear for the
remaining 3 exams and upgrade ourselves to
Title: RE: The OCP bar is being raised
Actually, looks like to me that they simply revised
their Masters program. Its exactly
the
same requirements except they now added an exam at the end. Not to
many
folks
were going after the Master level except for the actual Oracle
employees.
Title: Message
Hi all,
The oca exams are the same exams you would take on the way to being an OCP
under the current program. The only difference is along the way you can
get a designation of OCA. Not unlike Microsofts MCP.
John
[EMAIL PROTECTED] wrote:
>From the website:
--To
Srini,
But be careful - the Change Management pack for OEM is a purchaseable
option. It is not free.
Jim
__
Jim Hawkins
Oracle Database Administrator
Data Management Center of Expertise
Pharmacia Corporation
800 North Lindbergh Blvd.
St. Louis,
Title: Message
Wait a minute. I never said it was bad for companies to make
money. My past posts on microsoft should have made that clear. If
Oracle can get away with it, then hey, more power to them. My point
was that they are trying to make this look oh so nice by saying "it's
improved!
Jay,
I have switched to DBMS_STATS for quite some now. Most databases are
8.1.7.x.
I have not had any problems running DBMS_STATS. Or from the generated
stats.
- Kirti
-Original Message-
Sent: Thursday, January 10, 2002 9:31 AM
To: Multiple recipients of list ORACLE-L
Now that I
If using 8i
SELECT * FROM
(SELECT *
FROM table
ORDER BY column_name DESC)
WHERE rownum = 100;
Rick
Deen Dayal
Deen Dayal wrote:
hi SQL wizards,
Can any body help me with the tjis SQL. I need a SQL records with top 100 values of
a table ( not rownum 101 ).
Thanks
Deen
rownum 101 is OK if you nest your query, ORDER BY included, as an
in-line view,
ie
select x.val
from (select val
Hey, who's your buddy?
But I was disappointed it doesn't have a template yet for IEEE 802.11b
RSA triple dipstick encryption.
-Original Message-
Hannibal,
Thanks for the link! This product is SO COOL!
I personally code in SQL, HTML, Javascript, PHP (sometimes) and am curently
Title: RE: The OCP bar is being raised
Maybe I am completely misreading this. However, I didn't see the 8 to 9 OCP upgrade and that is why I said, you'll have to take them over again. If I am completely out to lunch and this is just a re-org of the Masters and OCP and those 8 OCP can get OCM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 10, 2002 18:03
hi SQL wizards,
Can any body help me with the tjis SQL. I need a SQL records with top 100
values of a table ( not rownum 101 ).
u do need rownum
select *
from
Deen,
You could try SELECT fields... FROM
(SELECT field1 FROM table1 ORDER BY field1)
WHERE rownum 100; ( the value is 100 less that
number of rows returned)
That will order the rows returned by the value in the field1
and then give you the row numbers of the returned rows that are greater
Use ORDER BY name of column DESC
and, of course, rownum 101 :-)))
--
SELECT NAME, VALUE FROM (
SELECT NAME, VALUE FROM TOP100 ORDER BY VALUE DESC
) WHERE ROWNUM 101
JP
On Thu 10. January 2002 17:03, you wrote:
hi SQL wizards,
Can any body help me with the tjis SQL. I need
Or use KdB.
-Original Message-
Sent: Thursday, January 10, 2002 11:26 AM
To: Multiple recipients of list ORACLE-L
If using 8i
SELECT * FROM
(SELECT *
FROM table
ORDER BY column_name DESC)
WHERE rownum = 100;
Rick
Deen Dayal
SELECT * FROM (SELECT VALUES FROM TABLE ORDER BY VALUES) ROWNUM 101;
Deen Dayal
ddayal
Just set the environment variable before running sqlldr:
export NLS_DATE_FORMAT='MON DD '
Ruth Gramolini
Check this out on amazon.com.
They have several used copies. I replaced my copy that was 'borrowed'
just last
week for $24 US. ( $60 list )
Jared
I tested under 8.1.6 on NT and the reply is NO.
Checked also the new features for 9.0.1 and no mention of this.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: Deshpande, Kirti [SMTP:[EMAIL PROTECTED]]
Sent: Thu, January 10, 2002 4:30 PM
To:
Ed,
I would be interested in getting a copy of your test scripts to try it out
on our setup. Solaris 8, veritas DBed 2.2 and Oracle 8.1.7.
Our performance has increased since switching to quick io, but that also
included a major application overhaul, and new disk layout and an upgrade
to
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 10, 2002 18:09
created with quotes
1. If you create the table and field names with quotes (tablename,
FieldName, etc), then you cannot insert BLOB or CLOB values larger than
4000
How many people outhere that you know do actually have
OCM. Not ORACLE employees.
Just curious...
Regards,
Viktor
--- Bowes, Chris [EMAIL PROTECTED] wrote:
Maybe I am completely misreading this. However, I
didn't see the 8 to 9 OCP
upgrade and that is why I said, you'll have to take
them
I don't believe those are available for download, at least not legally.
Jared
Andrey Bronfin
I tried to run it in Oracle 7.3.4, it comes up with a syntax error
Here is the SQL
select x.fein,x.open_bal
from (select sf_get_fein(employer_id) fein, nvl(total_open_balance_amt,0) open_bal
from employer
order by open_bal desc ) x
where rownum 101
Here is what
Hey Guys.
Just built my 8.1.7 solaris test server at work and need to patch it up to
Release 3. Unfortunately, OTN keeps giving me Page Not Found when I go to
download it.
Does anyone know any alternate locations that these patches are available ??
Thanks
Kevin
--
Please see the official
Here's the link:
http://www.oracle.com/education/certification/index.html?dba9i_upgrade.html
and here's the upgrade path:
http://www.oracle.com/education/certification/index.html?dba9i_track.html
Oracle 7.3 to Oracle9i Upgrade Path (3 exams)
Candidates certified on Oracle 7.3 pass exam
Oracle 8.1.6, using Net8, wants me to name my db_link the same as the
database that it's linking to.
I don't want to.
Tried using a synonym but that didn't work.
Tried using create database link linkname connect to userid identified by
password
using ' (DESCRIPTION =(ADDRESS_LIST =
Correction : SELECT * FROM (SELECT DISTINCT VALUES FROM TABLE ORDER BY
VALUES DESC) WHERE ROWNUM 101;
-Original Message-
Sent: Thursday, January 10, 2002 11:51 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: SQL for top 100 values
SELECT * FROM (SELECT VALUES
Hi,
We´ve setup DCD , using
SQLNET.EXPIRE_TIME = 5 in
I know some Oracle employees that have OCD.
-Original Message-
Sent: Thursday, January 10, 2002 12:16 PM
To: Multiple recipients of list ORACLE-L
How many people outhere that you know do actually have
OCM. Not ORACLE employees.
Just curious...
Regards,
Viktor
--
Please see
In your init.ora
GLOBAL_NAMES=FALSE
Bounce your db and it should be OK.
On Thu, 2002-01-10 at 11:40, [EMAIL PROTECTED] wrote:
Oracle 8.1.6, using Net8, wants me to name my db_link the same as the
database that it's linking to.
I don't want to.
Tried using a synonym but that didn't
Order the CD Pack if you are in the U.S..
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Sent: Thursday, January 10, 2002 1:16 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Where to download Oracle Applications / ERP packages
Oracle employees typically get Oracle training for free, esp. during times
when they are idle - whenever THAT happens.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Sent: Thursday, January 10, 2002 1:16 PM
To: Multiple recipients of list
Kevin:
I had the same problem when I tried to download 9i zip files. It turned out
to be a problem with the security setup on my laptop for IE.
Ken
-Original Message-
Sent: Thursday, January 10, 2002 11:32 AM
To: Multiple recipients of list ORACLE-L
Subject:8.1.7
Well, there are at least 6 - from
http://www.tusc.com/oracle/news/20011203a.html
Niemiec joins Dr. Paul Dorsey, David Ensor, Peter Koletzke, Scott Nelson
and Jeremiah Wilton in the first group of Oracle Certified Masters to be
recognized by Oracle Corp
-Joe
At 09:15 AM 1/10/02 -0800, you
Don't use any aliases (x in your case) and try again
Regards
-Original Message-
Sent: Thursday, January 10, 2002 12:32 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: SQL for top 100 values
I tried to run it in Oracle 7.3.4, it comes up with a syntax error
Here
Hi List,
Sorry for off topic but if anybody know any patch for ERWIN 4.0 let me know
.
Thanks
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed,
Try
global_names = false
in your initSID.ora file.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 10, 2002 12:40 PM
Oracle 8.1.6, using Net8, wants me to name my db_link the same as the
Deen Dayal wrote:
I tried to run it in Oracle 7.3.4, it comes up with a syntax error
Here is the SQL
select x.fein,x.open_bal
from (select sf_get_fein(employer_id) fein, nvl(total_open_balance_amt,0)
open_bal
from employer
order by open_bal desc ) x
Thank you very much
- Kirti
-Original Message-
Sent: Thursday, January 10, 2002 10:51 AM
To: Multiple recipients of list ORACLE-L
I tested under 8.1.6 on NT and the reply is NO.
Checked also the new features for 9.0.1 and no mention of this.
Yechiel Adar, Mehish Computer
This was a new feature in Oracle8i. In 7.3 the best way would be to open
a cursor that sorted the data and return the first N rows.
Sorry,
John
[EMAIL PROTECTED] wrote:
I tried to run it in Oracle 7.3.4, it comes up with a syntax errorHere is the SQLselect x.fein,x.open_balfrom
I'm OCSlave.
-Original Message-
Sent: Thursday, January 10, 2002 12:46 PM
To: Multiple recipients of list ORACLE-L
I know some Oracle employees that have OCD.
-Original Message-
Sent: Thursday, January 10, 2002 12:16 PM
To: Multiple recipients of list ORACLE-L
How many
GLOBAL_NAMES=FALSE
-Original Message-
Sent: Thursday, January 10, 2002 12:40 PM
To: Multiple recipients of list ORACLE-L
Oracle 8.1.6, using Net8, wants me to name my db_link the same as the
database that it's linking to.
I don't want to.
Tried using a synonym but that didn't work.
You may be right, that's the version issue
-Original Message-
Sent: Thursday, January 10, 2002 12:32 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: SQL for top 100 values
I tried to run it in Oracle 7.3.4, it comes up with a syntax error
Here is the SQL
1 - 100 of 156 matches
Mail list logo
