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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
sql question
Hi First I think date is a reserved word, I think you must change the name of the column (dat for example). I suppose occnt is the primary key og the table. To extract what you want, try : If occnt increases in the time: select a.occnt,a.segname,a.date,b.date - a.date from tabl a, tabl b...- porcher
- Post #3
- Forum: Oracle: All versions
-
Table field update
Hi, If I have understood your first problem (I'm french and my english is poor) you can try : update itm set siz_id = (select 'FULL' from dual where des like '%FULL%' union select 'KING from dual where des like '%KING%'...- porcher
- Post #2
- Forum: Oracle: All versions
-
Bring Full name with 3 initial letters
Hi, I suppose, you could try using 2 items at the same position in your canvas which are alternatively visible and enabled or not. A textitem of 3 characters length not based to get the 3 letters. A mandatory pop-list to display and choose the companies. You type the 3 letters in the text-item...- porcher
- Post #2
- Forum: Oracle: Enterprise Developer Suite
