Top "Oracle" questions

Error using oracle.dataaccess.dll

I have a web application which uses Oracle.DataAccess.dll to communicate with an Oracle db. The web application deployed …

.net windows oracle 64-bit odp.net

Header formatting while spooling a csv file in sqlplus

I am required to spool a csv from a table in Oracle, using sqlplus. Following is the format required: "HOST_…

oracle header sqlplus spool

Drop all tables sql developer

I have tables that names start with "TBL_*", but I can not drop all of them by single command. how …

oracle oracle-sqldeveloper drop-table

Why can't I see Tables/Sequences in Toad's Schema Browser?

Using Toad 9.7.2 against a network Oracle DB (10g) I can't see any objects in the schema browser using the account …

oracle privileges toad

Execute procedure in a trigger

Is it possible to execute a stored procedure inside a trigger? Thank you

sql oracle stored-procedures execute

How to escape <, >, and & characters to html entities in Oracle PL/SQL

I need to send HTML emails directly from oracle PL/SQL package. This works almost fine. I have problem with …

html oracle plsql escaping html-escape-characters

How do I setup Oracle ODBC drivers on RHEL 6/Linux

I need to setup Oracle ODBC drivers on RHEL 6 to connect to an Oracle data source residing on a remote …

linux oracle odbc drivers rhel6

what is the maximum value of MAXVALUE in sequence in oracle?

Could you tell me what is the maximum/minimum value of MAXVALUE in a sequence & what is the minimum/…

sql oracle oracle10g sequence

Could not load file or assembly Oracle.DataAccess

I have an asp.net mvc (EF) project , I had downloaded oracle data provider with version 4.112.2.50 -32bit on my …

asp.net-mvc oracle entity-framework entity-framework-4 odp.net

How to solve error: ORA-01406 fetched column value was truncated?

I am trying to execute this query: select * from gi_todo_isim WHERE d_insercao >= '04-JUL-13' AND …

sql database oracle plsql sql-navigator