Oracle documentation is very specific about syntax when using LIKE operator...

search_value LIKE pattern

where:

search_value is usually a column name you want to search for a pattern.

pattern is what you want to...

:blink: either this is spam or...

AndrewSQLDBA (3/30/2010)

---

Today one of the guys that I work with asked me the difference between a View and a Sproc. I could not easily answer. I just could not put...

Don't think the Oracle section of the forum is the right place for this question.

I would consider opening a ticket with FairCom.

endo64 (3/26/2010)

---

is it important to query optimizer if there is FK between two tables or not?

for ex.

table A (a_id, b_id)

table B (b_id, value)

select * from A left (inner) join B...

My pleasure... try this one http://www.consolidata.co.uk/Data-Warehousing/What-is-DWH/Star-Schema/default.aspx

I wouldn't go that far.

I'm in agreement about 3NF+ for OLTP - actually I do believe there is nothing you can't solve...

I would start with SQL Server Upgrade Advisor ... check this http://msdn.microsoft.com/en-us/library/ms144256(SQL.90).aspx

Even when normalization to -at least- the 3NF is critical for an OLTP system allow me to point that...

Annoying, huh? Doesn't happens to me.

I mean... use upper() function on both ends of the condition as shows in previous post.

upper(Name) LIKE upper(@Name) or @Name IS NULL

also remember to add "%" ... like in: upper(name) like upper('Jerem%')

Yes.

Check here... http://msdn.microsoft.com/en-us/library/ms151188.aspx

Two troubleshooting suggestions...

1- What happens if you run view's underlying query from SQL Server?

2- Would you mind in showing the result of "select instance_name from v$instance;" from both the Oracle...

looks like a text-book case for a pivot query ... bing "sql server pivot"