Hi
all,
Can
anyone tell me which of the following performs better in collecting statistics
of a table:
Analyze
command or
Dbms_stats.gather_table_stats
I tried my queries with
both the options -- but always Analyze is out-performing the
dbms_stats.
But i read in a
doc
I need some help. I was an Oracle DBA with ADC Telecomm
in Minnesota and was laid off along with 7,000 other ADC
employees. The job market here in the TCs has been
very slow.
Any assistance finding another Oracle related position
would be greatly appreciated. Please contact me directly
Hi All,
Recently we moved the database(Oracle 8.0.5) from NT to Sun machine. Now
this database is going online very soon. When we were testing we observed
that, the application (select statement) is running very slow. (I don't know
how fast it was earlier). I have a feeling that it is not using in
Kesh - What do you define as performance?
1. How fast a table is analyzed?
2. The performance of the queries that use the statistics that were
collected?
What Oracle version are you on?
In theory, you can analyze tables when the system load isn't so great. In 9i
you can even have Oracle decide when
uster statistics, and validating the structure.
Djordje
-Original Message-From: Jayaram Keshava Murthy
(Cognizant) [mailto:[EMAIL PROTECTED]Sent: Monday, June
02, 2003 10:50 AMTo: Multiple recipients of list
ORACLE-LSubject: Need help
Hi
all,
Can
anyone tell me
Yes, I am talkin about the time it takes. The analyze command takes around 2 mins to
esimate statistics of a table with a Million records whereas the dbms_stats package
function is merely hanging !!
And besides, Djordje is telling that they nearly take up the same time !! But i am
not experi
shava Murthy(Cognizant) [mailto:[EMAIL PROTECTED]]
Sent: Monday, June02, 2003 10:50 AM
To: Multiple recipients of listORACLE-L
Subject: Need help
Hi
all,
Cananyone tell me which of the following performs better in collecting
stati
Hi,
I have two tables
1. ALL_CUSTOMER
CustNo: 1 to 100
OtherDetail: bla bla bla
2. ORDER
CustNo
TotalOrder
DateOrder
I want to display like this
CustomerNo 1Total Order For This month = 101
or
CustomerNo 1 Total Order For This month = 0
My SQL statement is like
Hello all,
A very basic question; the background processes, smon, pmon, etc. do they have an
executable name like smon* etc. or pmon* in some bin directory of oracle? Or how do
they start? like eg. BMC' Patrol agent when it runs is run because there is an
executable called PatrolAgent, is it t
Hi,
Can someone help me with this please
What cause the error ?
SQL> select bitand(4,4) from dual;
ERROR:
ORA-00932: inconsistent datatypes
no rows selected
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinard Xing
INET: [EMAIL PROTECTED]
Fat Cit
Ken,
Welcome to the club. Are we starting a trend? At least
we're not competing against each other.
Good luck,
Yosi
[EMAIL PROTECTED] wrote:
> I need some help. I was an Oracle DBA with ADC Telecomm
> in Minnesota and was laid off along with 7,000 other ADC
> employees. The job market here
Hello, Uday,
First step, try ANALYZE TABLE ... COMPUTE STATISTICS for EVERY table
participating your query(es). Check and compare execution plan before and
after analyze.
HTH
Vadim Gorbounov
Oracle DBA
-Original Message-
Sent: Thursday, April 19, 2001 3:32 PM
To: Multiple recipients of l
You have to ru explain plan for that statement.
You first have to create the PLAN_TABLE, you can do that running the script
$ORACLE_HOME/rdbms/admin/utlxplan.sql
Then, login to sql and run th following statement:
SQL> explain plan for your-sql ;
then, run the following statement to obtan the e
hi uday!
i strongly would recommend you to have a look at the execution
plan of your sql statement. you might also find my tool called
top100 quite useful in helping you to look at the execution
plans for all statement in your sga.
have a look at my web page at: www.materialdreams.com
do
-O
Uday,
Your problem may have more than one component. There are three
immediate things I'd try/look at, one of which will provide you with
information, the other two that may or may not improve your
performance. For information on your select statement, start a trace on
the session, run the sele
t ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Need help
>
> I have done some test before and found out that analyze is faster than dbms_stats
> for smaller tables only (less than 10M) - and the difference was not that big (for
> example very small tables dbms_stats would do a comput
select 'CustomerNo '||a.custno||' Total Order for this month =
'||nvl(c.totalorder,0)
from
all_customer a,
(SELECT b.custno as custno, sum(b.totalorder) as totalorder
from orders b
group by b.custno,to_char(b.dateorder,'mm')
having to_char(b.dateorder,'mm')
Outer join?
Guang
On Thu, 3 Jul 2003, Sinardy Xing wrote:
> Hi,
>
>
> I have two tables
>
> 1. ALL_CUSTOMER
>CustNo: 1 to 100
>OtherDetail: bla bla bla
>
> 2. ORDER
> CustNo
> TotalOrder
> DateOrder
>
>
> I want to display like this
>
>
>
> CustomerNo 1Total Order For
Title: RE: Active sessions chewing up a huge amount of RAM
I am looking for a way to display rows as columns.
For example:
Id name value
1 a 5
1 b 10
2 a 15
2 b 20
I need it as:
name 1
Hi friends
wish u all a very happy new year
i am getting the following error when i run my report
REP-1219: '' has no size -- length or width is zero.
but when i rebuild the report again it works well
but when i save it and run it next time it again gives the same error
and i have to rebuild it
When detail_comments in the testable is inserted or updated too then I want it
to update the various_comments column which is in the same table (testtable).
What would be the most efficient way to write the trigger to do this?
CREATE OR REPLACE TRIGGER ADD_TO_TESTTABLE
AFTER INSERT OR UPDATE O
Hi all,
For example, my files are like these
mylogfile001.log
mylogfile002.log
I want to initialize my variables with those number, like this
i=1
for all_file in `ls -1 /tmp`
do
file$i=all_file
i=i+1
done
file_tag1=`unix_command $file1 ` <--- help me here
wh
Hi All,
I want to load PDF files into the database and view the content of the lobs column. Below is what I did step by step. Anyone please point out what did I do wrong in my procedure. I am still unable to view the content of the Lobs column. I need you all for your help.
Please note that
Hi all,
I try to change the error message to French,
What I did is
SQL> alter session set nls_language = french;
Session altered.
SQL> select * from d;
select * from d
*
ERROR at line 1:
ORA-00942: table or view does not exist
The error message stil
Hi List,
I have a monster tablespace 36 G with two datafiles 32 G and 4 G. Don't ask
me who created such a file because I don't know. I am trying to rescue the
database that has multiple problems. Something you've never seen before.
Bye the way, did anyone ever run a test how much stuff you ca
select bitand(4,4)+0 from dual;
--- Sinard Xing <[EMAIL PROTECTED]> wrote: >
Hi,
>
> Can someone help me with this please
> What cause the error ?
>
>
>
> SQL> select bitand(4,4) from dual;
> ERROR:
> ORA-00932: inconsistent datatypes
>
>
>
> no rows selected
>
>
>
>
> Sinardy
> --
>
ommon sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Sinard Xing [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, March 14, 2002 8:48 PM
> To: Multiple recipients of list ORACLE-L
> Subject: BITAND need help
&g
15, 2002 9:49 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: BITAND need help
>
> Do a:
>
> desc dual
>
> SQL> desc dual
> NameNull?Type
> ---
> DUMMY
cipients of list ORACLE-L
> Subject: RE: BITAND need help
>
> Do a:
>
> desc dual
>
> SQL> desc dual
> NameNull?Type
> ---
> DUMMYVARCHAR2(1)
>
&
Hi,
I need some help...I am trying to use SQL loader
to load a flat file into a table...the problem I have is that
when trying to load a blank column into a date column...
this throws out an error...and the loader fails...do you know of a way of
how
to get around this problem...how can I just
Hello all,
I need some urgent help, so please help in replying quick.
I have some performance metrics here and I am trying to understand as to how this
affects the systems performance. The performance metrics are File opens, no. of ports
open, the sar queues, file system accounting statistics,
All,
I need some help in tuning a select statement that performs a FTS. (The FTS
is deliberate !) It takes over 5 hours to run in our prod instance, but
takes less than 10 min in our QA instance. The QA instance was copied from
prod about 6 weeks ago and is identical to prod, except for
db_block_b
This is kind of a different Oracle question. Does anyone have any suggestions
how a person can land an entry level job. I do not work in the Technology
field but would very much like to. I have been going to school at night for
about two and a half years
and have the first two OCP developers tes
Hi. I have a query that seems to be waiting for a PS
enqueu for about 2 days. When querying the
v$session_wait, I'm getting the following:
SID EVENT S-I-WT P1
P2 P3
- - -- --
--- --
48 enqueu
Hi Group,
I wanted to do 9i OCP. Any good sites are there to give free sample exam
questions. (I want a full set not that 12 Question exams).
Expecting ur help.
Thanx For All,
Senthil.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Senthil Kumar D
INET: [EMAIL PRO
hish
- Original Message -
From:
Sergei
To: Multiple recipients of list ORACLE-L
Sent: Thursday, December 12, 2002 4:59
AM
Subject: Need help Reformatting
output
I am looking for a way to
display rows as columns.
For
example:
Id
name
rence'). The chapter is entitled 'DECODE - Amazing Power in a Single Word'.
peter
edinburgh
-Original Message-From: Sergei
[mailto:[EMAIL PROTECTED]]Sent: 12 December 2002
02:59To: Multiple recipients of list ORACLE-LSubject:
Need help Reformatting output
I am
echiel
Adar
To: Multiple recipients of list ORACLE-L
Sent: Thursday, December 12, 2002 10:38
AM
Subject: Re: Need help Reformatting
output
You can try concatenation.
Pseudo code:
c1 := null
c2 := null
c3 := null
open cursor
while not end-of-set
c1 := i
Hi
Is this in a report if so i can help you else aim sorry.
thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Walid Alkaakati
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailin
SergeiSent: Wednesday,
December 11, 2002 6:59 PMTo: Multiple recipients of list
ORACLE-LSubject: Need help Reformatting output
I am looking for a way to
display rows as columns.
For
example:
Id
name
value
1
a
5
1
b
g_colName is a string of column names that I build earlier in the algorithm. My
problem is how do I do the 'INTO' part of this cursor, since I do not know how many or
of what type my columns are. The query is on the fly and totally dynamic.
Anyway to do this without using DBMS_SQL package?
BDY.RTF
Description: RTF file
hi
for a in *.log; do echo $A; done
for a in $(ls /*.log); do echo $; done
instead of echo use whatever you need.
>>> [EMAIL PROTECTED] 08/26/02 12:31 PM >>>
Hi all,
For example, my files are like these
mylogfile001.log
mylogfile002.log
I want to initialize my variables wi
-- [EMAIL PROTECTED]
> echo "$all_file" | sed 's/mylogfile//g' | sed 's/\.log//g
echo $file | sed 's/[^0-9]//g'
avoids problems if someone decides to add a dash or sometning
into the name.
--
Steven Lembark 2930 W. Palmer
Workhorse Computing
> For example, my files are like these
>
> mylogfile001.log
> mylogfile002.log
>
> I want to initialize my variables with those number, like this
>
> i=1
> for all_file in `ls -1 /tmp`
> do
>
> file$i=all_file
> i=i+1
> done
>
> file_tag1=`unix_command $file1 ` <--- help
Blimey! Doesn't anyone know korn shell out there any more. Perl perl perl -- that's
all I ever hear anymore. It gets old... (I'm gonna have to buy Jared's book one of
these days).
x=${file1%.log}
file_tag1=${x#mylogfile}
Kevin Kennedy
First Point Energy Corporation
If you take RAC out of O
ROTECTED]
08/26/02 02:41 PMcc:
Please respond toSubject: RE: Unix scripting n
"Ron Thomas"
.com>cc:
Sent by: Subject
2:41 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Unix scripting need help
Blimey! Doesn't anyone know korn shell out there any more. Perl perl
perl -- that's all I ever hear an
I've been an Oracle DBA and developer for many years (more than 10) and I
have also been a Unix Sys Admin (about 5 years). I am used to playing god
with the server , where I am the DBA and the System Administrator. (Of
course these days, a lot of companies and clients want a segregated
environmen
Unix scripts is one thing I don't worry much and am taking my own time to
learn those with Perl. We got a fantastic bunch of Unix admins who are just
waiting for challenges and always deliver.
It is bad (for me) and good (that I can spend more time on Oracle issues
like chasing OWS personnel and
Hi all,
When I do
Select * from v_$sga;
NAME VALUE
--- ---
Fixed Size ###
Variable Size ###
Database Buffers###
Redo Buffers##
Hi all,
1. I have table emp (ename, dept, sal)
2. I do
SELECT 'NAME : ' || ename || ' DEPARTMENT : ' || dept || ' SALARY : ' ||
sal
FROM emp;
Result:
NAME : JAMES DEPARTMENT : LAB ENGINEER SALARY : 2000
NAME : BOB DEPARTMENT : DRIVER SALARY : 2
Hello all,
I have attached an sql file containing a set of sql's (6) of them, which gives me
information regarding table fragmentation. What I need to do is instead of writing
seperate sql's, I need to write a procedure, where in I pass the owner and table name
and then the result comes out, a
Sinardy Xing wrote:
>
> Hi all,
>
> I try to change the error message to French,
Don't do that. French-speakers have to translate back to English to
understand what they mean.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Aut
This is a valid user in database but not to export somebody has any idee o
solve it.
/sscedre/data/spcedw/admin/export[oracle]# exp userid=system/manager
file=CTXSYS.dmp log=CTXSYS.log owner=CTXSYS
Export: Release 8.1.7.2.0 - Production on Thu Apr 18 17:43:10 2002
(c) C
Are you rebuilding indexes with unrecoverable/nologging and parallel clause
or simple 'alter index index_name rebuild tablespace tbs_name', which is
definately slow then using above options500/600MB indexes may take
around 30/35 minutes depending of your parallel clause and cpu
availabilit
Thank you everyone who replied. All suggestions were very helpful. I am
bebuilding my indexes in a different tablespace. It runs very very slow..
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, August 02, 2001 3:51 PM
> Lyuda;
> 1.
I meant EBUILDING. That is what a long day of slow rebuilding indexes
can do to you.:-)
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, August 02, 2001 9:32 PM
> Thank you everyone who replied. All suggestions were very helpful.
Lyuda;
1. Create a new tablespace for the indexes on a seperate drive. Make sure
you do this with a much more reasonable datafile size. (Watch it here
maybe they did the big size because they were running out of possible files
-- see the max_datafiles parm on the Create Database command)
Hi Lyuda
This is not a nice situation to bee in, but the god new is that oracle can help
you since you are using version 8.1.6 !
You can use the "ALTER INDEX REBUILD TABLESPACE
;" to move the index to a new tablespace and this can even
be don online with "ALTER INDEX REBUILD ONLINE TABLESPACE
Lyuda,
You didn't say if you have other disk space available or not. If you do I would create
the index/indexes tablespace/s on different drives then drop them from the original
location. After you get breathing room you can reorg the database to a more
comfortable setup. When you have removed
You can check alter index clause and you will find parallel option. You may
use parallel 5 safely being default in initSID.ora. However it will start
building 5 times extent in temp tablespace before completion of rebuilding.
With rebuilding large indexes on regular basis we have to use all suc
Hi,
I solved this:
SQL> select bitand(4,4)/1 from dual;
BITAND(4,4)/1
-
4
Sinardy
-Original Message-
Sent: 15 March 2002 10:53
To: 'LazyDBA mailing list'; 'Multiple recipients of list ORACLE-L'
Subject: BITAND need help
H
The reason behind the oddity is probably
that bitand() is defined (see standard.sql)
to return a binary_integer (it used to return
a number in earlier versions) and pure SQL
does not recognise that type, so you need
a method for coercing the result to a number.
It is probably slightly cheaper
Hi,
Take a look at the nullif clause.
tom
-Original Message-
Sent: Tuesday, May 29, 2001 12:41 PM
To: Multiple recipients of list ORACLE-L
Hi,
I need some help...I am trying to use SQL loader
to load a flat file into a table...the problem I have is that
when trying to load a blank
In the CONTROL file that describes the columns to load from the data file you can load
a FILLER type column desc into the destination table if the column does not exist in
the source data file. If the source data column contains nulls then a NVL will convert
a null to what ever you want to plac
To: Multiple recipients of list ORACLE-L
> Subject: Need help tuning FTS
>
>
> All,
> I need some help in tuning a select statement that performs a
> FTS. (The FTS
> is deliberate !) It takes over 5 hours to run in our prod
> instance, but
> takes less than 10 min in
I would recommend uping the parameter "_DB_BLOCK_HASH_LATCHES" by default
after I believe 2000 block buffers, it defaults to 1024 all the way up to
10 blocks buffers if i remember correctly. This will generate alot of
the #66 latch contention. This shouldn't equate to 6 hours compared to 10
n
the select statement, that might have a high cache value
in QA, but a low cache value in prod?
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 06, 2001 2:47 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Need hel
Chris,
Thanks for your input !
One difference between our prod and QA instances is that the QA instance is
relatively idle - while average load on the prod instance is about 175
users, with less than 5% hitting the database hard at any given point in
time. I am unable to figue out why there is su
Srini,
I am sure you have lots of users in Prod compared to QA :)
Anyway, the point is that you are suffering from hot block contention which
reflects itself in latch waits on 'cache buffer chain'. I remember that
Steve Adams has a SQL at his site that identifies blocks that are 'hot' - I
have
John,
Thanks for your input !
Unfortunately, this issue seems too weird ! (I know, I know, I shouldn't
be saying that as a DBA !!).
We have run that process three times today in prod in an effort to try and
isolate the issue. We have run it when only one other user was hitting the
prod database h
Hi Srini,
>isolate the issue. We have run it when only one other user was
>hitting the
>prod database heavily using a select stmt on unrelated tables - but the
>problem still persists. There were no concurrent requests
>running at the
>time. The issue does not seem to be related to contention o
ali@C
ummins.com To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED]Subject: RE: Need help
E-L <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED]Subject: RE: Need help
tuning FTS
m
06/06/2001
04:07 PM
Please respond
to ORA
A, but a low cache value in prod?
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 06, 2001 2:47 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Need help tuning FTS
>
>
> All,
> I need some help in tu
Hi all,
I recreated DBA role that provided by Oracle8i,
1. Create New_DBA_role identified by change_me;
2. Select 'GRANT ' || privilege || ' TO new_dba_role' FROM dba_sys_privs;
Create new dba user
3.Create user new_dba identified by password
default tablespace userdata
I dont want to sound rude here, and my comments are NOT directed at you personally.
What is the standard of these OCP's, when a person who has not worked with oracle, can
pass them, for the sake of discussion it does not matter which tests they were? It
seems doing an OCP is a complete waste of
luck
Sinardy
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
[EMAIL PROTECTED]Sent: Wednesday, 20 June 2001 11:15
AMTo: Multiple recipients of list ORACLE-LSubject: Need
help getting startedThis is kind of a different Oracle question. Does anyone
Viraj, hahahahah, it couldnt have been said any better :), i've been
thinking that way for years as well as a few others on the list :)
joe
Viraj Luthra wrote:
>
> I dont want to sound rude here, and my comments are NOT directed at you personally.
>
> What is the standard of these OCP's, when
Dear Viraj,
I can totally understand how you feel.
But I hope you can appreciate that it takes a lot of courage and
perseverance for a person who doesn't know Oracle to take any of the OCP
papers. Many of us have to do a lot of additional studies on top of the
Oracle training material inorde
My first question is what is your field of study in school? Is it computer related?
Have you graduated, many employers want to see you graduate before they will hire you.
Have you asked any of your larger companies about any IS extern programs that they
might have. If you have graduated, have y
Sllewnerak@ao
l.comTo: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Sent by: cc:
ro
I agree, if you have no experience and take the exams it will give you some
level of knowledge about oracle. I have started taking these exams and
recognize one issue with getting certified. It's great and all, but it's
like any other test. You can study your arse off and pass with flying
color
t for many.
Cheers!
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
> -Original Message-
> From: Joseph S. Testa [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, June 20, 2001 6:25 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re:
Title: RE: Need help getting started
Karen, for what it's worth:
What did you study in college? Studying CSCI in college is absolutely not a prereq for getting into technology but it at least demonstrates that you can think that way. I did study CSCI and I think half of it was a was
At 11:15 PM 6/19/01 -0800, you wrote:
>
>What is the standard of these OCP's, when a person who has not worked with
oracle, can pass them, for the sake of discussion it does not matter which
tests they were? It seems doing an OCP is a complete waste of time!
>
Uh, couldn't the same comment then b
Joe, I don't think we've enough information to state that she doesn't
have Oracle running on her Linux machine at home, and hasn't diligently
practiced and studied. I learnt Java in a similar way before getting my
first Java developer job back in '96. I would expect people on this
list to be a li
Just as an addendum to what others have said. Many goverment offices
accept volunteers. Have you tried going to your city/county goverments
and if possible state? Also, hospitals also accept volunteers.
Terry
[EMAIL PROTECTED] wrote:
> This is kind of a different Oracle question. Does anyone
I'm kind of in the same boat as Karen... except that I'm working as a
developer right now (not Oracle). My goal of becoming a DBA has taken a
year and a half to complete the certification track. I know the effort it
takes to get certified. Granted, there are a lot of things I leaned and knew
I have a public database link defined with userid-1.
Userid-1 has update permissions on table-a in database-b.
Userid-2 has no permissions on table-a in database-b.
Userid-2, in database-a, calls a package that contains the database link and
tries to update table-a in database-b.
The result is an
OK folks I'm out on the dark side, once again. Does anyone remember how MicroSlop's
BCP utility in SQL*server works? I've got a user who bought a third party SQL*server
application, I won't go there, and he needs to move some data from a desktop to a
laptop SQL*server database.
Dick Goulet
Se
Not sure what you're asking here, but SQL Server Books Online (search on
"bcp Utility") should give you that information.
-Original Message-
Sent: Friday, October 31, 2003 11:10 AM
To: Multiple recipients of list ORACLE-L
OK folks I'm out on the dark side, once again. Does anyone rememb
you need to create a format file (.fmt) for the that as per your data file.
-Original Message-
Goulet, Dick
Sent: Friday, October 31, 2003 9:40 PM
To: Multiple recipients of list ORACLE-L
OK folks I'm out on the dark side, once again. Does anyone remember how
MicroSlop's BCP utility in
Senthil
I hope you get a reply. But I have searched for the same and I don't
think anyone will go to the trouble of creating a really good exam, then
giving it away for free. As we discussed yesterday on this list, Couchman is
a good author to use, and even he has a few glitches. But when you ar
Dennis,
You are right. Nothing is free if t has a quality. Best option is to buy sts
question which cosr normally $99 but they also offer sometimes at 25-30%
discount. Alternately buy Daniels 9i new features comes with test question
CD. I rather suggest Senthil to buy sts eaxm questions and the
Hi All,
They are at the moment offering 50% discount...
Here is an excerpt from one recent promotion..
SAVE 50% on all individually packaged Self Test Software test
prep products from 12:01 am, May 28, 2003 to midnight EDT on
May 31, 2003.
There will be no
This probably isnt that hard, but Im having a brain dead moment.
My goal is to select data from a table in one schema and insert it into the same table
in another schema. However, I am not 100% certain that the tables exist in both
schemas or that the columns are the same.
The columns can be d
Title: RE: need help with dynamic sql
if you at-least know the source and destination tables will have same number of columns and data types ... you could just do something like
insert into target.table
select from source.table
Raj
1 - 100 of 218 matches
Mail list logo