Posts by Carlos Henrique Cardoso • 61 points
6 posts
-
-1
votes1
answer50
viewsA: DATASTAGE ODBC query get current_timestamp
Good night! You can make an Insert by passing a new column from a Transformer with the Currenttime function()
sqlanswered Carlos Henrique Cardoso 61 -
1
votes1
answer1137
viewsQ: Remove character in Shell Script
all right? I’m making a script to read a log on my server to pick up just a few parts that interest me and play in a . csv. The script is very simple, follow: #!/bin/bash export…
-
0
votes0
answers534
viewsQ: Query error - Inconsistent NCLOB data
Hello, I am trying to perform a query in an Oracle database and is returning an error ORA-00932: inconsistent data types: expected - obtained NCLOB 00932. 00000 - "inconsistent datatypes: expected…
-
3
votes2
answers1498
viewsQ: Concatenate SH command results on a line
I’m starting to learn Shell Script and I have a question. I’m creating a .sh to take the number of processes running in the OS and export this information in a file .csv. The problem is that I would…
-
1
votes1
answer1153
viewsQ: Oracle SQL Query - Subtract Hours
Hello, I’m a beginner in SQL, and I’m in mortal doubt. This query is to analyze an execution log on a basis of my company. The problem is that the time zone of the OS is +0.00 which creates…
-
0
votes2
answers729
viewsQ: Power BI - Oracle SQL Query
Hello, I am trying to get data in Power BI via Query on an Oracle DB and is showing the following error. Cannot establish connection Details: "Oracle: ORA-01843: not a Valid Month" SELECT DISTINCT…