Top "Oracle" questions

SQL to generate a list of numbers from 1 to 100

Using the DUAL table, how can I get a list of numbers from 1 to 100?

sql oracle plsql

When do I need to use a semicolon vs a slash in Oracle SQL?

We have been having some debate this week at my company as to how we should write our SQL scripts. …

sql oracle

How to find available directory objects on Oracle 11g system?

I assume this information is available in Oracle metadata tables, but where exactly ? I need the directory object for BFILENAME …

oracle metadata oracle11g

executing a function in sql plus

I created a function in oracle that inserts records in specific tables and return an output according to what occurs …

oracle function sqlplus

Oracle sqlldr TRAILING NULLCOLS required, but why?

I have an abstruse sqlldr problem that's bothering me. My control file looks something like this: load data infile 'txgen.…

oracle sql-loader

Subtracting Dates in Oracle - Number or Interval Datatype?

I have a question about some of the internal workings for the Oracle DATE and INTERVAL datatypes. According to the …

sql oracle date plsql oracle11g

How to View Oracle Stored Procedure using SQLPlus?

How can I view the code of a stored procedure using sqlplus for Oracle 10g? When I type in: desc …

oracle stored-procedures oracle10g sqlplus

How to get input from user at runtime

I want to take runtime input from user in Oracle 10g PL/SQL blocks (i.e. interactive communication with user). …

oracle oracle10g user-input

How do I escape a reserved word in Oracle?

In TSQL I could use something like Select [table] from tablename to select a column named "table". How do I …

oracle reserved-words

Delete with "Join" in Oracle sql Query

I am not deeply acquainted with Oracle Sql Queries, therefore I face a problem on deleting some rows from a …

sql oracle sql-delete