Top "Oracle10g" questions

Oracle is an RDBMS product.

Return Message of Error code in Oracle Stored Proc

The below procedure (in Oracle 11g release 1) accepts a sql as a parameter & returns its return code. Returns 0 if …

oracle oracle10g oracle11g oracle9i
CheckBox in RadGrid and Sending data to Database

I want a checkbox in RADGRID. Following are detailed requirements: All the radgrid columns i am populating with AutoGenerateColumns="True" …

c# asp.net oracle10g telerik radgrid
How to refresh materialized view using trigger?

create or replace TRIGGER REFRESH_REST_VIEW AFTER INSERT OR UPDATE ON tbl_contract BEGIN execute DBMS_MVIEW.REFRESH('REST_…

sql oracle triggers oracle10g materialized-views
Getting error ORA-00936: missing expression

When I trying the below SQL I am getting the error ORA-00936: missing expression. Please help me on this, I …

sql oracle oracle10g ora-00936
How to restore the data in a Oracle table?

I did a terrible mistake on my work, I executed an updated query on a oracle table without the 'where' …

oracle oracle10g flashback
Why doesn't Oracle raise "ORA-00918: column ambiguously defined" for this query?

I've just come across a strange behaviour in Oracle where I would expect ORA-00918 to be raised, but isn't. Take …

sql oracle oracle10g oracle11g ora-00918
Change external table BADFILE, LOGFILE and DISCARDFILE parameters only

I have several external tables used to read file data into the DB each one for a particular file specification. …

oracle oracle10g external-tables
OracleCommand command, ExecuteNonQuery issue

I have to clear certain tables in the oracle database however when I'm having issues with running the following code …

c# sql oracle10g executenonquery oraclecommand
oci_connect() works only from command line

OK, so I have this terrible problem with oci, apache, php and suse. First off, versions: PHP 5.3.15 (cli) Apache/2.2.22 (Linux/…

php oracle10g suse apache2.2 oci8
dbms_output size buffer overflow

I tried to set the dbms_output size to unlimited inside a stored procedure. But it gave me compilation errors. …

oracle plsql oracle10g sqlplus dbms-output