This is one of those situations where you get an unhelpful error message back from Oracle. My situation is as follows: I\'m dynamically creating a view in PL/SQL. I build a string and use EXECUTE IM
Is it possible to add a ORDER SIBLINGS BY fieldName inside a view? I\'ve got a hierarchical structure, in which I\'m successfully using a query with the CONNECT BY feature.
I need your help with this error: ORA-00907 on Check C开发者_开发问答ONSTRAINT Query: CREATE TABLE S_NEWS.T_UTILISATEUR_USR (
SELECT DISTINCT( EMP.EMPLOYEEID ), EMP.EMPLOYEECODE, EMP.EMPLOYEENAME, EMP.HOMEADDRESS, DESIG.DESIGNATIONNAME
I am unfortunately working on an old VB6 app that is constructing a huge (11902 characters) ad-hoc SQL statement which is then passed to the GetRecordSet() method of my DBConnection.The app is using t
I am trying to create table (orderdetails2); the table has two FKs and a PKs on the two FK columns.Here is my code:
When using cast(collect(...)), how do I order the result? I have a function called GetStringForTable, defined like this:
I use Hibernate 3.5.3, and Oracle 10g database I have bean with following relation @OneToMany @JoinTable(name=\"dispenser_accounts\",
Why does Oracle 10 R2 not allow use of notational parameters while calling functions in insert statements ?
I\'m trying to UNION the results of two queries. But I\'m getting the following error: Error at Command Line:9 Column:81