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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Creating Initials from names
I have a field in my screen called First Name and another field called Initials. I need to make it so that when I enter a first name, the initials field populates with the initals of however many first names there are. For example, Tom Green Jones should come up as T G (assuming Jones is a...- ironic100
- Thread
- Replies: 2
- Forum: Oracle: Enterprise Developer Suite
-
SQL timing of results
Hi Guys, this query works fine: SELECT pol.policy_no, pl.planno, pl.plan_name, NVL(MAX(pol.pol_stat),' '), NVL(MAX(d.description),' ') stat_descn, NVL(SUM(ua.units_allocated * fv.bid_price), 0) pol_value, NVL(MAX(psc.fees), 0) penalty, c.description...- ironic100
- Thread
- Replies: 0
- Forum: Oracle: Reports
-
Page Break
Does anyone know how to create a page break when you create a form-letter in reports 6i? Thanks- ironic100
- Thread
- Replies: 1
- Forum: Oracle: Reports
-
SQL TO_DATE/TO_CHAR query
I am trying to select records where the parameter date is greater than/equal to a record in PA_TRANS. I want to have a date and time comparison to the records in the table. It works for only for the date portion i.e. dd/mmm/rrrr as in below: SELECT t.SITENO, t.PA_TRANSNO, t.PA_TR_COMM...- ironic100
- Thread
- Replies: 3
- Forum: Oracle: Reports
