Search results for query: *

The situation is that we have an application that runs on different database servers such as Oracle, SQL Server, Interbase. In order to communicate with these databases we use SQL. First standard SQL and translate this to the SQL dialect that is needed. Our standard SQL includes the cast...

I'm using 8.0.6

What is wrong with the following: select cast(sysdate as varchar2(20)) from dual; Te error message i get is: select cast(sysdate as varchar2(20)) from dual * ORA-00905: missing keyword ?? please help (What i try to do is to cast several things (the above is just an...

i believe there is no such thing.... :-(

When exporting, the default values for certain parameters are operating-system specific. Specifically, the BUFFER parameter defaults to a value of 4K under Windows NT and the RECORDLENGTH parameter defaults to 2K. I don't know what these parameter defaults are for Solaris. But perhaps this has...

You can compare some databases at: http://www.mysql.com/information/crash-me.php maybe that can help you giving insight in the possibilities of the different databases.

What error(s) do you get?

Do you get an error message? (-:

Is the parameter a string? Looks like an integer to me, perhaps you should try using: query1.params[0].asInteger := 001; Hope this helps ::-)

What exactly are you trying to accomplish in the where-clause? And what do you mean with "clauses from the same dimension"? The WHERE clause is a filter that defines the conditions each row in the source tables must meet to qualify for the SELECT. Example: SELECT ...... FROM...

Hello, Can anybody tell me how to execute a procedure that you pass as a parameter? I have: type DBproc = procedure(); procedure DBUpdateProcedure(a_procedure: DBproc); begin {statements} a_procedure; end; procedure proc_a(); begin {statements} end; Then I would like to execute...

Have you considered using the datatype BLOB (binary large object)?

perhaps there is procedure thant constantly updates that table or some other process that does something with the table and never ands... check for infinite loops

Try to make use of the uniqueidentifier datatype and NEWID function: create table test( ID uniqueidentifier NOT NULL default NEWID(), ...

Have you tried export/import?

The view DBA_INDEXES contains descriptions for all indexes in the database. The field UNIQUENESS contains the status of the index: UNIQUE or NONUNIQUE hope this was wat you meant..

You might consider using Oracle Portal, an easy way to create webpages which can connect to an Oracle database: http://www.oracle.com/ip/develop/ids/index.html?portal.html (not sure if this is what you want but perhaps it might be helpful :-))

Perhaps you could try it without de double quotes around data2. Or replace the double quotes by single quotes. Not sure if it helps...

Oracle SQL doesn't know the keywords INNER JOIN... :-( At least the version i'm using (8.0.6) doesn't, and i doubt if other versions do. i think you have to rewrite your query.

Hi, Does anybody know a way to let Oracle treat an empty string as an empty string and not as a null value? ('' is null should be false.) Is there a setting or parameter i can use for this? For example in SQL server there is something like sp_dbcmptlevel. Thanx in advance!