Top "Oracle11g" questions

Oracle is an Object-relational Database Management System (ORDBMS) created by Oracle Corporation.

Oracle pl-sql escape character (for a " ' ")

When I am trying to execute INSERT statement in oracle, I got SQL Error: ORA-00917: missing comma error because there …

oracle escaping oracle11g
How can I select from list of values in Oracle

I am referring to this stackoverflow answer: How can I select from list of values in SQL Server How could …

sql oracle select oracle11g
Could not load file or assembly "Oracle.DataAccess" or one of its dependencies

I am trying to run this web application. I keep getting this error "Could not load file or assembly "Oracle.…

visual-studio-2010 iis oracle11g
How to increase buffer size in Oracle SQL Developer to view all records?

How to increase buffer size in Oracle SQL Developer to view all records (there seems to be a certain limit …

sql oracle oracle11g oracle-sqldeveloper
How to echo text during SQL script execution in SQLPLUS

I have a batch file which runs a SQL script in sqlplus and sends the output to a log file: …

sql oracle11g sqlplus
Difference between number and integer datatype in oracle dictionary views

I used oracle dictionary views to find out column differences if any between two schema's. While syncing data type discrepancies …

oracle11g
How to set default value for column of new created table from select statement in 11g

I create a table in Oracle 11g with the default value for one of the columns. Syntax is: create table …

oracle oracle11g
PLS-00428: an INTO clause is expected in this SELECT statement

I am wanting to store a Rownum as a variable rather than use a costly Join. I need to get …

sql oracle plsql oracle11g
Extract number from string with Oracle function

I need to create an Oracle DB function that takes a string as parameter. The string contains letters and numbers. …

sql oracle oracle11g oracle-sqldeveloper sqltools
How to find available directory objects on Oracle 11g system?

I assume this information is available in Oracle metadata tables, but where exactly ? I need the directory object for BFILENAME …

oracle metadata oracle11g