Top "Oracle11g" questions

Sleep function in ORACLE

I need execute an SQL query in ORACLE it takes a certain amount of time. So I wrote this function: …

sql oracle plsql oracle11g

Oracle - How to create a materialized view with FAST REFRESH and JOINS

So I'm pretty sure Oracle supports this, so I have no idea what I'm doing wrong. This code works: CREATE …

sql database oracle oracle11g

How to declare and display a variable in Oracle

I would like to declare and display a variable in Oracle. In T-SQL I would do something like this DECLARE @…

oracle plsql oracle11g

How to solve : SQL Error: ORA-00604: error occurred at recursive SQL level 1

When I'm trying to drop table then I'm getting error SQL Error: ORA-00604: error occurred at recursive SQL level 2 ORA-01422: …

oracle oracle11g drop-table

How to find out when a particular table was created in Oracle?

In Oracle, is there a way to find out when a particular table was created? Similarly, is there a way …

oracle oracle11g database-metadata

Oracle SqlDeveloper JDK path

I have recently installed sqldeveloper but i'm getting the below warning window when I try to launch it. This is …

java oracle11g oracle-sqldeveloper

SQL to add column and comment in table in single command

I am using Oracle 11g for my web application. I want to add a column and a comment to an …

sql oracle oracle11g

PL/SQL ORA-01422: exact fetch returns more than requested number of rows

I get keep getting this error I can't figure out what is wrong. DECLARE * ERROR at line 1: ORA-01422: exact fetch …

oracle plsql oracle11g sqlplus

Explicitly set column value to null SQL Developer

I am new to Oracle DB and I am using Oracle SQL Developer (Ver 3.0.02) to query the DB. I wanted …

oracle null oracle11g oracle-sqldeveloper plsqldeveloper

Getting error in console : Failed to load resource: net::ERR_CONNECTION_RESET

I have refresh my application page and getting this error in console Failed to load resource: net::ERR_CONNECTION_RESET. …

php oracle11g