Top "Oracle" questions

Oracle Database is a Multi-Model Database Management System created by Oracle Corporation.

How to debug a stored procedure in Toad?

I have Oracle 10g installed and there is a package which has a number of cursors and procedures, how do …

oracle debugging stored-procedures toad
How to create a blank/empty column with SELECT query in oracle?

I want to generate an output with blank/empty column with a "Select" query in oracle. I'm able to achieve …

oracle oracle-sqldeveloper
SQLPLUS error:ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

I downloaded SQLPLUS from Oracle: http://www.oracle.com/technetwork/topics/winx64soft-089540.html Basic Lite and SQL*Plus I …

oracle connect sqlplus
How can I list the scheduled jobs running in my database?

I am new to oracle. I need to get the scheduled jobs in my database. I queried DBA_SCHEDULER_JOBS, …

sql oracle jobs privileges
How do I check the NLS_LANG of the client?

I'm working on Windows OS, I know that this setting is stored in the registry. The problem is that the …

oracle character-encoding nls-lang
Get counts of all tables in a schema

I am trying to get the record counts of all tables in a schema. I am having trouble writing the …

oracle plsql
Can you use Microsoft Entity Framework with Oracle?

Is it possible to use Microsoft Entity Framework with Oracle database?

.net oracle entity-framework odp.net
How does contains() in PL-SQL work?

Have a lot of unnecessary results using contains() method in my query. Don't tell me to use like or something …

sql oracle oracle10g contains
Displaying RowID in Select * (all) Statement

I am trying to display the RowID alongside all columns from a Select * statement. I am using Oracle with Toad …

sql oracle toad rowid
Java java.sql.SQLException: Invalid column index on preparing statement

my code below query the database for a set of rows based on user input. I have tried and tested …

java oracle jdbc sqlexception