Posts by Luiz Santos • 3,162 points
113 posts
-
0
votes2
answers280
viewsA: Select from 3 related SQL Server tables
According to the numerical set theory applied to the bank, the correct and most performative way to obtain the result would be this: SELECT * FROM Cartao left JOIN Registo ON…
-
13
votes1
answer2779
viewsA: What is Initial Commit?
Probably your teacher already gave some commit and this one wrote "Initial commit", in the project on your machine there are still no commit’s, to hit from a commit git add . git commit -m "Initial…
gitanswered Luiz Santos 3,162 -
1
votes1
answer842
viewsA: Mysql - How to make a Stored Process be activated once a day?
You will need to create a job that will run this process. Job JOB is a way to assist in maintenance with tasks that must be performed several times equal or on a particular date without needing the…
-
1
votes1
answer468
viewsA: How to declare "nullable" parameters in an Oracle database?
You can do it by the operator DEFAULT or := PROCEDURE ADD(aNUMBER, b NUMBER, c NUMBER DEFAULT 0) If you use signature packages remember to replicate the process. If you want to use it without…
-
8
votes1
answer612
viewsA: What tools to optimize a C#code?
For C#code improvement, my favorite is Resharper. It makes several improvements to code such as: review the quality of the code; eliminate errors and code checks; safely change the code base;…
-
1
votes1
answer63
viewsA: A SELECT that pulls rows from a column (string;string)
From what I understand you have a varchar field and need to find in it, all names that contain a certain value, you can use the commands like plus %. The operator LIKE is used in a clause WHERE to…
-
0
votes1
answer242
viewsA: Simulate a click, how to share a link to Google+ without clicking
Use something like this: document.getElementById('elementID').click(); Supported including in the IE With jquery you can do so: $("#mytest1").click();…
-
-1
votes2
answers3969
viewsA: What is Garbage Collector and how does it work?
Authorship note The content below is mostly composed of excerpts from a article originally published by Macoratti on its website. Reproduction authorized by the author. The garbage collector…
-
1
votes2
answers220
viewsA: What is the best way to treat Exceptions and Log in Webapi (C#)?
I think about the storage location, I like tools that store in N locations, the log has to persist you can not stay refer to a means of access to it. That’s why I use serilog , it persists in…
-
0
votes1
answer617
viewsA: Error converting varchar field to float
In the oracle there is a trick to make this conversion: select meuCampo + 0.0 as comoFloat from minhaTabela I suppose it works in sql serve. Another solution is to change the Convert to decimal,…
sqlanswered Luiz Santos 3,162 -
0
votes1
answer48
viewsA: HTML/PHP code block
I know a plugin in js that meets your need preCode.js
htmlanswered Luiz Santos 3,162 -
4
votes2
answers1790
viewsA: Button to open/close content
From what I understand you want to create a "Read more", I believe you will have to implement a little JS in your solution, a basic solution is the following: THE HTML <p>Lorem ipsum dolor sit…
-
9
votes2
answers31808
viewsQ: The difference between COALESCE and NVL
In Oracle when we have a table that has two campuses A and B, and in selection (select) we want to show B when A is null we have two commands that present us the solution: Coalesce Select…
-
0
votes1
answer963
viewsA: Entering data into the database gives the error "duplicate key value violates uniqueness restriction"
From what you saw your bank looks ok. This error you are suffering this happening can happen in the following situations: Insert At the time of insertion into the table where you are duplicating a…
postgresqlanswered Luiz Santos 3,162 -
1
votes2
answers676
viewsA: How to convert from hexadecimal to Base64?
Take a look at Commons Codec : byte[] decodedHex = Hex.decodeHex(hex); byte[] encodedHexB64 = Base64.codeBase64(decodedHex);…
-
0
votes1
answer46
viewsA: How to make the box of the question page?
The easiest way to create this type of text area is by using a library, I would advise using jquery JQUERY jQuery is a "lightweight" Javascript library, easy to use in the sense of "write less, do…
htmlanswered Luiz Santos 3,162 -
1
votes1
answer574
viewsA: Dropper my schema tables on Oracle
To solve this problem you will need to open an anonymous sql block, check before if it exists and if there is no create: Create if there is no declare nCount NUMBER; v_sql LONG; begin SELECT…
-
1
votes1
answer88
viewsA: Different variable value in sub-select
The reason is simple, regardless of the order in which you dispose of the select, what this within the parenthesis will be executed first, so you will not have suffered the change made externally.…
mysqlanswered Luiz Santos 3,162 -
0
votes6
answers11997
viewsA: Current date Angular 2
There is a component called Datepipe of the angular, it allows better manipulation of dates, through the following syntax: export class DatePipeComponent { today: number = Date.now(); }…
-
0
votes2
answers1181
viewsA: Select with duplicate record
By the design of your select I see no way to return the fields you want to return, you get the result you want. You could perform a group by but that would imply not having the amount of returns you…
-
4
votes1
answer144
viewsQ: Why does Oracle not have autoincrement?
Assuming that it is known that Oracle has the resources of the table quence. I would like to understand why they only recently implemented the autoincrement in Oracle, since it was a feature…
-
1
votes1
answer462
viewsA: What is the foreign key (SQL) for
Declaring a field as a foreign key specifies which field connects the two tables in Join, both for those who produce querys for it, and for the bank itself to handle the optimization. One of the…
-
0
votes2
answers945
viewsA: Bootstrap responsive examples please
I’ll list here some cool examples I found: EXAMPLE 1 @import url('http://getbootstrap.com/dist/css/bootstrap.css'); <div class="row"> <div class="col-lg-2"> <div class="panel">…
-
1
votes1
answer194
viewsA: Create responsive website app icon
You can create an app in each language by calling a web view. Then just post in stores and you will have what you want, however it is important to note that your navigation will not sound native and…
-
4
votes1
answer2558
viewsA: How to select text columns in the editor?
Press Shift + Alt and select the desired area.
visual-studio-codeanswered Luiz Santos 3,162 -
0
votes2
answers256
viewsA: Table take margins in media print
Try this: #page td { padding:0; margin:0; } #page { border-collapse: collapse; } the Dice border-collapse: collapse; condenses the edges into a.…
cssanswered Luiz Santos 3,162 -
0
votes2
answers1797
viewsA: How to take data from 3 tables with INNER JOIN performatively
It is correct the way you are doing, I advise you only to do is to put more meaningful names to the alias, alias is the name you give to this table nickname, to facilitate your call. SELECT…
-
2
votes1
answer158
viewsA: SQL - How to make multiple Inserts in a table with the result of a SELECT * of another table in a query
You don’t need this, you can simply select right after the Insert, making it value, below an example: INSERT INTO table2 SELECT * FROM table1 WHERE condition; Just that they have the same arguments…
-
4
votes5
answers3132
viewsQ: What is the difference between comparison operators on Oracle?
In Oracle there are several operators to make "different" comparisons, such as: <> ¬= != ^= Example: Select * from tabel where nomeTabela <> 's'; Select * from tabel where nomeTabela !=…
-
0
votes2
answers1117
viewsA: Change oracle characterset 11g
A great start to visualizing the problem of these specific errors is to use the oerr Utility is an excellent dictionary of oracle errors and their causes, in this book he talks about this error you…
-
18
votes2
answers7922
viewsA: What is and what is the utility of the DUAL table for Oracle?
It is a kind of false table with a single record, used to select when you are not really interested in the data, but want to receive the result of some function or variable. In simplest words it is…
-
1
votes2
answers7653
viewsA: How to put a video to open in fullscreen automatically in an HTML page?
HTML 5 provides no way to make a full screen video, but the parallel Fullscreen specification provides the requestFullScreen method that allows arbitrary elements (including elements ) to be created…
-
2
votes1
answer49
viewsA: Join in the database
Your relationship is wrong, the fields of your table "item_registered" should not be like this, it should be a relation N to N with the table of items, having an intermediate table between them,…
-
1
votes1
answer549
viewsA: Ldap + Php example of connection
There’s a library I’ve used in a project, it calls adLDAP EXAMPLE $config = array( 'account_suffix' => "@gatech.edu", 'domain_controllers' => array("whitepages.gatech.edu"), 'base_dn' =>…
phpanswered Luiz Santos 3,162 -
1
votes1
answer3155
viewsA: How to solve the ORA-01795 (maximum number of expressions) error in Codeigniter
Does your user enter so many records? If in the case is not perfornatico for such scenario, alias, it doesn’t even work. For this registration number I advise the use of a EXISTS The exists works…
-
2
votes1
answer35
viewsA: Join in sql that returns everything
There are several forms of making joins, in your case you have to make a left join, which only considers the records on one side of the table if there is no other, below an illustrative image to be…
-
4
votes1
answer485
viewsA: Search the bank in real time
You can call the result via ajax and create an autocomplete list using the component Vanilla Javascript Autocomplete You will give the autocomplete on the return of the call in Javascript: function…
-
1
votes3
answers549
viewsA: How to filter through attribute on an object / array
I believe you should use the jQuery.grep(): var found_names = $.grep(names, function(v) { return v.projectId === 1; }); DEMO var names = []; var object = {projectId:"1", name:"Projeto A",…
-
0
votes2
answers410
viewsA: 1215 SQL code "Cannot add Foreign key Constraint"
To find the specific error, run this: SHOW ENGINE INNODB STATUS; And look at the part about LATEST FOREIGN KEY ERROR. The column that will be foreign and the key that it references must be equal in…
-
1
votes2
answers663
viewsA: How can I differentiate a 'NULL' string from a null fact value?
You can filter the nulls in the mysql selection itself, thus: SELECT ProductID, Name, Color FROM AdventureWorks2008R2.Production.Product WHERE Color IS NULL And if color were a text value it would…
-
0
votes1
answer33
viewsQ: Selection Using FROM TABLE
I have a table and a function that returns a pipeline, only the function needs to receive a data from the first table, I imagined that the selection would be something like this: Select…
-
2
votes1
answer41
viewsA: Best HTML library for Android Studio
It is quoted by you is the most famous, I found another similar that is the Htmlspanner
-
0
votes1
answer966
viewsA: Convert input to date with oracle
There is a function in PL/SQL called to_date. She is responsible for carrying out this conversion, thus: to_date(&mes, 'DD/MM/YYYY') Some example of masks: TO_DATE('2003/07/09', 'yyyy/mm/dd')…
-
5
votes1
answer18816
viewsA: Ways to put one site inside another?
What you want is to include any site within yours. For this, the tag iframe must solve implemented like this: <iframe width="1024" height="768" src="http://www.bbc.com"…
-
1
votes2
answers223
viewsA: Hide final time of an event in fullcalendar?
There is the property displayEventEnd she is responsible for this control.
fullcalendaranswered Luiz Santos 3,162 -
6
votes2
answers503
viewsQ: Difference Location.href or Location.assign
What’s the difference between location.href = url and the location.assign(url)? Is it something in Javascript memory consumption? Is there any official recommendation which one to use? I consider…
javascriptasked Luiz Santos 3,162 -
0
votes1
answer1305
viewsA: MSSQL How to find out which table a record has been included or modified
By checking the SQL SERVE forums, this query will return the value of the last Insert: SELECT o.name as ObjectName, last_user_update,* FROM sys.dm_db_index_usage_stats s join sepm01.sys.objects o on…
-
1
votes1
answer396
viewsA: How to organize an array by size automatically?
There is a function that reverses the array in PHP, which is called array_reverse: <?php $input = array("php", 4.0, array("green", "red")); $reversed = array_reverse($input); $preserved =…
-
0
votes1
answer217
viewsQ: ASP.NET MVC Actionlink outside the area
I’m having a hard time making a simple feature. I have an area called "project": The goal is simple: I need to create an Html.Actionlink that generates a link to return the home page that is OUTSIDE…
asp.net-mvcasked Luiz Santos 3,162 -
1
votes1
answer556
viewsA: Condition in Select - SQL
Santos, I believe the solution to your problem is the use of NOT EXISTS, in each query and Union of all. NOT EXISTS NOT EXISTS functions as EXISTS, except for the WHERE clause in which it is used to…