Oracle Database Forum

Hi experts of Oracle, I used Oracle for small queries, but now I have a task to create WEB-based report by getting data, summarying ( several counts, min and max) and re-formatting, where the data are from around 10 tables, each of them is > 10k records, some larger ones have > 1 million records. Using sql*plus to count all records in a...

Hi, I am trying to write a query in Oracle which I have not done before, and are having some difficulty getting my result. Please check my query and my results. select max(note.datetime), acgr.group_code, bank.local_acc_no, bank.short_name,

I need to compare two tables and print the differences(vbscript). Is there a quick sql way to do this. Otherwise I have a O(n^2) problem. What I am doing now is getting the data from the 2nd table first and then printing the 1st table and checking if the value matches the 2nd table. O(n^2) lets say I have ids Get Table 2 data

Is there a way to remove duplicate rows from a table that does not have a primary key leaving one copy of the row without comparing each column to each other as suggested by the code example below: delete from foo x where x.rowid <> ( select min(rowid) from foo y where y.primary key = x.primary key )

plz help

Which Oracle dictionary view gives information about the position of a column in a primary key? -- Posted via http://dbforums.com

Is it posible to take outputs of 9ids in a character mode ?please provide me solution -- Posted via http://dbforums.com

fils:=bfilename(directory => receiveDir,filename => fileName); dbms_lob.open(fils,dbms_lob.file_readonly); dbms_lob.createtemporary(xDoc,true); ---------------- the result is 353 dbms_output.put_line(dbms_lob.getlength(fils)); dbms_lob.loadfromfile(xDoc,fils,dbms_lob.getlength(fils)); -------------- the result is 176...

Hello, I'm writing a JSP application with an underlying Oracle Database. I have the following problem: the same SQL statement works fine in the SQL+ console and in SQL Navigator, but it fails in the application. The statement is this: INSERT INTO operatori (id_operatore, matr_operatore, cognome, nome, rif_utente, data_aggiornamento)...

Are there any characters or symbols that reserved keywords can be enclosed with in Oracle (9i) to prevent them from being interpreted as control statements or functions? MSSQL has this functionality with "". For example, in MSSQL, this statement returns an error : SELECT NameLine1 AS Name FROM database1 But this one does not :

Consider the following: (extracted from a .bat) sqlplus toto/titi ^ @%pdl%\islqz033 ^ '1 ' ^ 'aaa' ^ ' ' ^ 'zzz' ^ ....

I have a form that has several check boxes defaulting to checked. When the form loads, I have a cursor looping through a table that stores the name of the check boxes that need to be unchecked. The cursor will return the item's name into a varchar2 variable. I need to know now how to use that varchar2 variable to refer to the corresponding...

I am a developer contracted to a large utility company. This is my first job out of university. I have been working in IT for 2 years now. My work involves application development, maintenance, and support, Business Objects reporting and universe development. The DBA where I work will not give me the DBA role in the production instance,...

Just curious if anyone can suggest a good boor, link, or other reference for learning more about Object Oriented Databases. I have worked with them for a short time and very intrigued by the subject. Thank you in advance.

Does anybody have samples of how to use JDBC calls to work with a cursor on Oracle 8i? Can it even be done? I'd like to be able to do something like: String sql = "DECLARE CURSOR my_cursor FOR SELECT name,id FROM name_tbl"; statement.execute(sql); (executeQuery? executeUpdate?) .... while(...)

hi, i am working on a asp.net project with c# builder. the application should work with sql server and oracle. which one should i use for the database connections. odbc or bdp. odbcconnection class works faster than bdpconnection.

Hi, I'm using Oracle 9i with Spatial to store geographical data. It has only hundreds of features with very minimal veritices. I use OO4O (Oracle InProc) as component to access the oracle server from Visual Basic. It seems that it takes more time to retrieve the information stored. Some time back I, used same kind of data in Oracle 8...

Hello, I'm in the process of tuning our auditing procedures. At present we have one table, mp_event_audits which holds username, date/time, change type, data changed etc columns - DEV> desc mp_event_audits Name Null? Type ------------------------------- -------- ---- EA_ID NOT NULL NUMBER(8)

What is the datatype to be used for Primary Key columns for most optimised access given that - There will be a single column primary key only - The values will only be integers (but as strings) at least 12 digits (characters) long - all positions will be occupied (no leading 0's) - Tables may have upto 1m+ rows

Hi, Console is working fine but Performance Manager shows error vtd-0123 (error connecting to ..) and VTD-10000 error creating message, unsupported character encoding DUTCH_THE NETHERLANDS.WE8DEC. which expert can help me out?

Does anyone know of any projects coming up for an Oracle DBA/Project Manager with several years of experience? If so, could you maybe give me a contact so I could submit a resume? Thanks in advance.

I searched in the Oracle documents what count (1) meant and I could not find an answer. Can some one explain what Oracle does internally when use count (1) VS count (*). Thank you very much in advance! We use Oracle 9i.

Hi, We are trying to run Oracle Advanced Queueing with OC4J 9 and Oracle 9.2.0.2. database. We are getting the following problem: oracle.jms.AQjmsException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'AQ$_JMS_ENQUEUE_TEXT_MESSAGE' ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Hi, Where can I find free e-books for Oracle Sql Optimalization? Thanks in advance, ViBart

Hi All, I'm looking for a third party utility/tool/api that would allow me to store HTML/MS word/PDF documents in SQL Server and Oracle after encrypting them and then allow me to do a full text search on them. Any suggestions? TIA, Sanjay