Posts by AlunoOracle • 183 points
14 posts
-
3
votes2
answers1861
viewsQ: How to consult birthday and month in SQL on Oracle?
I saw some examples here, and tried to reproduce them, however, on Oracle does not accept operators as MONTH, then I was unsuccessful. SELECT nome from aluno where month(datanascimento) =…
-
1
votes1
answer112
viewsQ: How to remove add/remove dashboard as you select from checkbox?
I’m adding a panel at the bottom of a JFrame, when a checkbox this selected, and when I uncheck it, remove the panel, and leave only the checkbox, however, I’m not getting, I think the layout…
-
-2
votes1
answer61
viewsQ: How to create a combo with 2 values?
I am completely lost, I am trying to create a combo box, where I can display "a value/text", more, that when giving a getValue on it, I can get another value. For example, I wanted to display, "Item…
javaasked AlunoOracle 183 -
1
votes2
answers378
viewsQ: How to put simple apostrophes and concatenate with a string?
I have a question, I want to be able to concatenate a String, so that it is interpreted with simple apostrophes between it. For example, SQL would look like this: SELECT IDALUNO, NOME,…
-
2
votes2
answers6341
viewsQ: How to get last Quence on Oracle?
I tried 3 different ways, to make one select of the last sequence of my table, but none worked. SELECT SEQ_ID_PAIS.CURRVAL FROM DUAL; Error: ORA-08002: a sequência SEQ_ID_PAIS.CURRVAL ainda não foi…
-
1
votes1
answer419
viewsQ: Date to oracle conversion
I’m having a problem, I’m trying to save a date on oracle with formatted dd/MM/yyyy, however, in the bank it presents the date in the format dd/MM/yy. So, I got the question, if the type I used in…
-
-1
votes1
answer314
viewsQ: Access oracle database remotely
Is there any way to access, or at least import/create my database in some workspace, or oracle server (free)? So it can be accessed remotely. If yes, how could I do this "access" ?
-
0
votes0
answers104
viewsQ: Failed to update to registry
I am having the following problem, when I try to change a registry made by my application, it creates a new record instead of changing. My question is, if when I do the trigger of insertion of the…
-
-1
votes1
answer547
viewsQ: Format measurement field with Jformattedtextfield
I’m trying to create a field to take measurements, I wanted to apply a mask so that it would look like this: The field already starts with 0.00, then if you type value it keeps formatting. And when…
-
1
votes1
answer127
viewsQ: Constrait Oracle Garden
I have a question, when I create a CONSTRAINT UNIQUE , she measures all the columns together? For example, I want a country not to have names or acronyms equal, in which case I must create…
-
1
votes2
answers579
viewsQ: Permissions for an Oracle USER
I am creating an Oracle user for my database, after setting the basics I tried to run my script to create the tabelas and sequences, however, the tool returned me an error saying missing…
-
2
votes1
answer1446
viewsQ: How to insert time into Oracle?
I need to save only the hour and minutes (seconds make no difference, so having or not, whatever) I should use TIME or TIMESTAMP ? I started doing with TIMESTAMP(6), but I’m having a hard time…
-
1
votes0
answers1438
viewsQ: java.sql.Sqlexception: ORA-01000: maximum open cursors exceeded
I’m making the following mistake: java.sql.Sqlexception: ORA-01000: maximum open cursors exceeded From what I researched, the error happens when the maximum number of cursors is exceeded, and to…
-
1
votes1
answer321
viewsQ: problems to create multiple tables in Oracle
I am beginner in the use of Oracle, wore the firebird before. I’d like to know, why I can’t create multiple tables at once in the SQLdeveloper. It creates only the first table (Country). I try to…