Oracle: order by subquery missing right parenthesis
A quick note on how I got round one this one.
Knowledge base / Since 1999
Oracle PL/SQL Tutorials & Guides
Practical Oracle PL/SQL tutorials, troubleshooting notes and implementation guides from real projects.
Advanced search8 entries / Oracle PL/SQL
Clear filters
Fix Oracle Tnsping 3511 without Windows Registry
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 any oracle database, I get something along the lines of: Message 3511 not found; No message file for product=NETWORK, facility=TNSMessage 3512 not found; No message file f...
Data Randomization Function in Oracle PL/SQL
This article describes a function that will return random data based on a given value. The function intends to determine the data type and return data that is absolutely irrelevant to the original data but the same length and the same type of data.
DBMS Random Reference
How to use the randomization features of Oracle PL/SQL.
No rows returned in Oracle causes SP to fail
The problem is that if the student does not have a username but has an ID number, then the first query returns NO ROWS and then the second query errors and the whole stored procedure fails. The same problem happens when using these as a subquery which has an empty result set. Furthermore I am using this stored procedur...
Basic Oracle Stored Procedure Structure
I asked someone for a simple, easy and basic Oracle stored procedure as my MySQL and T-SQL stored procedures work slightly differently and are easier to pull off. After much umming and aah-ing, I have written this article as a note for me to demo a working stored procedure and how to use cursors. I'm told I need to use...
Basic Oracle Function Structure
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 in it's simplest form and if I want to torture my successors, I'll complicate the function myself. How? Functions are supposed t...
Oracle SQL - Convert given list (CSV) into Rows
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 suffixed a comma to but I want to display this as a rows in a table. This is for Oracle PL/SQL.
Loading more notes...
No more notes to load.