Hi all!
Can you guys, clear me up about what are the tasks of a database analyst. I
mean something like a job description.
I know they are likely to be different from case to case but just to make an
ideea.
Thanks in advance.
Iulian Ilies
Hi guys.
Can you give some ideeas about this problem.
I have a schema which contains all the objects for the application. The user
owner of the schema is also the application administrator and having more
privilleges. The other users can have access to these objects by beeing
granted with some s
erson.
Regards
iulian ilies
-Original Message-
Sent: Friday, August 02, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L
**
This email has been tested for viruses by F-Secure Antivirus
administered by IT Net
Hi guys. Here's my problem.
I want to check the new values (when inserting&updating a table) against the
ones in the existing rows. Something like checking for duplicate values, but
using a unique constraint doesn't suit my needs.
I think of a before insert&update trigger, wherein checking my con
Hi guys. Here's my
problem.
I want to check the
new values (when inserting&updating a table) against the ones in the
existing rows. Something like checking for duplicate values, but using a unique
constraint doesn't suit my needs.
I think of a before
insert&update trigger, wherein checkin
I said something like "the way the unique constraints work".
Ok. Here's my context.
I have a table say intervals and 2 columns start_time and end_time.
I want to check for overlapped intervals.
I know what conditions to check but I can't implement them.
Thanks!
iulian
-Original Message-
I'm reticent about putting the checking code in the application before
insert&update statement, although I'm not sure why. I'm just thinking about
concurency and all the implications.
On the other hand I wanted to put the bussiness rules on the database side.
Anyway, I'll use this approach, you
First of all I want to thank you all for your answers.
Let's take'em one by one:
Attn: Mercadante, Thomas F [[EMAIL PROTECTED]]
- I cannont use "instead of" trigger because of this error:
ORA-25002: cannot create INSTEA
-Original Message-
Sent: Wednesday, June 05, 2002 4:53 PM
To: Multiple recipients of list ORACLE-L
**
This email has been tested for viruses by F-Secure Antivirus
administered by IT Network Department.
**
Title: RE: Complex Integrity Checking
Ok
Richard, this seems to be what I want.
I read
carefully the message but I didn't find the trigger
RHUNTLEY.SINTERVAL
How
did you do that?
Thanks!
iulian
-Original Message-From: Richard Huntley
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, J
Can you tell us what the last word in the field value mean (except 'Info
missing' and 'Bad info')
I mean is there a rule that those T, S1 does respect?
Something like this:
- first character is a letter and in this set of values ('S', 'T' etc)
- the rest are digits
etc.
Try to find out a p
select field1, decode(field1, 'Info missing', 'Info missing', 'Bad info',
'Bad info', substr(field1, 1, instr(translate(field1, '0123456789',
'@@'), '@')-3))
from
HTH
Iulian
-Original Message-
Sent: Thursday, November 15, 2001 8:56 AM
To: Multiple recipients of list ORAC
You can use another pseducolumn CURRVAL but you must use at least once per
session the NEXTVAL before using the CURRVAL or else you would get the
ORA-08002 error.
...
SELECT .CURRVAL INTO FROM dual;
...
HTH
Iulian
-Original Message-
Sent: Monday, November 26, 2001 2:50 PM
To: Multiple
Or I think you can query the dictionary
SELECT last_number
INTO
FROM user_sequences
WHERE sequence_name = UPPER()
I don't know why it's necessary to use nextval, but they state this in the
documentation.
Iulian
-Original Message-
Sent: Monday, November 26, 200
You cannot achieve this by one sql statement.
Instead you should consider use PL/SQL.
Make your own procedure or an anonymous PL/SQL block.
I would like to give you an example but you have to tell more about your
problem, like the update should be done based on a relation between those 2
tables.
Yeah, Iain, you are right, and I don't hate to recognize.
Iulian
-Original Message-
Sent: Tuesday, November 27, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L
I hate to disagree but why couldn't you
update x
set field = (select field1
from p
where p.jo
Hi list.
I have 3 tables in a schema and I want to export them to another schema in
another database.
Any ideeas?
Thanks!
Iulian
**
The information contained in this communication is confidential and
may be legally pri
Thanks. Still have another questions.
- When importing can I change the original tables name?
- I try exp80&imp80 and besides the tables I saw that the import tool get
the constraints related to those tables. Can I import only the
structeure&data of the table without indexes and any other objects
I guess this is what you want:
select table_name, column_name
from dba_tab_columns
where (column_name = 'REGISTRATION_NUMBER' or column_name =
'DOCUMENT_NUMBER')
or
select table_name, column_name
from dba_tab_columns
where column_name in ('REGISTRATION_NUMBER', 'DOCUMENT_NUMBER')
-Origi
Have you considered to use find&replace tool in excel and replace all the
"th" string with nothing, and then reformat the cell as you need.
Iulian
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 6:00 PM
To: Multiple recipients of list ORACLE-L
***
Does this suit you?
select
to_number(null) as id,
to_char(null) as car_make,
0 ordcol
from
dual
union
select
id,
car_make,
1 ordcol
from
carmake
order by
ordcol,
car_make;
Iulian
-Original Message-
Sent: Tuesday, December 11, 2001 5:45 PM
To: Multiple recipients of l
Try this
ASCII(<>) NOT BETWEEN ASCII('A') AND ASCII('Z')
ASCII('A')-ASCII('Z') is an interval and ASCII('a')-ASCII('z') is another so
be careful
_
Iulian Ilies
mailto: [EMAIL PROTECTED]
mailto: [EMAIL
xample like this a number variable is assigned
with the varchar2 value returned by get_window_property(..., width)
Is it about formating that sort of values '999,999'
_
Iulian Ilies
mailto: [EMAIL PROTECTED]
mailto: [EMAIL PROTECTED]
**
te condition by OR operator
probably you will use the
WHERE 1 = 0.
I hope I'll make my point clear enough and of course is any related to your
case. Maybe if you show us the entire query, someone can tell you more about
it.
Regards
Iulian Ilies
-Original Message-
Sent: Friday, Oct
I hope I got you right. Anyway here's a not so complex sql
SELECT DECODE(mxurval_namn, NULL, 'No Info',
ltrim(substr(mxurval_namn,instr(mxurval_namn,' '
FROM mxurval;
I'm not sure what do you mean by 'No Info' and 'Missing Info'???
HTH
Iulian
-Original Message-
Sent: Wednesday, Nov
25 matches
Mail list logo