Posts by Paulo Camargo • 83 points
6 posts
-
0
votes1
answer191
viewsA: Write Oracle SQL File
As I commented in the @Motta reply, the creation of the output directory was missing with the command below: CREATE DIRECTORY DIRETORIO AS 'C:\DIRETORIO'; Then replace the path with the variable:…
-
0
votes1
answer191
viewsQ: Write Oracle SQL File
Good morning, I am beginner in Oracle PL/SQL, and I created the script below to record the result of a query in txt file, runs without errors but does not write the file, anyone knows what could be…
-
1
votes3
answers3061
viewsA: How to use a Command Button inserted in the Spreadsheet in the VBA code?
Good morning, I was able to solve, using the Activex button, when someone clicks on it I assigned a variable that enables a specific worksheet. Thank you all for your cooperation.…
-
2
votes3
answers3061
viewsQ: How to use a Command Button inserted in the Spreadsheet in the VBA code?
I have a command button that I inserted in a spreadsheet, and wanted to know which function I have to assign in vba code, to know when a user clicks on it !
-
0
votes4
answers1917
viewsA: Home Time in SQL (Years, months and days)
I did according to the example of durtto and it was like this: DECLARE @DTINI DATE, @DTFIM DATE DECLARE @DIA INT, @MES INT, @ANO INT SET @DTINI = '2014-10-31' SET @DTFIM = '2018-11-30' SET @ANO =…
-
5
votes4
answers1917
viewsQ: Home Time in SQL (Years, months and days)
I need to create a SQL function that returns the employee’s home time, example: years old, months and days So far I’ve managed to bring the years old and months, but I couldn’t get the logic of day…