Posts by debasisdas

If oracle Express in stalled the default database name will be XE only.

On an average 60 Hrs per week.

I really do not understand what is Oracle SQL Server,(there is no such thing) are you talking about Oracle SQL developer. If it is, you do not need Oracle SQL developer to create a database. It can be configured during installation of oracle itself.

And i really do not know why you need to use XAMMP to work with Oracle.

1. accept login credential from UI.
2. check the same in the DB. (select count(*) from user_table where user_id = "user_id" and password = "password" ). ensure user_id is unique/priamy key.
3. if it matches (if count = 1 then)proceed further
4. else re-prompt for credential.

You need to go through this and this for beginners.

You need not install Oracle SQL Developer to use it.

Just copy the installation set and invoke the application by ckicking on the EXE.

What exactly you mean by duplicate records.

Duplicate based on what ?

You need to write HIERARCHICAL QUERY by using the following.

The START WITH...CONNECT BY clause.
The PRIOR operator.
The LEVEL pseudocolumn.

So what do you expect from us here.

You may be interested in this also.

Try the following SQL command.

PURGE RECYCLEBIN;

Please post the code that you are working on, to understand the exact requirement and come up with some solutions.

Here is a completely different approach, the code is in form of a Oracle procedure . You need to call the Oracle procedure in VB to achieve the same.

If the data format is consistent and is being stored in a database, you can filter it out at DB level based on the availability of colon (:) and period (.) in the string. But if it not consistent accross it will populate other data also.

for example

If you have some data like
ho.ney.be.e:2090
it will also be populated in the control.

Simple because it matches the pattern even though it is not a valid Ip address and port number combination.

What is the source of data, is it stored in a database ?

Are these samples IP addresses and port numbers ?

You need to polulate the controls from the recordset before closing it. Of course you have to check for BOF and EOF.

something like this.
If rsSearch.EOF <> True And rsSearch.BOF <> True Then
Text1.Text = rsSearch.Fields(0)

You need to include a CASE statement and a group by clause.

The code is perfectly fine, but what i understand from the question is the OP is aking for a wave file not how to play it. OP needs a file not the code to open it.