Top "Plsql" questions

Is it possible to create user-defined exceptions and be able to change the SQLERRM? For example: DECLARE ex_custom EXCEPTION; …

I am using oracle 10g express edition. It has a nice ui for db developers. But i am facing some …

What is the string concatenation operator in Oracle SQL? Are there any "interesting" features I should be careful of? (This …

Is there a way in to just run a query once to select into a variable, considering that the query …

In the Oracle PL/SQL, how to escape single quote in a string ? I tried this way, it doesn't work. …

I am trying to write in a file stored in c:\ drive named vin1.txt and getting this error .Please …

In SQL Server we can use this: DECLARE @variable INT; SELECT @variable= mycolumn from myTable; How can I do the …

I'm comparing three Oracle schemas. I want to get a list of all the functions and procedures used in each …

Just can't figure out why it gives me ORA-06512 Error PROCEDURE PX(pNum INT,pIdM INT,pCv VARCHAR2,pSup FLOAT) …

I need to debug in pl/sql to figure times of procedures, I want to use: SELECT systimestamp FROM dual …