Top "Oracle" questions

Oracle - What happens when refreshing a 'REFRESH FORCE ON DEMAND' view with DBMS_MVIEW.REFRESH

I have the following materialized view - CREATE MATERIALIZED VIEW TESTRESULT ON PREBUILT TABLE WITH REDUCED PRECISION REFRESH FORCE ON …

oracle oracle10g materialized-views

Getting error while trying to alter table in an sql block

I create a test.sql file and inside I put: begin alter table table1 enable row movement; alter table table1 …

oracle oracle11g

format interval with to_char

Following SQL command select TO_CHAR(NVL(arg1 - arg2, TO_DSINTERVAL('0 00:00:00'))) from table1 produces a result of …

sql oracle intervals

How to write pandas dataframe to oracle database using to_sql?

I'm a new oracle learner. I'm trying to write a pandas dataframe into an oracle table. After I have made …

oracle pandas dataframe cx-oracle pandas-to-sql

DBMS_Snapshot.refresh not working on 11g , materialized view error

I executed DBMS_Snapshot.refresh on Oracle 10g it worked fine, but when i execute the same on Oracle 11g …

oracle oracle11g ora-06512

Data got committed in another/same session, cannot update row (Oracle SQL Developer)

I occasionally get this error when i try to update a record through the grid. One error saving changes to …

oracle oracle-sqldeveloper

Oracle SQL Developer copy database step by step

I'm having big trouble in copying an Oracle DB to the same server but with another name, to use as …

sql database oracle oracle-sqldeveloper database-administration

Oracle Syntax for Creating Database Link Owned by Another User

The typical syntax for creating a db link is as follows: create database link remote_db_link connect to remote_…

oracle owner dblink

Passing varchar2 parameter to plsql procedure from the Select statement

Executing the following statement in Oracle Toad exec plsql_procedure(select 'somestring' from dual); trhows the following exception: ORA-06550: line 1, …

sql oracle plsql toad

Is there any way to get information about current session from gv$session in oracle?

Is there any way to uniquely identify current session in GV$SESSION view in Oracle? I've faced with the problem …

oracle session oracle-rac