Database Analyst Tasks

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

User with less privileges...

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

RE: User with less privileges...

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

Complex Integrity Checking

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

Complex Integrity Checking

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

RE: Complex Integrity Checking

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-

RE: Complex Integrity Checking

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

RE: Complex Integrity Checking

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

RE: Complex Integrity Checking

-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. **

RE: Complex Integrity Checking

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

RE: Sql question - please reply fast

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

RE: Sql question - please reply fast

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

RE: How Can I get A sequence Current Value in PROC

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

RE: How Can I get A sequence Current Value in PROC

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

RE: Inserstatement

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.

RE: Inserstatement

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

Import/Export table

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

RE: Import/Export table

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

RE: Why is this code not working?

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

RE: excel data into oracle through sql loader

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 ***

RE: sql query

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

RE: A range function ??

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

Forms Developer - Conversion Trouble

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] **

RE: Where 1 = 1

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

RE: komplex sql

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