Posts by David • 4,330 points
170 posts
-
5
votes1
answer819
viewsQ: Calculate import time of DUMP
I would like to know, if possible, how to approximate the import time of a Dump. It could be something considering the following items: GB DUMP size. Number of Tables. Number of Records and(or)…
-
4
votes1
answer9720
viewsQ: How to list folder files on the network
Context: Sometimes every day I need to gather information from folders on the network, where it has several subfolders and files. Need: I need to gather that information faster, so I thought put a .…
-
1
votes1
answer185
viewsA: When I pass date filter for the same day, query comes back empty and there is data
The date you are passing may be the time, so it does not bring the expected return. Using the function Trunc oracle, may solve your problem. I did not test, but if you change the parts below:…
-
3
votes5
answers150
viewsA: Doubt with image positioning
If case wishes that whenever the class .relative positioned in the center, could use the code below:: CSS .relative { margin:0 auto; float:none; }…
-
3
votes1
answer389
viewsA: Sql Code Syntax Highlighting
The Component Synedit, will solve your problem. I currently use inclusive to sql, but has support for various languages, such as:c++, java, Cobol, js, php, etc.. How to use Synmemo: After installing…
-
2
votes2
answers135
viewsA: Reading Incorrect txt File
If you were using a current version of Delphi you could use Linha.StrictDelimiter, however in delphi7 is not possible. Alternatively, you can do it this way: linha.DelimitedText := '"' +…
-
3
votes1
answer7165
viewsQ: Conversion and Grouping of Rows into columns dynamically in Oracle
Context: I have a Project mixed Versions of apps that will be developed, each various Version New Feature Requirement (NF) means each NF with several Code changes in several Repositories. In…
-
-3
votes2
answers9964
viewsA: Pivot dynamic columns
A possible solution would be, instead of turning into columns, the result of the columns that contain the XML year, and then working within your application: SELECT * FROM ( SELECT item , ano ,…
-
2
votes1
answer38
viewsA: Orderby in an array
In accordance with example of wordpress Codex on query_post, goes below: $Recent_Page = get_post_meta(get_the_ID(), 'imic_home_recent_property_no', true); $args = array( 'post_type'=> 'property',…
-
1
votes1
answer1155
viewsA: Debug Function within a package
You can use the Command: ALTER PACKAGE PKG_NOME COMPILE DEBUG; This will make it possible to debug your package. Then in Sqlwindow right click on your package, and select: "Edig Spec & Body",…
-
1
votes3
answers57
viewsA: Problems with CSS opacity
We can use css3, where the 0.5 below represents the color transparency. #frase1{ position: relative; top: 0px; width: 300px; height: 20px; border: 2px solid #fff; background-color: RGBA(0,0,0,0.5);…
-
1
votes3
answers4386
viewsA: At the start of the eclipse an error appeared
Check your Workspace/. Metadata /.log or the error view to get more information about what this actually means for Nullpointerexception. Or as per answer to a similar question, delete your existing…
-
16
votes6
answers8730
viewsA: How to create geometric shapes using CSS?
Simpler and more like your image: .trapezio { border-bottom: 70px solid #c1c1c1; border-left: 30px solid transparent; border-right: 15px solid transparent; height: 0; width: 120px; }…
-
3
votes2
answers371
viewsA: Batch to locate service with special character
As per your command you’re picking up hair "NOME_PARA_EXIBITION", but if you catch it by "NOME_DO_SERVION" will have no problem. Example: NOME_DO_SERVION: DPS NOME_PARA_EXIBITION: Servicthe Diagn…
-
5
votes3
answers1301
viewsQ: Move folder/files between repositories without losing Change history
Context: I have a versioning environment in Mercurial using Tortoisehg for viewing and commits and files. I want to move a folder from one repository to another and without losing change history,…
-
1
votes2
answers847
viewsA: Best practice for handling branchsets in SVN
As you have the 3 demands that were made from TAG12, so we have that they are separated each in 1 new branch, as already made the Merge to the Trunk probable that Tortoisesvn do not let do on…
-
1
votes1
answer654
viewsA: Problems in the SVN
Press and hold or right-click the folder "J: familia4" and click Properties. Click on the Security tab. In the Group or User Names tab, select your user to see your permissions, if you do not change…
-
0
votes1
answer1166
viewsA: Run Instant with Break Lines Getting Invalid Package
I was thinking the problem was the line breaking, so I sought alternatives for this, instead of using CHR(13) I used CHR(10) Chr(13) = Avanço de linha = Line Feed Chr(10) = Retorno de Carro =…
-
0
votes1
answer1166
views -
1
votes1
answer94
viewsQ: Check if CONSTANT exists in Package
I have a Package: CREATE OR REPLACE PACKAGE LETRAS AS possuiA CONSTANT BOOLEAN NOT NULL := TRUE; possuiB CONSTANT BOOLEAN NOT NULL := TRUE; possuiC CONSTANT BOOLEAN NOT NULL := TRUE; possuiD…