Skip to main content

Stack Exchange

William Robertson

London, United Kingdom

http://oracle-wtf.blogspot.com

top accounts reputation activity subscriptions
Top Questions
Top Answers
69
Is it possible to output a SELECT statement from a PL/SQL block?
stackoverflow.com

34
What is the major difference between Varchar2 and char
stackoverflow.com

33
Escape ampersand in PL/SQL Developer
stackoverflow.com

32
cannot drop a system-generated sequence
stackoverflow.com

17
Currently Executing Procedure Name within the Package
stackoverflow.com

15
ORA-04063: view has errors
stackoverflow.com

15
Oracle search text of views
stackoverflow.com

14
Oracle show columns as row
stackoverflow.com

11
Oracle query all_tab_columns.data_default (type LONG)
stackoverflow.com

9
How to see real time SQL Monitor in PL/SQL developer?
stackoverflow.com

8
variable inside execute immediate
stackoverflow.com

8
Adding auto increment identity to existing table in oracle which is not empty
stackoverflow.com

8
Select string that has at least 2 alphabetic characters
stackoverflow.com

7
How to show output of dbms_output.put_line used in procedure in sqlplus?
stackoverflow.com

7
How to enable DBMS_OUTPUT in SQL Developer?
stackoverflow.com

6
Why am I receiving PLS-00103 when attempting to create this simple function?
stackoverflow.com

6
Oracle SQL - check missing indexes on SQL query
stackoverflow.com

6
Create materialised view without data
stackoverflow.com

6
In Oracle, how do I verify the object type used from an object type hierarchy?
stackoverflow.com

6
Can an Execute Immediate statement be nested inside another Execute Immediate
stackoverflow.com

5
How to output result of SELECT statement which is executed using native dynamic SQL?
stackoverflow.com

5
bind variable does not exist with dynamic SQL
stackoverflow.com

5
Wrong symbol inside replace function (PL/SQL, ORACLE)
stackoverflow.com

5
Oracle PL/SQL - Not a valid month error
stackoverflow.com

5
Oracle SQL Variable: SELECT with STRING list of values in an IN clause
stackoverflow.com

5
How to include double quotes around string result in sqlplus?
stackoverflow.com

5
Difference between count(1) and count(*) in oracle
stackoverflow.com

5
Using CTE function for insert into statement
stackoverflow.com

5
Which is better comparing with NULL or using NVL function?
stackoverflow.com

5
Why does SQL developer suggest a different format for a procedure that works?
dba.stackexchange.com

1 2