Posts by Simone Xavier • 122 points
10 posts
-
0
votes3
answers165
viewsA: Does not display user names in Jquery Alert
Below solution based on the solution given by Wallace Maxters, adding the application of the class "active-i" in the elements. $('.innerbox_contatos_search').click(function(){…
-
-1
votes1
answer75
viewsQ: How does Oracle act after running a PHP script without a commit?
If I run a series of SQL commands with Oracle database, OCI library, without running the commit and defining that it will not be done commit automatic. What will Oracle do at the end of running the…
-
0
votes3
answers5980
viewsA: Column Size with Datatables
The only way it worked for me was: Add the CSS below #table-clientes{ table-layout: fixed !important; word-wrap:break-word; } And in HTML put the percentage, example: <th style='width:…
-
1
votes2
answers295
viewsA: Report showing the Column Index
To do this you will need two cursors, one for the rows and the other for the columns. Below is the solution: DECLARE nome_tabela VARCHAR(32) := 'CLIENTES'; nome_coluna VARCHAR2(32); id_coluna…
-
4
votes1
answer181
viewsQ: How to replace each occurrence of a regular expression match with a different value?
I have a text (html code) with several images in standard HTML format: <img src="X" atributos /> I need the value of the attribute src is replaced by the identifier CID:# where # is a unique…
-
0
votes3
answers22309
viewsA: IF condition inside a WHERE - ORACLE PL/SQL
If the idea is to use the parameters only when they are filled in, then you can do it as follows: ... WHERE A.CARTAO = NVL(IN_CARTAO, A.CARTAO) AND M.ALT_MEMBER_ID = NVL(IN_CPF, M.ALT_MEMBER_ID) See…
-
0
votes3
answers866
viewsA: print value of a given array with PHP
Assuming that this vector is in the variable $vector. Code for printing the price of a specific item, for example of the first (heading 0): echo $vetor[0]->product_price; Code to print the price…
-
3
votes1
answer231
viewsQ: How to simulate a radio type input to the screen reader?
I’m doing a satisfaction survey that should be accessible to users with screen reader. For each question answer options containing a text are shown "Great, Lousy, ..." and an image corresponding to…
-
2
votes1
answer12023
viewsA: Insert TIME DATE on Oracle
Solution: to place the NVL within the TO_DATE INSERT INTO tabela (codigo, datahora ) VALUES (1, TO_DATE(nvl('','19/07/2017 19:49:00'),'DD/MM/YYYY HH24:MI:SS')) Justification: The function NVL you…
oracleanswered Simone Xavier 122 -
0
votes2
answers1159
viewsA: Oracle reference the type of a column equal to the type of another column
A solution follows below. To simplify I considered that its report function would return a table with the fields name and amount. Solution link running on SQL Feedle: http://sqlfiddle.com/#!…