Posts by David • 4,330 points
170 posts
-
2
votes1
answer209
viewsQ: How to create a query with a non-existent and error-free table
I have a query that runs in several different schemas in the database, and there is a specific table that only some schemas have, and if there is the value returns. SELECT t.coluna1 ,t.coluna2…
-
1
votes2
answers3456
viewsA: Grant for several Oracle tables
I like to generate the scripts of grant at hand, because we usually perform once, through a query: SELECT 'GRANT select,update,delete,insert ON ' || x.table_name || ' TO STACKOVERFLOW;' FROM…
-
4
votes2
answers5477
viewsA: How to remove the first character from a string in a Query
As you passed that your column from which you do not want the first character, so let’s consider any and all character types. To select the data by removing the first character, and using the…
-
2
votes1
answer353
viewsQ: Share internet via wifi using command line
I have a wifi adapter, or could be a notebook, and I share the internet via Wifi, that’s not the problem, follows below how I create a wifi network: Create a wifi network Access CMD as…
-
3
votes1
answer247
viewsA: Error Char to String conversion
When analyzing the pattern, we have that the cases are always numbers, so we could convert the value of Text to integer, and thus solve your problem: procedure…
-
1
votes1
answer4598
viewsA: export oracle database 11g sqldeveloper
Observing: First of all, I recommend running a test on 2 banks to see if the expected result meets your problem. You can use the Database Copy Wizard, available in the menu: Ferramentas > Cópia…
-
6
votes5
answers964
viewsQ: How to progress steps using thread chart?
I am developing a screen using the student’s progress, for example, he has 10 activities to complete, and is in activity 2, so this represents 20% of the total activity. I’d like to represent that…
-
5
votes1
answer140
views -
8
votes3
answers4035
viewsA: Like writing a pseudocode?
Let’s get some definitions before we actually answer. According to Wikipedia: Pseudocode is a generic way of writing an algorithm, using a simple language (native to the writer, in order to be…
pseudocodeanswered David 4,330 -
2
votes2
answers361
viewsA: Apply filter to only part of image
To solve this problem, and using the filter brightness, we can use the property clip: The clip property allows you to specify a rectangle for cut an absolutely positioned element. The rectangle is…
-
0
votes5
answers1258
viewsQ: How to open a new background tab and redirect the current tab?
I would like when clicking on the link to open a new tab (but in the background - I want the focus tab to remain the same) and the current tab to be redirected. This is possible? With the code…
-
2
votes2
answers2995
viewsA: How the Parallel hint works
Parallelism, available in the version Oracle Database Enterprise Edition, offers the idea of breaking a task into pieces so that, instead of a single process doing all the work, many processes can…
-
7
votes2
answers614
viewsQ: What is code golf?
Looking at the tags on the site, I come across the tag code-golf, I read the brief explanation: code-golf Use this tag when only when the question has a relation irrefutable to Code Golf Code…
-
4
votes2
answers363
viewsA: Using & in Oracle Search
Normally to solve when using PLSQL, I do as follows: SELECT * FROM MARK_CAMPANHA -- WHERE DESCRICAO = 'Easy Breezy Emailmkt '||'&'||' Eu'; Researching a little now, I found using SET ESCAPE,…
-
1
votes1
answer6120
viewsQ: Run script file directly in PLSQL
I have a arquivo.sql, which has thousands of lines of scripts, containing, creations, changes, etc. I need to run this file directly in PLSQL at SQL Window, and nay can be via Command Window. Via…
-
1
votes2
answers967
viewsA: Add and split results in the same query
To do this, you will need to use subselects, I made an example, using the fields you use, only to demonstrate: SELECT COUNT(*) AS total ,defesas ,chances ,SUM(defesas / chances) AS porcentuals FROM…
-
0
votes1
answer39
viewsA: Problem in Table Creation
How did you not specify which SGDB is using, and by your table creation script beneficiarios be using the datatype year, I assume you’re using mysql (or sqllite), thus the problem of your script is…
-
5
votes3
answers7189
viewsA: "import" header and footer on all pages
Below is an example using Jquery, where on each page will have to use more or less the structure below, of course there is something that can be improved, as this function in a file .js, specific.…
-
0
votes1
answer121
viewsA: Create Graphs with Tsimplegraph
Inside the folder you downloaded, at the root came the files: DELPHIAREA.INC SimpleGraph.dcr SimpleGraph.dcu SimpleGraph.pas SimpleGraph.res Put the .DPR of your project, I believe it will solve.…
-
2
votes2
answers1450
viewsA: Generate error at the end of the copy in case some file is not copied
Using the XCopy,and as per documentation, it is possible to capture possible errors after executing the command: 0 = Files were copied without error. 1 = No file found to copy. 2 = User pressed…
-
2
votes1
answer306
views -
1
votes1
answer1114
viewsQ: Replace all & parameters of a query in Sqldeveloper
I have a query that uses several times the same parameter, in Sqldeveloper, calls Substitution Variable (VS), for example, &empresa. If I use this VS with the query below: SELECT * FROM pedido…
sqldeveloperasked David 4,330 -
0
votes1
answer6078
viewsA: How to change (replace) the information from within a . txt file using . bat?
Some time ago I needed to change an acronym inside a file on several different servers, so searching I found the solution below. Utilizes the powershell to find the sequence and replace, I used your…
-
1
votes2
answers261
viewsA: Update with character in the middle of the string
Before making a update directly like to make a select to check how the result of update, so I did a test on Sqltest. CREATE TABLE poste ( numero VARCHAR(30) NOT NULL ); INSERT INTO poste VALUES…
-
0
votes1
answer1793
viewsQ: How to find out how long an application has been running?
I have to find out how long an application in windows is running, the application itself, it was not I who created the application, I already searched and I could not find anything, using logic, I…
-
3
votes1
answer134
viewsA: Select previous row if null
As documentation on LAST_VALUE: It is an analytic function. It returns the last value in a set of sorted values. If the last value in the set is null, the function returns, to NULL unless you…
-
1
votes1
answer39
viewsA: Copy of Oracle materials structure
As I do not know the structure of your table, so I implemented according to the understanding of the business rule. I don’t know how it’s done in your database to sequence each PK, so I did a…
-
1
votes1
answer319
viewsA: Error compiling function in oracle
In Oracle functions, it is not necessary to specify the column size in the input parameter, so the declaration of your function would look like this: CREATE OR REPLACE FUNCTION…
-
0
votes1
answer545
viewsQ: How to remove beep from windows application
I have an application developed in Delphi7, in some calls, windows emits that beep, and you’re filling the &!(&@. I wonder if there’s a way disable sound from windows from my application,…
-
0
votes1
answer55
viewsQ: Relationship between ORM tables
I have a doubt, regarding ORM, I use the Doctrine, but understanding of ORM would already help. The relationship of the idAninal table consulta, with the table Animal, would be, ManyToMany,…
-
1
votes1
answer78
viewsA: Difficulty assigning value in plsql
Lucas, just remove the type, getting in the way below: declare valorVoto number := &voto; votosDeputado1 number:= 0; votosDeputado2 number:= 0; ...
-
1
votes1
answer228
viewsQ: Check mapped network unit size
I’m developing an app, and I need to check the free space on the mapped network drive, I can grab the contents of a file in my application directory, so I created a script to execute the command to…
-
0
votes2
answers37
viewsA: Why does To_char(3E4) not result in '3E4'?
Using only the TO_CHAR(numero,'FM9.9EEEE'), returns: 3.E+04 But since you want it to stay the same, I made one Gambiarra: SELECT REPLACE( REPLACE( REPLACE(TO_CHAR(numero,'FM9.9EEEE'), 'E+0','e')…
-
1
votes1
answer19
viewsA: Make it create scrollbar when two components collide
I made an example using box-flex, I don’t know what your case is, but it follows below: .pagina { overflow: auto; display: -webkit-box; display: -moz-box; } .esquerda { background-color: red; width:…
-
2
votes1
answer130
viewsA: Difference Between Using "FROM Table, Table2" X "Join Table ON Table2"
In doing so, and we use the LEFT JOIN, returns to tabela and only those records that match the equality of the join in tabela2 (or null fields for unmatched fields): SELECT Tabela.A, Tabela.B,…
-
1
votes3
answers14296
viewsA: Export SQL Server query to CSV file
With Sqlserver, after performing the query, go to the result and right-click: The first option of formed to save will be .csv.…
-
3
votes3
answers3141
viewsA: How to monitor a file in real time on Windows?
Via CMD, I do not know any solution, but below some alternatives: Using the Powershell: Get-Content arquivo.log –Wait If you want to make filters, we can use another concatenated command called…
-
1
votes1
answer1446
viewsA: Where does SQL Developer save the BD file?
Basically, the oracle saves data from its schemas inside tablespaces, of which the datafiles, which are physical files, and sometimes shared between schemas. To know which tablespace your schema…
-
2
votes2
answers439
viewsA: Settings . bat running a . dstx
I can help you with your third question, to decrease the code that generates the log file name. Can replace by: :: Recebe a data com formatação padrão: set…
-
1
votes1
answer617
viewsQ: Send email through outlook
I am trying to send e-mail using outlook, through Delphi7, I used this Documentation: Command-line switches to open the outlook with message parameter passing, conforms below: var…
-
5
votes2
answers1720
viewsA: How to put . vbs inside . bat
You can generate the .vbs at run time of your batch: echo Dim objFolder^, objShell > script_.vbs echo Set objShell ^= CreateObject^(^"Shell.Application^"^) >> script_.vbs echo Set objFolder…
-
3
votes1
answer375
viewsA: Update in a table with values from another
You can set the value of quant of the product, based on other consultation, please note how would you look: UPDATE produto SET produto.quant = (SELECT SUM(entrada.quant) FROM entrada WHERE…
-
3
votes1
answer55
viewsA: Is there a way to use a Mysql table when developing an app with Ionic and Cordova?
TL;DR Yes Everything will depend on the size of your application, if it is an application for registering annotations, you would have in the database a table anotacoes, and fields as: id, data,…
-
4
votes2
answers972
viewsA: Regular expression with specific ending bring 3 first characters
I was thinking of a single expression, but I don’t need it, because I need to filter everyone that ends with the letter I want, and show the first 3 characters, so the script: SELECT…
-
5
votes2
answers972
viewsQ: Regular expression with specific ending bring 3 first characters
I am trying to make a regular expression on Oracle with the following requirement: End with a specific letter if you have this letter in the middle not searching. Return the first 3 digits of the…
-
0
votes1
answer805
viewsA: How can I apply Unpivot to a simple select, I want to leave a query upright
As consultation used, below is how it would look. To suit your scenario, I recommend consult Documentation - Pivot and Unpivot EN. SELECT valor FROM ((SELECT '1' dado1 ,'2' dado2 ,'3' dado3 ,'4'…
-
0
votes2
answers304
viewsA: How to automatically select the first item of a popup menu
In his popupMenu add the code below in the event onPopup, that is, when show the popupMenu automatically select the first option: PopupMenu1.Items[0].Click; This way it becomes more dynamic, no…
-
0
votes2
answers327
viewsA: Fixed first row table using Material Design Lite
I checked the documentation to see if you had anything ready to fix the thead, as I did not find, I made an example in css, and for that I would have to fix the tbody in a size, follows below: table…
-
0
votes1
answer43
viewsA: How to make the mavem always get the jar from the master branch
You can use a plugin of Maven to solve his problem, the Maven git commit id plugin is on githup explaining how to use, basically just change the .pom.xml: You can use it to get the branch git with…
-
1
votes1
answer40
viewsA: Run Migrations from another BD
Try the command or command: php artisan migrate --path="app/database/migrations/my_single_migration" Source: Soen: running-one-specific-Laravel-4-Migration-single-file And looking at the…