Top "Oracle" questions

Say you have the table: Column_name | data_type Title | Varchar2 Text | CLOB with some rows: SomeUnkownMovie | A long time …

I have the following query that I am attempting to use as a COMMAND in a crystal report that I …

Can you state any difference between the CLOB and NCLOB?

How can I get lat and long from point in oracle? Like this: MDSYS.SDO_GEOMETRY(2001,4326,NULL, MDSYS.SDO_ELEM_…

I have data in a table as seen below: MONTH VALUE 1 100 2 200 3 300 4 400 5 500 6 600 I want to write a SQL query so that …

I am trying to define a type using the following code. CREATE OR REPLACE TYPE MY_TYPE AS OBJECT ( app_…

I am trying to create database using Oracle 11g R2 on windows 2008 server, when I run script to create database …

I've tried to write C# code with ODP.NET to call a function in a package. I'm getting the two …

Can an Oracle SQL procedure return a table? I'm currently using a dbms_output to print out the outputs of …

I have data in the date column as below. reportDate 21-Jan-17 02-FEB-17 I want to write a query to fetch …