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...
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...
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 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...
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
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 :-))
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!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.