Question : I have a streams replication related user in Oracle 11g. I see the user in dba_users table and […]
Tag: oracle-11g
Is wrapping only possible for package bodies?
Question : I am using oracle 11gR2 database in which I was trying to wrap my scripts. I read the […]
What privileges are needed to run EXPLAIN PLAN FOR CREATE INDEX?
Question : My user can EXPLAIN PLAN FOR any query I like, but not for CREATE INDEX. I need to […]
Oracle query optimization
Question : We have a query that runs on a view and its execution time is about 6 min. SELECT […]
Oracle server connection reset by peer socket write error
Question : Full disclosure, I’m not a database admin, but if anyone is able to help me, it would be […]
Result on execution of any SQL is number 2
Question : After successful execution of any sql in oracle sql command line it shows 2 like i want to […]
Designing Simple Schema for Disaggregation of Demand Forecast
Question : I am doing a simple database design task as a training exercise where I have to come up […]
In Oracle how do I save a sequence.nextval in a variable to be reused in multiple inserts?
Question : I’m writing a script to populate some tables with data for testing. I would like to write something […]
Update table from different table [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Mutual authentication via SSL Oracle 11g
Question : I configure mutual authentication via SSL between client (Windows 7) and server (Windows Server 2008 R2). I create […]