gt;
cc:
Subject:Re: double quotes column name
I guess this is not the case.
1. create table t("TABLE" Varchar2(10));
2. select table_name,column_name from user_tab_columns where
table_name='T';
TABLE_NAME COLUMN_NAME
---
ECTED]
> 08/21/2002 09:28 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject:double quotes column name
>
>
> Hi,
>
> One of our clients has created a ta
ond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:double quotes column name
Hi,
One of our clients has created a table with column name "access"
since access is reserved word , they use double quotes.
but
causes problems
somewhere down the line.
Every time that column is referred to you'll have to enclose it in quotes.
It's a terrible design choice. Go back to them and make them change it.
Actually, as they're a client rather than a supplier you should "advise"
them to change it
Harvinder,
The columns created with double quotes show as such in user_tab_columns, i
mean they show the name in the same case
so...
NameDisplayed
"Access" - Access
"ACCess" - ACCess
and so on. and when u query the table use select "Access" FR
Hi,
One of our clients has created a table with column name "access"
since access is reserved word , they use double quotes.
but when i query the table user_tab_columns it is still showing column name as access
and not "access"
how can we know that this t
d won't work...
Dan Fink
-Original Message-
Sent: Wednesday, August 21, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L
Hi,
One of our clients has created a table with column name "access"
since access is reserved word , they use double quotes.
but when
01, 2002 11:35 AM
To: Multiple recipients of list ORACLE-L
Hi DBAs,
I have strings that are being passed into parameters that contain embedded
single quotes. Obviously this fails the insert and
update statements. How can I handle these inside stored procedure?
Thanks
Rick
--
Please see the o
double up the quotes:
'string string string '' string string strin'
will give you a string with one single quote within.
p.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 01 July 2002 16:35
> To: Multiple recipients of
[EMAIL PROTECTED] wrote:
>
> Hi DBAs,
>
> I have strings that are being passed into parameters that contain embedded
> single quotes. Obviously this fails the insert and
> update statements. How can I handle these inside stored procedure?
>
> Thanks
> Ri
Hi DBAs,
I have strings that are being passed into parameters that contain embedded
single quotes. Obviously this fails the insert and
update statements. How can I handle these inside stored procedure?
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author
Ofcourse they are all true ! ;;-)
Connor McDonald wrote:
> "..increasing the buffer hit ratio from 95 to 99
> percent can yield performance gains of over 400
> percent"
>
> "Retrieving data from memory is over 1 times
> faster than retrieving it from disk"
>
> "A more efficient method is to
This does make you wonder about the recently awarded Master's certification
given by Oracle. (Not taking anything away from Jeremiah though)
Paul
-Original Message-
Sent: Thursday, March 14, 2002 3:20 PM
To: Multiple recipients of list ORACLE-L
"..increasing the buffer hit ratio fro
"..increasing the buffer hit ratio from 95 to 99
percent can yield performance gains of over 400
percent"
"Retrieving data from memory is over 1 times
faster than retrieving it from disk"
"A more efficient method is to have the database write
to the redo logs only when all the log buffers
Hi!
Thanks for the reply!
I downloaded the oledb upgrade what you showed me, but the problem was the
same.
Still not able to insert >4000 bytes of data if the column name is created
with quotes ("").
Without the quotes, everything is fine.
(ado 2.6 sp1, oraOLEDB 8.1.7.03)
- 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&
data
values to BLOB or CLOB fields.
The cases were the following:
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 bytes (error is: Invalid Column Name). Data which is smaller o
Hi All,
In my appln I want to insert quotes along with the data ie like abc's from the
application. Quotes may be there in some data but not there in some data. Any idea how
to Achieve this from any frontend.
TIA
Regards
Venkat
Get 250 color business cards for FREE!
speaking of dumping oracle, has anyone found a comparison of oracle vs. informix, as
this is becoming the db of choice, b/c its dam cheap.
>>> [EMAIL PROTECTED] 03/13 10:25 AM >>>
Maybe now that I've become a damager and have a budget, I'm seriously
considering kicking the Oracle habit. I think
Careful now...it's the only thing holding my stock position together... :-)
>>> [EMAIL PROTECTED] 03/13/01 09:27AM >>>
Isn't that utterly ridiculous. If you didn't call the 2nd server a "failover" server
and just manually moved over the filesystems and net address, you wouldn't need a 2nd
lic
The
bells are tolling for Lawrence. Downgrade to Brook's Brothers
suits?
-Original
Message-From: Diana Duncan
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 13, 2001
10:26 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: quotes
Maybe now that I've become a d
can switch
either way some times Oracle and DB2 to explore more about yourself.
Raghu.
>From: Diana Duncan <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: quotes
>Date: Tue, 13 Mar 2001 07:25
cal today...
Diana
-Original Message-From: Chuck Hamilton
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 13, 2001 9:27
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
quotes
Isn't that utterly ridiculous. If you didn't call the 2nd server a
"failover"
Isn't that utterly ridiculous. If you didn't call the 2nd server a "failover" server and just manually moved over the filesystems and net address, you wouldn't need a 2nd license! But if you automate the process with failover software, you do! The database and software are only ever going to be on
Just got my oracle quote back. I had asked about backup servers and
failover. To quote the salescritter, "In most cases where an environment
requires a standby failover server, a license will be required..."
Dennis Taylor
The light at the end of the tunnel is the
25 matches
Mail list logo