Search - Joel Lipman .Com

1. Oracle PL/SQL: / Category /; Created on 05 March 2020
2. Oracle: order by subquery missing right parenthesis: / 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. Fix Oracle Tnsping 3511 without Windows Registry: / 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
4. Access MySQL databases using Oracle SQL Developer: / MySQL /; 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
5. Data Randomization Function in Oracle PL/SQL: / 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
6. No rows returned in Oracle causes SP to fail: / 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
7. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server 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
8. Basic Oracle Stored Procedure Structure: / 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
9. Basic Oracle Function Structure: / 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
10. MySQL Group_concat equivalent in T-SQL and Oracle: / Databases /; 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 day. ...; Created on 28 November 2011
11. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevel: / SQL Server 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
12. SSRS Parameters in Oracle Stored Procedure: / SQL Server 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 114 ...; Created on 02 September 2011
13. Oracle SQL - Convert given list (CSV) into Rows: / Oracle PL/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
14. MySQL Oracle equivalents: / Databases /; The title of this article implies something rather odd and upcoming considering that Sun Microsystems bought MySQL and Oracle bought Sun. But in fact, this is just a quick list of some regular commands ...; Created on 27 September 2010
15. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... data. And yes, the part that took me about 8 hours and the key point above is to replace the ampersand with its unicode equivalent. I consider myself familiar with Transact-SQL, Oracle PL/SQL and ...; Created on 28 August 2020
16. Regular Expressions in SQL: / Databases /; ... 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
17. Regular Expression Basic Usage Examples: / Web-Development /; What? A quick reminder on basic regular expressions. Match Any Character — Dot The dot operator '.' matches any single character in the current character set. For example, to find the ...; Created on 28 October 2013
18. Modifying columns in a table: / Databases /; ... 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
19. DBMS Random Reference: / 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
20. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server 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