Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL concatenation issue for Oracle 9i
create or replace view TEMP AS select LING.A, LING.B, LING.C, LING.D, A||B||C||D as E from LING -
Check for change in status between records
no probs. I'm am cr&pping my pants about how godly the new functions are. Here is a link describing the new functions http://www.akadia.com/services/ora_analytic_functions.html#Crosstab%20or%20Pivot%20Queries One piece of sql with no selfjoins compares each record for an ID for changes in a... -
Check for change in status between records
just managed to do it in SQL. Using the new Oracle 8i Analysis functions (LAG, PARITION_BY, ROW_NUMBER ) it whips through and creates a table in a minute. -
Check for change in status between records
I have a table which contains multiple records per ID. A new record is entered each time one of the fields change. This can include changes to the STATUS field (a two letter field eg IR). When a change occurs a new row is created with a datastamp of the time of change. I want to for each ID...
