Thursday, November 27, 2014
   
Text Size
Login

Search

Total: 26 results found.

Search for:
Search Only:

Page 1 of 2

  1. Category: (SQL)

    ... I am pretending to select rows from a table called `STUDENTS`. Oracle PL/SQL Looking for abnormal data, note the circumflex to exclude the clean alphanumeric rows: SELECT * FROM STUDENTS WHERE ...
    Created on 09 January 2014
  2. Category: (Oracle PL/SQL)

    ... the latest by ordering the dataset of the subquery. In T-SQL and MySQL, this is not so much of an issue. I get this error when having to use an ORDER BY clause in a subquery within an Oracle 11g ...
    Created on 05 December 2013
  3. Category: (SQL)

    ... Expressions With Oracle Database ...
    Created on 28 October 2013
  4. Category: (SQL)

    ... myColumn -- Reorder a column ALTER TABLE myTable MODIFY COLUMN misplacedColumn AFTER otherColumn; MySQL and Oracle PL/SQL ALTER TABLE myTable MODIFY myColumn myDataType Microsoft ...
    Created on 24 July 2013
  5. Category: (Oracle PL/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
  6. 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
  7. Category: (Oracle PL/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
  8. Category: (Oracle PL/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
  9. Category: (Oracle PL/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
  10. 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
  11. Category: (Oracle PL/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
  12. Category: (Oracle PL/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
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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

Latest Posts