oracle RowType issue Hi All, Im new to Oracle. I have a Rowtype and i want to Loop through that Rowtype without mentioning the Column name. My code as below : declare empRowType Emp%ROWTYPE; begin SELECT * INTO empRowType FROM Emp WHERE Emp_id = 101 ; for x in ( select column_name from user_ta... 20 Jan 2010 16:16
copying tables from one database to another How do people copy tables from one database to another? The docs say that imp/exp are deprecated. I tried the copy command in sqlplus but it destroys the indexes and default attributes! Arrgghh. I have a feeling sql loader can be used to do the import but how do I do the export first? Obviously any export will ha... 20 Jan 2010 09:29
Oracle 10g or 11g certification? hi, thinking about going the OCP exam but not sure if it's best to go for 10g or 11g? we use 10g at work but not sure how widespread 11g is yet - obviously cost implications if I have to upgrade later to 11g but interested in what peoples thoughts are on which one to go for? thanks in advance harry ... 20 Jan 2010 14:00
Oracle Warehouse Automation See why to go for a Warehouse Automation http://www.iwarelogic.com/blog/warehouse-automation-301 Also what oracle offers for the same. ... 12 Jan 2010 12:55
Pro*cobol Spurious nulls being updated into database I have a strange issue which I will probably report as a bug but thought i would pass by you guys 1st. I have an update statement EXEC SQL UPDATE HARDVER SET HAR_IMEPRT=NVL(RTRIM(:HAR-IMEPRT),' ') ,HAR_IMETER=NVL(RTRIM(:HAR-IMETER),' ') ,HAR_WINDOW=NVL(RTRIM(:HAR-WINDOW),' ') ,HAR_TIPTER=NVL(RTRIM(:HAR-TIPT... 10 Jan 2010 10:45
Global Warming and what you can do to against it ... wrote: Dear All, As you know global warming Explain why the average temperature did not rise the last 12 years -- Regards, Frank van Bortel ... 8 Jan 2010 09:22
Siebel 8.0 Core Consultant Exam Sample Questions Set IV Exam Code: IZ0-202 Dear Readers, Thanks for your overwhelming response to this sample question paper series. In continuation of same we are back with Siebel 8.0 Consultant Certified Expert Exam Sample Questions Set IV (Exam Code: IZ0-202) http://www.iwarelogic.com/blog/siebel-8-0-core-consultant-exam-sample-questions-set-iv-exam... 4 Jan 2010 04:49
Oracle 10g Lite & .NET I'm trying to create an Oracle 10g Lite database using the .NET DataAccess components packaged with the Mobile SDK. I have been able to successfully create the files using the Oracle.DataAccess.Lite.OracleEngine.CreateDatabase(string DSN, string dbName) method, but this has the nice little requirement of using a ... 29 Dec 2009 15:14
Excluding values with numbers Greetings, I am currently using Oracle9i Enterprise Edition Release 9.2.0.4.0. I have a table with following data Table 1 (Sample data) a12345 A123423 g13452 G452323 h34423 r34323 b23232 n232323 I am currently using this as a subquery in one of the query. As per a new request I have to now exclude al... 3 Jan 2010 14:56
oracle and database ebooks I am searching for the best ebooks for : 1-database systems 2-oracle 11 sql/pl 3-oracle 11 developer Please recommend them for me . Also I need to know the codes of those oracle tests : oracle 11 developer , oracle 11 sql/pl. Thanks in advance for your help. Thanks ... 6 Jan 2010 08:28 |