Hallo,
I have a table, A: IMPEXCEL_EANNR
which contains the field IMP_PRIS(= price)
It looks like this:
12
1,50
11
This is a varchar2 field in this table. I want that field values to be inserted(or
rather update the other table ) in other table called VARUKORGEANREL, but field in
which
Hallo,
Maybe this sounds simple for all of you, but I have a table with the field PRICE and
that is with datatype varchar2 I want the data in that field to be inserted in another
table with field PRICE, but that field has the datatype NUMBER. How can I
deasiest do this sql statement?
I really
Hej Roland (Sverige?),
I doubt that. If all the data is number in the varchar2 column, well, you
don't need it to be varchar2.
The easiest solution seems to be:
INSERT INTO newtable SELECT TO_NUMBER(col) FROM oldtable;
Premise: all your data in that column IS number. If you're not sure,
do
Hallo,
Maybe this sounds simple for all of you, but I have a table with the field PRICE and
that is with datatype varchar2 I want the data in that field to be inserted in another
table with field PRICE, but that field has the datatype NUMBER. How can I
deasiest do this sql statement?
I really
What's the data like in the varchar field? Is it in number format? A quick
sample would be good.
-Original Message-
[EMAIL PROTECTED]
Sent: 03 November 2003 11:14
To: Multiple recipients of list ORACLE-L
Hallo,
Maybe this sounds simple for all of you, but I have a table with the
]
co.uk cc:
Sent by: Subject: RE: datatypes varchar to
number
[EMAIL PROTECTED
Trigger using TO_NUMBER function would be the first thing that comes to mind.
I have designs like that, which are used for parsing so calld Bloomberg
files. Those files contain strings like N.A., -,|| ('|' is the field
delimiter) and all of those strings mean NULL. Also, stock split ratio can
:
Sent by: Subject: Re: Question about datatypes
[EMAIL PROTECTED
:
Sent by: Subject: Re: Question about
datatypes
[EMAIL PROTECTED
Perhaps:
Export, truncate table, alter table, import
or
Create temp_table as select * from orig_table,
truncate table orig_table,
alter tableorig_table,
insert from temp_table,
drop temp_table
Imran Ashraf [EMAIL PROTECTED]@fatcity.com on 02-05-2002 14:18:28
Please respond to [EMAIL
Hi,
i have a column set to number(3). However this needs
to be changed to number (3,2). But i cannot do a
straight alter table as there is data in the column.
how can i get round this?
cheers
__
Do You Yahoo!?
Yahoo! Health - your guide to
Imran,
what I do is the following:
create table temp_table as select primary_key_column, number_column from
table_to_be_changed;
update table_to_be_changed
set number_column=null;
alter table_to_be_changed modify(number_column(3,2));
declare
cursor c1 is
select primary_key_column,
imran9a@yahoTo: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
o.com cc:
Sent by: Subject: datatypes
Welcome to the next installment of 9i new features, topic for today is:
DateTime datatypes and the functions that support them.
Here are the 4 new data types that will be covered:
TIMESTAMP
TIMESTAMP WITH [LOCAL]TIME ZONE
INTERVAL YEAR TO MONTH
INTERVAL DAY
But it will be worthwhile since i'm learning ALOT about the new datatypes for dealign
with dates/time/timezone/fractional seconds, etc.
anyways in the meantime, i had quite a few people ask about back issues :)
they are up on my website
http://www.oracle-dba.com/9i
that will take you
Dear list !
There is a column of datatype RAW in a table.
it contains 4 numbers (4 bytes each) and a string of 54 bytes , that are
concatenated and then converted to RAW by an external C++ application.
I need to convert it back in a PL/SQL trigger.
I.e. i need retrieve that RAW column , and
Dear list !
There is a column of datatype RAW in a table.
it contains 4 numbers (4 bytes each) and a string of 54 bytes , that are
concatenated and then converted to RAW by an external C++ application.
I need to convert it back in a PL/SQL trigger.
I.e. i need retrieve that RAW column ,
Andrey,
You should first do a utl_raw.cast_to_varchar2 and then split the varchar2
string into individual numbers, using substr().
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion
It may be better to name it specifically as INTEGER etc. but good practice
would dictate using the %TYPE option..
K.
-Original Message-
Sent: 27 August 2001 17:01
To: Multiple recipients of list ORACLE-L
Dear gurus !
What is better performance-wise - to declare a variable inside a
Title: RE: A quick pl/sql datatypes question
I do
not think there will be any constraints when you declare it as
t.col%rowtype.
I
believe Oracle will do a lookup to come with the absolute data type during the
compilation of the stored proc or the anonymous block and will establish some
Dear gurus !
What is better performance-wise - to declare a variable inside a pl/sql
block (or a trigger) as integer (number , Pls_integer etc..) or as
mytable.mycolumn%TYPE .
Again , i'm concerned ONLY about performance in this question.
Thanks a lot.
DBAndrey
* 03-9254520
* 053-464562
*
From a pure performance direction,
pls_integer or binary_integer is probably
the fastest.
If you declare a variable to be of
table_name.column_name%type
there are implicit constraints on the
variable and any pl/sql assignments
(in particular arithmetic operations)
have to check that the
how does Oracle store NUMBER datatypes
internally?
TIA
___
Do You Yahoo!?
Yahoo! Messenger: Comunicación instantánea gratis con tu gente -
http://messenger.yahoo.es
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author
Can someone point me a document or something that
explains how does Oracle store NUMBER datatypes
internally?
TIA
___
Do You Yahoo!?
Yahoo! Messenger: Comunicación instantánea gratis con tu gente -
http://messenger.yahoo.es
--
Please
Oracle store NUMBER datatypes
internally?
TIA
___
Do You Yahoo!?
Yahoo! Messenger: Comunicación instantánea gratis con tu gente -
http://messenger.yahoo.es
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859
See Note: 1031902.6 How Does Oracle Store Internal
Numeric Data? for more details.
HTH,
-- Anita
--- Pablo ksksksk [EMAIL PROTECTED] wrote:
Can someone point me a document or something that
explains how does Oracle store NUMBER datatypes
internally?
TIA
I have several questions answers for wich I couldn't find in FM (not that I
tried too hard :-) ).
1. If LONG or LOB takes more than 1 block - how part of the last block left
free is used? Can it be used to store part of another LONG or LOB which more
thatn this free peace? I think not but not
Subject: Storage allocation for LOB and LONG datatypes
I have several questions answers for wich I couldn't find in FM (not that
I
tried too hard :-) ). [Kirti] Thanks for being so honest ...
1. If LONG or LOB takes more than 1 block - how part of the last block
left
free is used
28 matches
Mail list logo