|
JDBC Driver 8.1.6 Hello, Is it possible to download somewhere JDBC Driver 8.1.6 ? I would need to connect an old Oracle 7 database (The oldest one I found is 8.1.7) Thanks in advance. ... 5 Jul 2008 15:35
training materials needed I'm looking to see if anyone knows where I can get a used copy of the Oracle 8i to 10g training materials. Thanks, Oracle DBA ... 3 Jul 2008 21:45
Yellowfin Business Intelligence Release 4.0 Announced to Industry (CDT) Tue Jul 1, 2008 10:45am -- Announced today, the next release of Yellowfin Business Intelligence, 4.0 is scheduled for the end of July. Whilst most of the activity in the BI space has been busy with merger and acquisitions, Yellowfin has continued focussing its efforts to develop web Business Intelligence soft... 2 Jul 2008 07:47
pl/sql forcing RHS of = in where clause to be variable? This code will compare a column to a variable: declare myx number; begin select * from foo where x=myx; end; but suppose I have a variable with the same name as a column: declare x number; begin select * from foo where x=x; end; This will compare column x with column x, and not with the variable ... 1 Jul 2008 19:32
A little help with a query please Hi Guys, I need a little help putting a query together as I'm pulling my hair out. I'm getting two values, one from each table. Table 1 has a value and is in a 1 to many relationship with table 2 so what I'm getting back is something like this: Table1.Col1 Table2.Col1 A 1 A ... 26 Jun 2008 03:18
Exists a aggregate function (Oracle9) for varchar that generate a comma separated lsit Hello, The Firebird-Database 2.1 contains a LIST function http://www.firebirdsql.org/rlsnotes/Firebird-2.1-ReleaseNotes.pdf ____________________________ The LIST Function Oleg Loa Dmitry Yemanov (v.2.1) This function returns a string result with the concatenated non-NULL values from a group. It returns NU... 25 Jun 2008 15:00
how to copy engineer BOM from one organization to other organization Hello All In oracle ERP BOM, I want to Copy engingeer BOM from a organization to other organization, How can I do? ... 25 Jun 2008 04:43
HELP why will the statement update all the order_date to Sysdate? I am preparing for 1z0--047 now. There is one question I can not understand. View the Exhibit and examine the structure of the ORDERS and ORDER_ITEMS tables. Orders NAME NULL? TYPE order_id not null number(12) order_date date customer_id number(6) order_total number(8,2) Order_Items NAME NULL? ... 25 Jun 2008 03:42
unable to validate identity management realm Getting this message may mean that port 389 and port 636 are not available to the oracle installer. If tunneling over stunnel, be sure to allow both ports. ... 24 Jun 2008 17:28
Primary Keys and Valid_From / Valid_To Hello, I have basic questions on how one best organizes primary keys (and also foreign keys) and data integrity in an enviroment where one has valid_from / valid_to columns. Example: Say I have tables t_articles (article_id, article_name) and t_prices (article_id, currency, price). Then I would create a primar... 25 Jun 2008 05:44
passing CLOB in Stored Procedure as IN/OUT Hi, I am trying to get an answer for 'Is it required to create a temporary lob before doing an in/out operation on a lob being passed as in/out parameter in a stored-procedure?" I have seen some of the OCI samples, wherein temporary lob is created using OCILobCreateTemporary call and then we use OCILobWrite or... 24 Jun 2008 03:05
My Oracle DBA Blog. Hai all, I like to share my oracle DBA Blog. Visit it and check if it is useful for you. Thank you. http://arjudba.blogspot.com To know about How to get Oracle Error Message from Database or OS http://arjudba.blogspot.com/2008/06/how-to-get-oracle-error-message-from.html To know about How to Create and Use OMF... 24 Jun 2008 21:35
Conditional Union ? I am using 10g. Below is a crude example of what I am trying to do Procedure ( pi_input as interger ) is Cursor A is Select 'A' as Letter from Dual; Cursor B is Select 'A' as Letter from Dual; Union Select 'B' as Letter from Dual; If pi_input = 1 then Open A Else Open B End I... 20 Jun 2008 07:06
Trigger Invalid State What would cause a trigger to have an invalid state? Do triggers become invalid if you alter a table (but do not add/drop any columns that trigger references)? Do triggers become invalid if you add an index to a table? ... 19 Jun 2008 01:14
Can't Find localhost I have two problems I think are related. When I click go to oracle database from the desktop I get can not find page. If I change the ip adress to local host then it will open the oracle homepage. I also have an program that is using oracle as a background program when I go to open the program I get database not... 24 Jun 2008 16:27
Home Remodeling Improvement Locksmith Smart Home Moving & relocation Home Remodeling Improvement Locksmith Smart Home Moving & relocation Related Links: Moving Companies Movers http://www.movingcompanies.co.il http://movingcompanieslosangeles.blogspot.com/ http://movingcompaniescalifornia.blogspot.com http://longdistancemovingcompanies.blogspot.com http://crosscountrymovingcompan... 19 Jun 2008 01:14
bind parameter in existsnode function Got it... the two single quotes around the values in the @Value and @Name statements are escape characters too. This value //Key[@Value='True'] and //Key[@Name='Validation Status'] may be bound to a parameter just fine. ... 19 Jun 2008 01:14
REF CURSOR Hi, I may be answering my own question, but I want to make sure. Say I have a ref cursor that has a dynamic where clase, and in addition a bind variable that changes each time through the loop: OPEN cust_ref FOR 'SELECT customer_name, customer_address FROM customer WHERE customer_id = :v_customer... 19 Jun 2008 01:14
Los Angeles Locksmith Services, Lockout Rekey Install Locks and Keys Made Home Car Auto Los Angeles Locksmith Services, Lockout Rekey Install Locks and Keys Made Home Car Auto http://locksmithhome.com/default.aspx ... 19 Jun 2008 01:14
SUBSTR & INSTR Hi, I'm looking to parse an email. Say I have an email like this: johnjones(a)gmail.abc.def.ghi.com I basically want johnjones(a)gmail.abc.def.ghi in one variable and the .com in the other. If the email is this: jjones(a)amail.co The same, I basically want jjones(a)amail.co in one variable and the .com i... 19 Jun 2008 01:14 |