info@s490up # gcc -std=gnu99 -o bla -g -O2 -DSunOS=1 -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES= -I/usr/include/libxml2 -I/u/app/oracle/product/11.2/rdbms/demo -I/u/app/oracle/product/11.2/rdbms/public -I/u/app/oracle/product/11.2/rdbms/demo -I/u/app/oracle/product/11.2/rdbms/public blabla.c -lclntsh -lrt -lresolv -lnsl -lsocket -lm -lpthread...
Will the recent acquisition from Oracle influence the Java Programming language at all? I know the whole bit about Oracle and Google's Android Platform, but what about purely the language itself? I was reading that the father of Java, Gosling left Sun because, well Wikipedia quoted this from him regarding his reason for leaving: "Just a...
SELECT * FROM `your_table` LIMIT 0, 10 ->This will display the first 1,2,3,4,5,6,7,8,9,10 SELECT * FROM `your_table` LIMIT 5, 5 ->This will show records 6, 7, 8, 9, 10 I want to Show data 2,3,4,5,6,7,8,9,10,1 and next day 3,4,5,6,7,8,9,10,1,2 day after next day 4,5,6,7,8,9,10,1,2,3 IS IT POSSIBLE with out updating any data o...
hello, I am developing a J2EE application that manages hundreds of jars (saved and loaded on the fly) to manage them i have two options: create a directory on the server that contains all the jars save the jar as a LOB in an oracle 10g database Could you help me to choose the best solution?What are the benefits of each option? than...
How to display a value as follows in oracle: 99.99 as 99.9900, 99.9 as 99.9000, 9.99 as 9.9900, 99 as 99.0000 All cases should be satisfied.. Please help... ...
Hello, I am trying to add an entry to an Oracle table which has a date field. So far, I've only been able to do it like this: $createdDate = $entry->createdDate->toString('yyyy-MM-dd'); $data = array( 'ID' => $entry->id, 'STATE' => $entry->state, 'CREATED_DATE' => new Zend_Db_Expr("to_date('$createdDate', 'YYYY-MM-D...
I am trying to extract an oracle column default value from user_tab_columns, using .Net. It's data type is long, and when I read it using IDataReader i get an empty string. How do I get it's data? select column_name,data_default from user_tab_columns where column_name='XXX' ...
Hi there, Simple one. I´m a bit of a newvbie with PLSql and oracle's error messages are never too helpful. I want to do a simple trigger to update a column with the current date i.e. 'modified date' column of a table. Getting an odd error though. The idea is simple create table test1 (tcol varchar2(255), tcol2 varchar2(255)) CREATE ...
In my Oracle database, I have a table called Customers. There are fields for name, zip, city etc., but there are also fields for invoicename, invoicezip and invoicecity. For some records the invoicespecific fields are not set, and in that case the invoice method should use the information from name, zip and city. I use the following que...
I have a JPQL query that works fine with MySQL and SQL Server. But with Oracle it fails with ORA-00932: inconsistent datatypes: expected - got CLOB. The reason seems to be that Oracle does not support ORDER BY with CLOB columns. Is there any JPQL work around for this? ...
Hi. Is there a way to transparently translate MySQL queries to oracle back-end? I have an application written to use MySQL but I want data to be stored in oracle. Is there a way to avoid code modification and use Oracle as back-end database? ...
After doing DEFINE_EDITOR=vi . I wrote SQL > edit sample.sql This is being stored in Jagan/Documents by default. But i want this to be stored in Jagan/Documents/plsql. Can anybody tell how to do this.. ...
We are using DriverManagerDataSource from the Spring framework (version 2.5) to pool connections to Oracle. However, it seems that these connections don't have any timeout defined - yesterday, after emergency database restart, we had a thread hanging on a socket read inside the database connection. How can I set the timeout, to say 10 mi...
I'm doing some bulk migration of a large Oracle database. The first step of this involves renaming a whole load of tables as a preparation for dropping them later (but I need to keep the data in them around for now). Any foreign key constraints on them need to be dropped - they shouldn't be connected to the rest of the database at all. I...
Hi, I've been trying to create a PLSQL package that will post into SharePoint through its web services. I've tried doing this using C# and it kind of worked, yet with PLSQL It seems like am having problem authenticating to Sharepoint since it uses Kerberos & NTLM. declare soap_request varchar2(30000); soap_respond varchar2(30000); ht...
When we use sqlldr to populate an NCLOB column with a text value from a lob file and the character is not in the regular ASCII code range sqlldr bombs. Seemingly relevant sections from log file: EXTENSIONDATA DERIVED ***** VARCHARC Maximum field length is -2147483639 Static LOBFIL...
My understanding of JDBC is that it automatically sets the Oracle NLS_LANGUAGE/NLS_TERRITORY session parameters based on the default Locale of the JVM. This is handy for a stand-alone swing app, but seems useless for a java webapp. The only solution I can come up with is to specifically set the session parameters right before actually do...
Okay, I'm new to blackberry development and I was wondering if anyone could give me a list of database options available for blackberry applications? What do developer's "normally" do when faced with the requirement of utilizing a server for their blackberry applications? Is there any one specific database that is used for a majority of ...
I have an Oracle database with a dodgy design: many tables have same schema. They're pieces from a huge table, and time by time, new tables will be created with specific rows. Of course, I'm not authorized to access the huge table, only the small ones. How can I query against these tables, effectively? Many thanks in advance. ...
I am trying to create an application in java which pulls out records from the database and maps it to objects. It does that without knowing what the schema of the database looks like. All i want to do is fetch all rows from all tables and store them somewhere. There could be a thousand tables with thousands of records each. The applicati...