Hi all, I have return a web services which return "Instances" from a datamining api. Now the problem is obvious web services by default cannot handle "Instances" as return type. What should be my approach. Or I may have to say User defined data types, please guide me of any documentation where I can implement this. //////////////...
Hi, I got a problem when using OleDbConnection in combination with an oracle Database. When i request the schema of an existing Table using the OleDbConnection's FillSchema Method the result seems to get cached somehow. To reproduce the Problem you need to do the followin steps: create a table named cachetest with one column Request ...
table = mytable temp col = tempcol col = mycol currently contains 5000 rows various values from 99999.99999 to 0.00001 I need to keep the data create a script to create a temp column,round the values to 7,3 update mycol to a null value, modify my column from 10,5 to 7,3 return the data to mycol, drop the temp column. Job done. so far...
What does oracleClose() and oracleCloseQuery() do in sqlj.runtime.ExecutionContext.OracleContext. Since we upgraded jdbc driver jar to ojdbc5.jar with the oracleClose() in the finally block we get the below exception when using resultset.next() and not with oracleCloseQuery(). Is it safe to use oracleCloseQuery(). The database is Oracl...
Can i user ODAC or another free provider in EF4? ...
How to know which objects (tables/views/etc) uses a certain table? I have to replace my table PRICE. So, is there something like? select system.dependencies from PRICE ...
I have two tables. The structure of tables is as follows. TRAILERS_INVENTORY TRAILER_TYPE VARCHAR2(100) TRAILER_LENGTH INT TRAILER_WIDTH INT YEAR_OF_MANUFACTURE INT NEW_INVENTORY NEW_INVENTORY_TYPE_ID INT, TRAILER_TYPE VARCHAR2(100), TRAILER_LENGTH INT, TRAILER_WIDTH INT, YEAR_OF_MANUFACTURE INT I want to list all of the trailer...
Can anyone plz give example how functional dependencies are being implemented in sql. I have read somewhere that functional dependencies can be implemented using assertions. But how these are implemented can anyone give an example for it. Moreover how to implement FD's in Oracle coz, assertions can't be created in oracle. ...
I finished my meeting site design and now I should create database. But I am not sure which method to use.I am using Apache, PHP and MySQL. I have users, each user has input and output mail box and each user has a friends list. This is the basic scenario. And here I have three questions. For in box and out box should I create a new tab...
Can any body tell me what this exception means, its confusing because I tried all possible ways to change the path of the keystore.. doesn't work. Environment: ORACLE database server, configuring SSL Exception in thread "main" java.sql.SQLException: Io exception: java.lang.RuntimeException: Unexpected error: java.security.InvalidAlgo...
Env: Oracle version: Release 10.2.0.1.0 Server: Windows XP Language in oracle: select userenv('language') from dual; Result: CHINESE_CHINA.AL32UTF8 Table structure: PARTY_ID NVARCHAR2(50) PARTY_TYPE NVARCHAR2(50) Data in the table: PARTY_ID | PARTY_TYPE ---------+----------- BEST | C WILL | C SQL1: SELECT * FROM ...
I have two web applications: a based in web pl/sql and another in jsp My login web page is in pl/sql from this application to access through a link on my jsp page. I want to keep the user session connected in web pl/sql and then I take it in my application jsp. In jsp for set and get values session I use: HttpSession session = request.g...
For example: I want a data type called season (= { spring, summer, fall, winter} ...
I need to display the count of present status for a particular name Select count(*) from employees where status='Present'; This query returns me entire present count. What should I do to get status for a particular name? ...
I have got 2 questions. Is there any way to load data to a table in Oracle from a .txt file other than using SQL loader? How to unload data from the table to a text file? Someone please help me. Thanks in advance. ...
I need to create a flat file and push information into it from oracle database using JSP. I require a sample code. Help will be appreciated. ...
Can any one please help with select script? desired outcome TABLENAME, ATTRIBUTE, NULLABLE, DATATYPE, LENGTH, DESC, HELP_TEXT having count(datadic.ATTRIBUTE)>1 (because these can only be unique) and is not unique to any other attribute (not include DDKEY and SerNo) with the same value. i.e TABLE2 ADDR4 NULL VARCHAR2 15 Unit ...
what is sqlserver T-SQL equivalent to oracles "show all" listing the set parms on the DB? ...
Hi, I'm trying to configure a seqhilo generator for a Hibernate application on Oracle. <id name="idTest" type="int"> <column name="ID_TEST" precision="6" scale="0" /> <generator class="seqhilo"> <param name="sequence">S_TEST</param> <param name="max_lo">1000</param> </generator> </id> I created...
Hi, I plan to delete data from a table, i would like to know how many and which tables have a foreign key reference to this particular table in Oracle. As i will have to set the foreign keys to null. I would like to know list of all tables which have a FK to this particular table. ...