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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Display text field where a number field is in a view
I'll try an example: Table A, Table B, Table C, Table D exist and are tied into a view, View A, where A.id = B.id2 AND A.id = C.id2 And A.id = D.id2 There is an addition of a new table, Table X, which contains id and id2 and text_field_1 View A currently pulls 1-3 fields (vf_1, vf_2...- TFrye
- Post #4
- Forum: Oracle: All versions
-
Display text field where a number field is in a view
not quite I don't think. I have a table with a field containing numbers in several columns(different numbers in each column) and a new table that contains a text field which has information that now needs to be where the numbers were displayed. I take each column from one of many tables. I think...- TFrye
- Post #3
- Forum: Oracle: All versions
-
Display text field where a number field is in a view
I am trying to modify a view to place one of several text fields from one table where a number field from another table would be. These are linked by an ID. Would this be possible with a subquery? other? Not sure if I'm clear enough, so when I pull the number field from table one, I want to see...- TFrye
- Thread
- Replies: 4
- Forum: Oracle: All versions
