No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
16 Posted Topics
 | Hi, I am not sure what is the best solution for my problem so I really need your advice. Here it goes... I have an intranet setup at work and I am acessing a web app from let's say IP 192.168.0.40. The intranet computer from which I am accessing it …  |
| | Hi, I have a string like this: ABC_STRING_DEF_GHI_JKL. Where the "STRING" part is constant. I am trying to get its corresponding regex pattern. Something like %_STRING_%_%_% So far I managed to get to this point: SELECT 1 FROM DUAL WHERE REGEXP_LIKE('abc_STRING_def_ghi_jkl', '(^(\w[^_])+)_STRING_([^_]+)_([^_]+)_([^_]+)$'); It's not really working, so if you have …  |
| | Hi guys, I have the following problem select a.id, a.start_date, a.end_date, b.start_date, b.end_date from interval_1 a, interval_2 b where a.id = b.parent_id This will generate a solution like: 5 | 01-Apr-2012 08:30:00 | 01-Apr-2012 12:00:00 | 01-Apr-2012 09:30:00 | 01-Apr-2012 10:00:00 5 | 01-Apr-2012 08:30:00 | 01-Apr-2012 12:00:00 | 01-Apr-2012 … |
| | Hi, I have a problem with some resource files (i.e. .txt) which I have created in the project under let's say com/myapp/resources. I have a class created: com.myapp.util.MyClass which reference a file.txt located in resources folder: [CODE] MyClass.class.getResourceAsStream("../resources/file.txt"); [/CODE] The project is created in eclipse. After I export the project … |
| | Hi, Can you tell me what is the regular expression for a comma-separated list (in this case - IPs) ? My list looks like this: [CODE] 192.168.0.1, 10.%.23.100, %.46.%.1 [/CODE] So far I managed to create this: [CODE] ^[0-9%]{1,3}.[0-9%]{1,3}.[0-9%]{1,3}.[0-9%]{1,3}$ [/CODE] But I don't know how to specify a comma-separated list …  |
| | Hi, I have a select statement and I need to find a way to apply a filter to it: [CODE] select * from my_table where my_table.field_1 like :filter_item [/CODE] The real problem is that filter_item can be a string, a string that includes '%' or a comma-separated string that can … |
| | Hi, As the title states, I have a query that I use to concatenate all the rows into a single string and I use the XMLTransform method to accomplish that but I still need to add a new line separator within the XML string and so far I didn't find … |
| | Hi all, I have a problem in creating a matrix table using a PL SQL select query. The table should look like: [CODE] |---------------------------------------------------------| |--|-1-|-2-|-3-|-4-|-5-|-6-...-----------------------|100 | |---------------------------------------------------------| |A |A1 | A2| A3| A4| A5| A6|.........................|A100| |B |B1 | B2| B3| B4| B5| B6|.........................|B100| |.........................................................| |Z |Z1 | Z2| Z3| Z4|.................................|Z100| …  |
| | Re: ArrayList I think what you want can be accomplished by implementing some [URL="http://en.wikipedia.org/wiki/Trie"]trie[/URL] algorithm. Anyway, the ArrayList approach is wrong. |
| | JavaBeans is more like a coding style. A JavaBeans class would have to comply with the JavaBeans coding conventions: [URL="http://en.wikipedia.org/wiki/JavaBean"]A JavaBean is a Java Object that is serializable, has a nullary constructor, and allows access to properties using getter and setter methods.[/URL] |
| | Hy, I want to use some ExpandBar items in my UI, like those in SWT. I am currently using swing and unfortunately I did not find anything like this yet. So, do you know the class in swing that I can use ? ... or any other advice is greatly … |
| | Hy, I have a JPanel within a JFrame. In the menu bar of the frame I have a check button that would show/hide a toolbar within the JPanel. The toolbar is a JToolBar type and is added in the NORTH region of the layout. It occupies the whole region but … |
| | Hy, I have a .properties file with a key-value defined like this: [icode]my_property.value=text text text bla bla bla {0} qwerty {1}.[/icode] I need to know what class should I use if I want to read the value and insert parameters in {0} and {1}. In the past I used to … |
| | Hy, I have 4 combo-boxes and each one has a RefreshableValueHolder. If I change the value in one of them, I would like to automatically change contents of the others. I know I have to use the refresh() method of this class, but I cannot figure it out how. for … |
| | Hy, I have a select like: [CODE] select case when isnull(my_table.entry,0) > 0 and my_table.edate = convert(datetime,substring('2009-09-20',1,10)) THEN COUNT(*) else 0 END as no_entries_date1 ,case when isnull(my_table.entry,0) > 0 and my_table.edate = convert(datetime,substring('2009-09-21',1,10)) THEN COUNT(*) else 0 END as no_entries_date2 ,case when isnull(my_table.entry,0) > 0 and my_table.edate = convert(datetime,substring('2009-09-22',1,10)) THEN … |
| | Hy, I seek your help in solving the following problem: I have a select which returns columns like ( without count_same which I need to create by counting the same name): ID | NAME | no_items | count_same ----------------------------------------------------------- 1 | A | 1 | 2 2 | A | … |
The End.