Posts

Showing posts from January, 2012

How to Fix Database Column Alias name problem in Microsoft Excel

Image
Database Column Alias name caused the query to fail problem when try to Microsoft Query to return data from some third-party database into Microsoft Excel. The error message that you receive depends on the data source that you use. I am using Oracle Database 10g and because the use of column alias name Microsoft Query generate ‘ORA-00923: FROM keyword not found where expected’ error.




A supported hotfix is available from Microsoft and this hotfix is prebuilt in Microsoft Excel 2007. In the following steps I will show you how to enable hotfix for Excel 2007.

1) Exit all office programs
2) Click start, and then click run
3) In the open box, type regedit and then click ok
4) Locate, and then click to select the following registry subkey: HEKY_CURRENT_USER\Software\Microsoft\Office\12.0\query\options
5) After you select the subkey that is specified in step 4, point to New on the Edit menu, and then click DWORD value.
6) Type AllowAlias, and then press ENTER.
7) Reghit-click AllowAlias, and then cl…

How to fetch Data from Oracle Database to Microsoft Excel

Image
Recently my Team Lead gave me the task to fetching the data from Oracle Database in Microsoft Excel through Microsoft Query. After spending some time in R&D I was successfully completed this task and now I am sharing my knowledge and steps to fetch data from Oracle Database to Microsoft Excel.



1) From the Data tab in MS Excel, click From Other Source icon

2) From Choose Data Source window Select New Data Source and click OK

3) From Create New Data Source window give the Data Source Name and select Microsoft ODBC for Oracle as Driver from the list.

4) Enter Databse User Name, Password and Server
5) Select Oracle Databsae tables and its Columns from Query Wizard-Choose Columns




6) Filter the data to specify which rows to include in your query.





7) Specify how you want your data sorted.
8) Select Retrun data to Microsoft Office Excel9) From Import Data window - Select how you want to view this data in your workbook


10) Extracted Data

Overview of 1Z1-151 Oracle Fusion Middleware 11g Build Applications with Oracle Forms Exam

Today I was appeared in the beta exam of 1Z1-151 Oracle Fusion Middleware 11g: Build Applications with Oracle Forms. The exam was too lengthy and in the duration of 3 hours total 282 questions were given. I was hardly attempt 150 questions. Some of the questions that were asked in the Oracle Fusion Middleware 1Z1-151 exam are given below.
Why would you want to create a control block in a form module?Some forms that you wrote have been through part of the testing cycle. One of the testers has reported encountering a Navigation Trap in your form. Which scenario could have caused the Navigation Trap?Which built-in should be used to invoke one form from another form so that you can navigate between the two?Which built-in always starts a new Forms run-time session when you use it to invoke another form?Which built-in can you use to programmatically set the validation status for all records in a block?You are creating an application on a Window PC, and you want to test a form. What are two w…

Use of Format Trigger in Oracle Report Builder

Image
Format Trigger in Oracle Report Builder is a PL/SQL function. This trigger is going to fire before an object is printed in report output. It returns Boolean value, if value is true then goes to print and if value is false then donot print.

Top 20 Oracle Most Popular Technology Articles of 2011