Recent content by Joachim F

  1. J

    Insert ≥ or ≤

    Here we go: PL/SQL Developer Version 11.0.4.1774 01.101712 - 50 user license Service Contract: 1/06/2016 Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1) Physical memory : 4.194.304 kB (1.629.144 available) Paging file : 4.194.304 kB (4.194.304 available) Virtual memory...
  2. J

    Insert ≥ or ≤

    Hmm, even the forum doesn't want my "greater or equal" and "lesser or equal" :-)
  3. J

    Insert ≥ or ≤

    Hello everyone, I'm trying to insert a string with the character "≤" into a table, but when I select after, I get "=", and it's indeed "=" in the database. When I do the same insert on the server locally, with sqlplus, it works fine, and when I select it with PL/SQL Developper, I get "≤"...
  4. J

    Variable Type RAW

    Hello, I would like to test a query with a RAW variable. So I open a new test window but unfortunately, when I want to choose that type in the drop-down list, it doesn't exist. I see well the LONG RAW, but not the RAW alone... Is that normal?? Thanks in advance! Joachim
  5. J

    Alias is confused when the table name and the owner are the same

    Thanks for the update! We've just patched a database recently, to 10.2.0.4.0, and I've done the test right now... Same problem, unfortunately... :-(
  6. J

    Alias is confused when the table name and the owner are the same

    PL/SQL : 8.0.1.1152 and I've also tried with the last version downloaded on the website. Oracle: 11.2.0.1.0 and I've also tried on 10.2.0.1.0, it's the same... Thank you!!
  7. J

    Alias is confused when the table name and the owner are the same

    Seems that I've found some tricky thing with aliases... I give an example, it's easier: I connect with user DEV, who have the necessary grants to see all the tables in the schema CUSTOMER. Inside that owner CUSTOMER, there is a table CUSTOMER. select * from CUSTOMER.CUSTOMER c where c...
See more
Back
Top