All Questions
173 questions
0
votes
1
answer
60
views
How to format oracle clob fields together
So I have a table that has a clob column. And sometimes I have multiple rows that I need to concatenate together which I do doing something like
Select n.textid
LISTAGG(TRIM(n.text), '||')
WITHIN ...
- 57
0
votes
5
answers
89
views
How to transpose subset of columns into rows and group by remainder of rows? Excel? SQL?
We are in the early stages of migrating some data from a legacy system to a new system that seems to have some quirks.
Currently we have some data that is as follows
Name Date Award
Roger ...
- 301
0
votes
0
answers
104
views
Export to Excel from within sql script - is it possible?
In Toad for Oracle, I know how to select a row of data and export that to an Excel file or Excel instance.
Is there any way I can do the same thing from within a sql script, run through an editor ...
- 21
0
votes
3
answers
141
views
SQL query with one blank parameter?
I have written a SQL script to Excel Power Query that fetches values from an Oracle database. My query consists of named excel cells that include date range, "product" and "analysis&...
- 1
0
votes
0
answers
36
views
How do I compare data from excel spreadsheet to tables in oracle and how do I enter the results into excel spreadsheet
I want to compare user_id from an excel spreadsheet to three tables and copy the user_id that are the same to a spreadsheet
select user_id, userName, Dept
from
myExcelel sheet (user_tab), a....
-1
votes
1
answer
72
views
How to convert Multiple rows in a column for the same EMPLID INTO different columns ? Oracle or Excel [duplicate]
In our table in Oracle SQL, we have a table where we are saving Students Courses Grades for every courses in different Terms.
Rows are repeating because of same Student ID (EMPLID) has so many courses ...
0
votes
1
answer
78
views
Wrong insert in Oracle [closed]
I have an oracle apex application.
I'm an Iranian, my application has to be right to left direction.
I have a page for data loading; it takes an Excel file and stores its data into the database.
Now ...
0
votes
1
answer
373
views
Translate excel formulas into SQL query
I am looking for help to translate excel formulas into SQL (Oracle).
With given fixed input values for rows 1 (Month ascending) and 2 (SU - some number). I have to calculate through particular cells ...
- 21
0
votes
2
answers
1k
views
Oracle SQL how to export null values
in relation with how to copy the records from output of oracle SQL developer to excel sheet
I'm using Oracle SQL developer. I've some queries which get some null values in the result grid. I'd cut/...
- 36
0
votes
1
answer
179
views
Why header is being duplicated when generating an Excel sheet using SQL query?
I am using SQL query to generate an Excel sheet to export data from my database, the header is being duplicated every 10000 lines and I need it not to be duplicated.
I am using the below setup. When I ...
0
votes
0
answers
1k
views
How to compare DB results with Excel file data in Java?
I am trying to write some tests that would compare and assert that db data are the same with my exit data (some excel file).
I am querying oracle table with some SELECT and got ResultSet. Or I can get ...
- 17
0
votes
2
answers
133
views
Transform Excel Formula to SQL Oracle
I want to convert a formula from Excel to a query SQL: I want to find every line in a table that has a column B calculated with a formula in Excel.
table X has 2 columns: Column A and Column B
The ...
- 1,635
0
votes
1
answer
79
views
Need row data column wise in oracle
I need to compare prices coming from 3 sources (27, 2, 55) from owners column. i am not sure if i should use select sub query or left join ?
Desired Result
- 137
0
votes
0
answers
190
views
Error -359 SQL Function (function stored procedure) not found - In ODBC query through Excel
I've been working on some new projects involving queries through an Excel ODBC connection. In the last couple days I've been getting a '-359 SQL Function (function stored procedure) not found' for ...
- 11
0
votes
1
answer
555
views
How change UTC time to Europe/Helsinki in SQL to make it working via Excel connection
I am working in Oracle server and want to run the following query inside excel workbook
Select current_timestamp, FROM_TZ(CAST(current_timestamp AS TIMESTAMP), 'UTC') at time zone 'Europe/Helsinki'
...
- 495