Oracle Help
in [SQL]
|
SQL Server database link problem with varchar Hi, someone could help me? I have a database link to a SQL Server 2005 that is used to insert data from Oracle to SQL Server Database. When I try to insert VARCHAR columns with more than 255 characters, the data is truncate in exactly 255 characters :( What I'm doing wrong? Tks Oberdan ... 7 Aug 2008 17:35
modules of a DBMS Hi, how correct is the following diagram showing modules of a DBMS ...???? http://i529.photobucket.com/albums/dd339/aarklon/5.jpg ... 7 Aug 2008 11:24
Sorting a column I just tried the following UPDATE T SET pos = DENSE_RANK () OVER (ORDER BY name) Unfortunately, this does not work because Oracle does not allow analytic functions in the SET clause. ... 14 Aug 2008 09:19
[Q] Sorting a column Hi I have a table T with two columns NAME (VARCHAR2) and POS (NUMBER). I want to write an UPDATE query, which updates the column POS such that its values correspond to the alphabetical order of NAME. UPDATE T t1 SET pos = (SELECT ROWID FROM T t2 WHERE t1.NAME = t2.NAME ORDER BY NAME) That does not work... 7 Aug 2008 04:13
Regular Expressions Hi, I've been looking at REGEXP_LIKE to help me come up with a way to check the syntax of an email address. Basically I need to make sure that is does not contain any of the following characters: !#$%^&*() +=<>,?"':;{}[]|\/ And, there is only 1 @ and at least 1 . A bit harder than I expected. So, event... 6 Aug 2008 16:57
Regular Expressions I'm currently looking for an example on how to code this, but maybe I can take a shortcut and someone will do it for me. LOL Anyhow, I need a regular expression to filter out any values with special characters: !#$%^&*()+=<>,?"':;{}[]|\/ So far I can get the first character to be a valid one: regexp_like... 6 Aug 2008 17:59
How to determine the Edition for Oracle 9i Hi All-- I have a machine running 9.2.0.6.0 on Windows 2003. I would like to confirm whether it is Standard or Enterprise Edition that is installed. I have tried select banner from v$version The output is: Oracle9i Release 9.2.0.6.0 - Production PL/SQL Release 9.2.0.6.0 - Production CORE 9.2.0.6.0 ... 6 Aug 2008 15:55
Executables question I'm doing some work with 9i application files and need some definitive help - what is launch.exe w/respect to a 9i installation? Is it a core executable - e.g. one that will always be found to coexist on a 9i Server Wintel install or can it be run remotely without a full blown install? Is there one or two core ... 6 Aug 2008 10:45
PL/SQL How to set Varray elements in a loop Hello, is it possible to set the elements of a VARRAY in a loop instead of initializing it in one step? Does anyone have a sample for me? Is it possible to resize the VARRAY dynamically? Thank you, Norbert ... 7 Aug 2008 04:13
How do I insert a BC date into Oracle? Hi, Let's say I want to insert 104000 BC into a date field in an Oracle table? How do I do that? Is it as simple as inserting "-104000" into the date field or is it more complex than that? Any help would be appreciated. -Murali ... 6 Aug 2008 11:47 |