Once table gets...

Differential from 07:00:00.000 to 06:59:59.997 is pretty close...

wim.buyens (3/5/2010)

---

This can be done with trigger and procedures I think but it won't be easy.

You can't use a foreign key based on some condition.

A trigger in which you...

David Lester (5/7/2010)

---

... are you thinking nice for being able to lookup the possible values, and adding new ones sometime in the distant future, or is it a performance related...

Yes indeed - that's why I was asking...

Can the original developer candidly...

CirquedeSQLeil (5/7/2010)

---

PaulB-TheOneAndOnly (5/7/2010)

---

eric_russell 13013 (5/7/2010)

---

This discussion just underscores why it's imporatant to always have at least 2 admins and 2 developers who know your database, just in case someone steps...

neliii (5/7/2010)

---

column1

\\xyz.se.df.a.b\fgd

colum2

\\xyz\fgd

now i want to join both the coulmns by elimating the highlighted part. i mean .se.df.a.b

or else just give me the query which can elimante that part from that...

eric_russell 13013 (5/7/2010)

---

This discussion just underscores why it's imporatant to always have at least 2 admins and 2 developers who know your database, just in case someone steps in front...

Using the above statement as reference I would agree that adding a new column to the target...

any chance of asking whoever adminis Oracle database to...

misc 53111 (5/7/2010)

---

would like to point out few things ,i am asking this as i want to break down contacts etc to related tables as there can be more than...

Please connect to target Oracle instance via SQLPlus and execute query with and without offending column. What happens in each case?

Please do this test for me.

Using your original code instead of adding column a.ID_DESC please add a different column, if possible of the number or varchar datatype.

Does it works or...

Whisper9999 (5/6/2010)We had a gig or two of free space in the data file before I dropped this table. I then dropped the table and then looked to see...