? Export to a csv file

I try many times to export my result into .csv file but I'm always fail. I read lot of articles related in my problem. Look at my query:spool sample.csvSELECT /*html*/(CODE_SALESROOM) POS_ID, (NAME_SA
 ? JPA query with GROUP BY in Spring Data on Oracle database

I'm using Oracle as database and Spring Data on a project with jBoss AS. A simple query with a GROUP BY doesn't work.This is the Repository code:public interface UseCaseRepository extends JpaReposito
 ? Change from Number to Generated in PLSQL

I am trying to alter a table where the original datatype of this column is Number to a generated column, but I get an error of "ORA-00905 Missing Keyword"Alter Table MyTableModify Column FlagColumn NU
 ? Behavior of anonymous block, is it compiled every reuse in oracle DB?

I was reading Oracle DB Concept Guide ( 11g r2 ) and i just see this article 8- 9 PL/SQL Anonymous block and in this article it has a table and it name is Differences Between Anonymous Blocks and Subp
 ? Cloning a Oracle Database Schema

I have an Oracle 12c Instance with a scheme 'wadmin' user, this instance has tables, view, data, triggers, sequences etc.For quick spinning of docker images, I need to clone the db schema as fast as p
 ? Optional Data Input into Spotfire Text Area parameters got from a Oracle Function

I have created a Function from Oralce DB and used it as input to Spotfire report. The reason why i used a function instead of view is because the parameters had some complex logic operations and i was
 ? Drop a table in a procedure

Possible Duplicate: Oracle: If Table Exists Drop table if it exists I'm trying to create this procedure but I get an error.CREATE OR REPLACE PROCEDURE SP_VEXISTABLA(NOMBRE IN VARCHAR2)ISCANTIDAD NU
 ? DROP trigger only if it exists (ORACLE)

This question already has an answer here: Oracle: If Table Exists 11 answers You have two option:1) Check if tr
 ? remote oracle database connection

I am working on a project using oracle.The remote host pc ip address is 10.100.59.30 where my database exists.I want to connect the database from my computer(ip:10.100.59.150). How should I do it?Orac
 ? Showing relationships between Oracle views in a data model

I have set of Oracle data views which are created according to underlying table structures. Now I want to represent these views visually with their relationships, just as the table relationships ( f
 ? Showing relationships between Oracle views in a data model

I have set of Oracle data views which are created according to underlying table structures. Now I want to represent these views visually with their relationships, just as the table relationships ( f
 ? Showing relationships between Oracle views in a data model

I have set of Oracle data views which are created according to underlying table structures. Now I want to represent these views visually with their relationships, just as the table relationships ( f
 ? Dynamic database design for variable length spatio-temporal data in oracle (need a schema design)

Currently I am working on a research project, where I need to store spatio-temporal data and analyze them efficiently. I am giving the exact requirement below.The research is going on meteorological d
 ? Oracle Data Modeler - Diagram notation

Is there a detailed notational guide for the Relational model diagrams generated by the Oracle Data Modeler?I'm using Oracle Data Modeler to generate Relational Models for an existing database. It gen
 ? Downloading large files to PC from OAS Server

We have an Oracle 10g forms application running on a Solaris OAS server, with the forms displaying in IE. Part of the application involves uploading and downloading files (Word docs and PDFs, mainly)
 ? Oracle SQL Error ORA-00933 on INSERT in Lucee

Error ORA-00933: SQL command not properly ended Attempting to INSERT a row using the following cfscript statement:q.setSQL("INSERT INTO SALES_OPTION_CHOICE (SALES_CONFIG_OPTION_ID, DESCRIP, ISDEFAULT,

Page 1 of 291  |  Show More Pages:  Top Prev Next Last