Search results for query: *

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...

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...

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!

Does anybody know if it is possible to find the name of the column over which a primary key is defined? With the use of systemtables i can find the names of tables which have a primary key: SELECT sysobjects.name FROM sysobjects, sysconstraints WHERE sysobjects.xtype = 'U' AND...

What is the record length you have to specify when you are on a OS different from Windows NT and you want to import a dump file you exported on Windows NT? In other words: what is the default record length on Windows NT? Thanks in advance.

when trying to execute the query SELECT * FROM A, B WHERE A.id = B.idA AND (SELECT count(*) FROM A WHERE A.id=B.idA) < 2 i get the message ORA-00936: missing expression. And the point where the exception is given is the SELECT statement in the subquery. Does anybody know why i get this...

Does anybody have a clue what is wrong with the following SQL statement? SELECT cast('02-17-2001' AS date) ...rest of statement... The error message i get is &quot;Key violation. [oracle][odbc][ora]ORA-00905: missing keyword&quot;. Thanx!

Does anybody know what de difference between Oracle8 on Windows NT and Oracle8 on Solaris are or where I can find information about this subject? Is the Enterprise Manager available on Solaris? Can I import data on Solaris from a file I exported on Windows? Thanx in advance!

Hi, I would like to get a list of all forms in my application. What is the best way to retrieve this list? I know that with application.components I get the components owned by the application, but i have some forms not owned by the application. These forms should be on my list too. Thanks...