Top "Oracle10g" questions

How to rename a table column in Oracle 10g

I would like to know: How to rename a table column in Oracle 10g?

oracle oracle10g

Is it possible to output a SELECT statement from a PL/SQL block?

How can I get a PL/SQL block to output the results of a SELECT statement the same way as …

sql oracle plsql oracle10g oracle-apex

how to convert a string date to date format in oracle10g

My date value is stored as varchar2 and the value is 15/August/2009,4:30 PM, how to convert this to a proper …

oracle oracle10g plsqldeveloper

How to resolve ORA 00936 Missing Expression Error?

Select /*+USE_HASH( a b ) */ to_char(date, 'MM/DD/YYYY HH24:MI:SS') as LABEL, ltrim(rtrim(substr(oled, 9, 16))) …

oracle oracle10g ora-00936

Different CURRENT_TIMESTAMP and SYSDATE in oracle

After executing this SQL in oracle 10g: SELECT SYSDATE, CURRENT_TIMESTAMP FROM DUAL I receive this strange output: What is …

oracle plsql oracle10g

Why do I have ORA-00904 even when the column is present?

I see an error while executing hibernate sql query. java.sql.SQLException: ORA-00904: "table_name"."column_name": invalid identifier When …

oracle oracle10g ora-00904

Oracle Date - How to add years to date

I have a date field DATE = 10/10/2010 sum = 4 (this are number of years by calculation) is there a way to add …

oracle oracle10g date-arithmetic

Oracle - Insert New Row with Auto Incremental ID

I have a workqueue table that has a workid column. The workID column has values that increment automatically. Is there …

sql oracle plsql oracle10g

null vs empty string in Oracle

Possible Duplicate: Why does Oracle 9i treat an empty string as NULL? I have a table in Oracle 10g named …

oracle null oracle10g string

Pivoting rows into columns dynamically in Oracle

I have the following Oracle 10g table called _kv: select * from _kv ID K V ---- ----- ----- 1 name Bob 1 …

sql oracle oracle10g pivot