On 11/9/06, ViSolve DB Team <[EMAIL PROTECTED]> wrote:
Hi Experts,
We are in the process of converting Oracle administration commands into MySQL
for some purposes. We dont know how to convert the following Oracle commands to
MySQL. How to do that..?
1. ALTER USER spec TEMPORARY TABLESPACE tem
These commands are Oracle specific or contains Oracle specific
extensions. Nothing wrong with that, but in some cases there just is no
corresponding command in MySQL, as the concepts are different.
ViSolve DB Team wrote:
Hi Experts,
We are in the process of converting Oracle administration co
Hi Experts,
We are in the process of converting Oracle administration commands into MySQL
for some purposes. We dont know how to convert the following Oracle commands to
MySQL. How to do that..?
1. ALTER USER spec TEMPORARY TABLESPACE temp_ts;
2. DROP USER jbossjms1 CASCADE;
3. DROP TABLESPAC
Thanks dear. i thought u could be of some use in Oracle aswelll
- Original Message -
From: "Daniel Kasak" <[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>;
Sent: Friday, October 20, 2006 1:59 PM
Subject: Re: Oracle query..
Renish wrote:
Hello,
Renish wrote:
Hello,
Sorry. Again u r wrong..
Thers no connection with MYSQL here.
Well you're *very* much in the wrong list. Why are you posting to a
MySQL list if your question has nothing to do with MySQL? You do realise
there are Oracle lists, don't you? Surely people there will be abl
Thank u for ur speedy reply.
- Original Message -
From: "Chris" <[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>
Cc: "Daniel Kasak" <[EMAIL PROTECTED]>;
Sent: Friday, October 20, 2006 1:51 PM
Subject: Re: Oracle query..
Renish wr
Renish wrote:
Hello,
Sorry. Again u r wrong..
Thers no connection with MYSQL here.
Lets imagine I only have Oracle 7.3 data and then import the same data
into Oracle 10g
He's saying you need to talk to an oracle mailing list or forum.
We don't use oracle so we can't help you.
--
MySQL Ge
sh" <[EMAIL PROTECTED]>;
Sent: Friday, October 20, 2006 1:39 PM
Subject: Re: Oracle query..
Renish wrote:
Hi Mr Kasak
think you misunderstood my question
I dont want to Import to MYSQL. I want to import the data into Oracle 10
G. AS I said I have orcle 7.3 data already available with me.
Renish wrote:
Hi Mr Kasak
think you misunderstood my question
I dont want to Import to MYSQL. I want to import the data into Oracle
10 G. AS I said I have orcle 7.3 data already available with me..
Please tell me in step by step what i should do? as I am new to this
field. I appreciate ur ti
matter.
Cheers,
Renish Koshy
- Original Message -
From: "Daniel Kasak" <[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>;
Sent: Friday, October 20, 2006 11:50 AM
Subject: Re: Oracle query..
Renish wrote:
Hi All,
I have oracle 7.3 data available
Renish wrote:
Hi All,
I have oracle 7.3 data available with me..I see many *.ora files
and one Import _Rawdata.bat file. . I dont know which one to import.
Now I have installed, Oracle 10 g version server and client. Could you
pls tell me. how can I import those data into the Oracle 10g s
Hi All,
I have oracle 7.3 data available with me..I see many *.ora files and
one Import _Rawdata.bat file. . I dont know which one to import. Now I have
installed, Oracle 10 g version server and client. Could you pls tell me. how
can I import those data into the Oracle 10g so that I could
Your original Oracle(R) query (slightly reformatted):
SELECT IMRTAB.IMR906 AS NUM906
, IMRTAB.IMRFLL AS FLL
, SUM(IMRTAB.IMRCLL) AS CLL
, ROUND(SUM(IMRTAB.IMRDSC),2) AS DUR
, ROUND(SUM(IMRTAB.IMRDSC)/SUM(IMRTAB.IMRCLL),2) AS PRO
, SUM(IMRTAB1.IMRCLL) AS CLL
Hi guys,
I'm working in a telecom company that has Oracle for the call statistics.
Now we export the daily stats to a remote mySql.
The daily resume table looks like this:
++---+-++--+
--+++
| IMRFLL | IM
27;" <[EMAIL PROTECTED]>; "Arul"
<[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Thursday, June 27, 2002 5:42 AM
Subject: RE: How can this Oracle Query converted to MySQL
> In a nutshell, this can be rewritten as a join - no sub-select need
create temporary table tmp
SELECT IndustryID FROM
Company_Industries CI WHERE CI.CompanyID = C.CompanyID;
SELECT
U.UserID
FROM
Transaction_Data T, Rfq_Data R ,Company C
WHERE
T.TransactionID = R.TransactionID AND
(R.Industryid=1 or R.IndustryID=tmp.IndustryID)
Cheers
Rich
Arul w
1:04 PM
To: Arul
Cc: MySQL
Subject: Re: How can this Oracle Query converted to MySQL
Hi.
First, I removed the CC to the java list, because this problem is not
java-related in any way.
Second, I suggest you do some reading in the manual, the questions you asked
recently are mostly answered there
At 03:03 PM 6/26/02 +0530, Arul wrote:
>SELECT
>U.UserID
>FROM
>Transaction_Data T, Rfq_Data R ,Company C
>WHERE
>T.TransactionID = R.TransactionID AND
>(R.Industryid=1 or R.IndustryID IN (SELECT IndustryID FROM
>Company_Industries CI WHERE CI.CompanyID = C.CompanyID))
You ran this query throug
What us "U.UserID"? You don't have table U in the table list.
Arul wrote:
> SELECT
> U.UserID
> FROM
> Transaction_Data T, Rfq_Data R ,Company C
> WHERE
> T.TransactionID = R.TransactionID AND
> (R.Industryid=1 or R.IndustryID IN (SELECT IndustryID FROM
> Company_Industries CI WHERE CI.CompanyI
Hi.
First, I removed the CC to the java list, because this problem is not
java-related in any way.
Second, I suggest you do some reading in the manual, the questions you
asked recently are mostly answered there.
On Wed 2002-06-26 at 15:03:19 +0530, [EMAIL PROTECTED] wrote:
> SELECT
> U.UserID
>
---
> -Original Message-
> From: Arul [mailto:[EMAIL PROTECTED]]
> Sent: 26 June 2002 10:33
> To: MySQL
> Cc: [EMAIL PROTECTED]
> Subject: How can this Oracle Query converted to MySQL
>
>
> SELECT
> U.UserID
> FROM
> Trans
SELECT
U.UserID
FROM
Transaction_Data T, Rfq_Data R ,Company C
WHERE
T.TransactionID = R.TransactionID AND
(R.Industryid=1 or R.IndustryID IN (SELECT IndustryID FROM
Company_Industries CI WHERE CI.CompanyID = C.CompanyID))
This is to Pass the Mail Server : sql,query
---
22 matches
Mail list logo