Top "Oracle" questions

How to escape comma and double quote at same time for CSV file?

I am writing a Java app to export data from Oracle to csv file Unfortunately the content of data may …

java regex excel oracle csv

How do I declare and use variables in PL/SQL like I do in T-SQL?

In Sql Server, often times when I'm testing the body of a stored procedure, I copy the body into SSMS, …

sql-server oracle tsql plsql oracle-sqldeveloper

How to handle a single quote in Oracle SQL

How do I insert a record in a column having varchar data type having single quote in it? Example: first …

sql oracle escaping

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 Alter Constraint

SQL How to Alter Constraint Below is 1 of my constraint CONSTRAINT ACTIVEPROG_FKEY1 FOREIGN KEY(ActiveProgCode) REFERENCES PROGRAM(ActiveProgCode), I …

sql oracle

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

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

SQL ROWNUM how to return rows between a specific range

How can I return a specific range of ROWNUM values? I'm trying the following: select * from maps006 where rownum >49 …

sql database oracle rownum

this is error ORA-12154: TNS:could not resolve the connect identifier specified?

I've this code : OracleConnection con = new OracleConnection("data source=localhost;user id=fastecit;password=fastecit"); con.Open(); string sql="Select …

c# oracle excel-addins

What does "select count(1) from table_name" on any database tables mean?

When we execute select count(*) from table_name it returns the number of rows. What does count(1) do? What does 1 …

sql database oracle