Search
-
Category: (Oracle SQL)
Applies to: - MS Windows 7 Enterprise What? So I can ping the server the Oracle 11g database sits on. I've installed the Oracle 11g client tools and can connect using sqlplus. But if I tnsping ...Created on 04 March 2013 -
Category: (SQL)
What? So this is a quick article on how to install the mySQL add-on for Oracle SQL Developer v3.0.04. Why? I've used various mySQL administration tools to manage mySQL databases over the years, ...Created on 01 February 2013 -
Category: (Oracle SQL)
... data but the same length and the same type of data. Why? The joy of working with the plethora of applications out there result in me using MySQL, Oracle PL/SQL and Transact SQL in my day job. The ...Created on 22 August 2012 -
Category: (Oracle SQL)
What? How to use the randomization features of Oracle PL/SQL. Why? I've been tasked with writing a stored procedure that scrambles data for developers working with some of our databases containing ...Created on 21 August 2012 -
Category: (Oracle SQL)
Why? We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return ...Created on 24 January 2012 -
Category: (MS Reporting Services)
What? So I've spent a fun time googling and binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting ...Created on 19 January 2012 -
Category: (Oracle SQL)
Previously For a basic Oracle function, visit my article Basic Oracle Function Structure. For a more advanced version which uses cursors to work with SSRS, see my article Oracle Stored Procedures in ...Created on 16 January 2012 -
Category: (Oracle SQL)
What? I need to refer to how to create a function in Oracle PL/SQL and sites on the net just attempt to overcomplicate everything and have forgotten how it is to be new to Oracle. I need a function ...Created on 15 January 2012 -
Category: (SQL)
MySQL is just the best Unfortunately I make a living using Microsoft and Oracle products. I shouldn't say unfortunately as I don't see myself doing any other job and it beats daytime television any ...Created on 28 November 2011 -
Category: (MS Reporting Services)
... milliseconds it took for a report to execute... I decided to do a database level calculation using two datasets: -- Oracle 10g: DataSet1 -- your normal dataset query with an added field (ReportStartTime) SELECT field1, field2, TO_CHAR(systimestamp, ...Created on 17 November 2011 -
Category: (MS Reporting Services)
... have a database using Oracle 10g, and a SQL Server Reporting Services v2008 R2 environment. My use for this was when displaying an audit log displaying the oracle errors. Oracle Errors An Oracle ...Created on 10 November 2011 -
Category: (MS Reporting Services)
... Database Level AlphaNumeric Check You may have better ways to do this but here are my database level checks for alphanumeric values: -- ORACLE -- 0 if is alphanumeric, 1 or more if not alpha numeric. SELECT ...Created on 07 November 2011 -
Category: (MS Reporting Services)
What? We have a report in SQL Server Reporting Services 2008 R2 (SSRS) reading from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is ...Created on 04 November 2011 -
Category: (MS Reporting Services)
... my computer" and me replying "why would you want to do that?". Anyway, I was looking for something like the record separator in Oracle SQL*Plus where a row of data (blank or made of symbols) separates ...Created on 11 October 2011 -
Category: (MS Reporting Services)
... than Microsoft SSRS) that the existence of a photo depended on the status of a student in any case. This meant that I could use the same Oracle PL/SQL query they used to determine whether to display an ...Created on 19 September 2011 -
Category: (MS Reporting Services)
... add parameters to a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services. The Error ORA-00911: invalid character ORA-06512: at "SYS.DBMS_UTILITY", line ...Created on 02 September 2011 -
Category: (Oracle SQL)
Just a quick note as to something that worked for me. Taken from the Oracle forums @ https://forums.oracle.com/forums/thread.jspa?messageID=6861756 Situation I have one column of values that I've ...Created on 30 August 2011 -
Category: (MS Reporting Services)
... the executives. SQL query returns individual items while Excel allows drag and drop grouping/drilldown pivot tables. Have managed to get this working with SQL Server, Oracle and MySQL databases... Now ...Created on 24 August 2011 -
Category: (MS Reporting Services)
... Team Foundation Server (TFS VS2010) and connecting to an Oracle database (ie. "seamless integration because our setup is perfect and well thought through" not - note the DBMS is not hugely relevant for ...Created on 19 July 2011 -
Category: (General Articles)
... USE TEMPORARY TABLES in the case of some sites driven by a CMS). Nearly all Microsoft SQL Server web applications by default are vulnerable. Oracle's MySQL is not! If you are expecting a received form ...Created on 05 April 2011