Search results for query: *

Issue an Oracle query (recordset): 'select user from dual;' (User is an Oracle function, not Access).

Something like (input mask) >LA09\ 0LL Based on the four possible postcode you mentioned.

Could you rephrase your question and example. There are too many things to explain. Is this your example ? : select a.1, b.1 from a, b, c where a.1 = b.1 (+) and a.1 = c.1 and b.1 = 1 Post some data to show what you think goes wrong. Gr. Bart.

Use a sequence id (fill with an Oracle sequence) for the primary key of the history table (you may add this as a normal column, but it's an excellent PK). Timestamps are not reliable because it's precision goes up to seconds only. It is very imaginary (although it depends on the type of...

Use explicit fetch, implicit FOR..LOOP is not allowed. This is from the manual: Fetching from a Cursor Variable The FETCH statement retrieves rows from the result set of a multi-row query. Here is the syntax: FETCH {cursor_variable_name | :host_cursor_variable_name} [BULK COLLECT] INTO...

This has something to do with default dateformats. ALWAYS explicitly format (and unformat) dates. So use TO_CHAR (sysdate, 'YYYYMMDD') to build your (varchar2)parameter and use TO_DATE (my_date, 'YYYYMMDD') to get it back as a date. This will improve portability of your code to databases with...

Such as this? This has not been tested, there may be typing mistakes. declare l_cmd varchar2(256); --Increase size as needed begin l_cmd := 'UPDATE TEST SET ' if fieldC is not null then l_cmd := l_cmd||'fieldC = '''||fieldC||''''; end if; if fieldD is not null then if...

There is no easy way for the stored procedure solution. Look at http://p2p.wrox.com/archive/vbpro_databases/2001-03/43.asp Any way, updating directly via ASP will result in a more maintainable and easy to read application. That's often more important than unreadable and difficult to understand...