Posts by Guilherme Reis • 179 points
7 posts
-
0
votes1
answer1929
viewsA: Imacro how to restart or continue the script
As described on iMacros’s website, it does not allow the use of conditionals, by the way it was developed. The iMacros language itself is Designed as a descriptive language (similar to HTML) and…
-
7
votes2
answers628
viewsA: How do I search a combo field as I type the text?
Only with Bootstrap you cannot accomplish this task. At this link you can find 30 examples in jQuery that do this job. Look for what best suits your needs. Some of the examples can also be found…
-
2
votes3
answers10183
viewsA: What is the difference between UNIQUE and PRIMARY KEY in Oracle?
As said at that link of SOEN The primary key: There may be only one for table In Oracle it cannot be NULL It is unique and is the main means of relating Tables desired. The key Unica: There may be…
databaseanswered Guilherme Reis 179 -
2
votes1
answer3140
viewsA: How to convert this date to datetime in oracle?
I don’t know if I understand, see if this is what you wanted: SELECT TO_CHAR(TO_DATE('27/12/2016 16:31:39', 'dd/mm/yyyy HH24:MI:SS'), 'DD/MM/YYYY HH24:MI:SS') DT_C FROM DUAL; To show the…
-
0
votes2
answers1924
viewsA: Create Trigger for Quence in Primary key
Good afternoon André, Sequence already acts as a Trigger. At the time of Insert you can call passing the nextval in values: INSERT INTO nomeTabela (seq_hospede_1) VALUES (seq_hospede_1.nextval);…
oracleanswered Guilherme Reis 179 -
0
votes3
answers102
viewsA: Take Report with zero months
To also display NULL values we need to use a function that replaces the null value with a desired value, in this case 0. Depending on the database you are using the syntax changes but in oracle is…
-
3
votes2
answers150
viewsA: Is it possible to apply to different computers simultaneously performing CRUD?
If you need to use CRUD on multiple devices, you can do using a bank or a file (.txt for example). But if you really need to access the same data from multiple devices simultaneously search on…