Posts by Harisson Ford A. R. • 105 points
4 posts
-
0
votes1
answer309
viewsQ: How to create a sub-select in oracle in a composite key table?
The table has a composite primary key, and the fields are a date (ID_DEPURACAO) and a number(SEQ_DEPURACAO). What I want to do is a sub-select that takes only data greater than a given date and that…
-
1
votes1
answer1031
viewsQ: How to set a maximum size for a BLOB field?
I want to insert images and I want each record to have at most 100M, if this value is exceeded should be returned an error in the database itself. For example illustration of the problem: (in the…
-
1
votes2
answers6151
viewsA: Which Mysql command kills the process if a query takes more than 20s to execute?
To list base processes and only execute the following command: SHOW PROCESSLIST The list of processes that are active will be displayed. To kill the process just check its ID and type: KILL…
-
8
votes1
answer558
viewsQ: Is it possible to define a connection pool for each user of an oracle database?
I searched the oracle documentation and only find ways to change this image, but nothing about creating another. Does anyone there know if it is possible what I am ordering? And how to proceed?…