I supposed that Title & Gender are realized through MiddleName field. If MiddleName's values in (Thi, Dieu) then Title is assigned as Ms, and Gender = "F". Otherwise, Title = "Mr", and Gender = "M".
2/ Another procedure/function is [i]ParseAddress with the requirement as:[/i]Address field is divided into Street, Group, Area, Ward, County fields E.g.:No 6 Sum Street - Group 8 - Area 2 - ABCD Ward - London
The result:
StreetGroupArea Ward County No 6 Sum StreetGroup 8Area 2ABCD London
I have tried coding by Visual Basic, it is OK. But if I interpret to PL/SQL ->it doesn't work.
How do I select the name in an email address. I would like to be able to order a list of email addresses by the name of the person ie. what comes before the @ sign.
So is there a query I could use to get everything before the at line . So in pseudocode I would need to be able to do something like this.
select substr(email, indexOf(@)+1,email.length) from table order by email
how i can get Client IP address using Forms 10g Rel.2 and if other useful information i can get, how is it possible? is there any other solution if not using WebUtils ?
The pipe separator needs to appear only when values found in addr1 or addr2 or addr3.
WITH address AS (SELECT 'Silver Arc Plaza,' addr1,'4th Floor, 20/1, New Palasia' addr2,'Indore' addr3 FROM dual UNION ALL SELECT 'Shop No. 1,Vishnu Priya Building,' addr1,'' addr2,'pune' addr3 FROM dual UNION ALL SELECT 'D/7, Siddhivinayak Nagari,' addr1,'Nr. Majura Gate, Ghod dod Road,' addr2,'' addr3 FROM dual UNION ALL SELECT '' addr1,'B 4, Gold Coin Complex,' addr2,'Ahmedabad' addr3 FROM dual UNION ALL SELECT '' addr1,'' addr2,'' addr3 FROM dual) select addr1||'|'||addr2||'|'||addr3 address from address;
The title for this new topic is self explanatory. Since PostgreSQL has data types for storing IPV4 and MAC address and Oracle don't, I would like to know the right way to store this values so we can do different operations and validations with these network address.
I been doing some research but I don't like the solutions like storing just number values whit out any validations like PostgreSQL.
I want to write a SQL statement to search valid city name from address field. Valid city names are in one table and address column is in another table.
I am running 11.2. Within a DB trigger, I need to capture the IP address of the client making the change. I see there is a SYS_CONTEXT('USERENV','IP_ADDRESS') built in. Is this the correct way to capture the IP of the client making the change?
I'm using Oracle 9i. I want to make an address: city, state zip.
However, if there is no city or state, I don't want the comma. Doing this in decode made my head swim, so I went to case. I think that I mapped it out well, but I cannot have the variable on each section. This is my currently incorrect code.
CASE WHEN LENGTH(TRIM(AG.CITY)) = 0 THEN ST1.CODE || ' ' || AG.POSTAL_CODE ELSE WHEN LENGTH(TRIM(ST1.CODE)) = 0 THEN AG.CITY || ' ' || AG.POSTAL_CODE ELSE AG.CITY || ', ' || ST1.CODE || ' ' || AG.POSTAL_CODE END ATTY_CITY_STATE_ZIPI'm trying to stick the end-product into ATTY_CITY_STATE_ZIP.
in listener.ora, if i use localhost, or computer name, then everything is ok, but when i try to use ip address, then I got a error ORA-12541: TNS:no listener
the only change is use the ipaddress of the server 10.183.7.89 instead of localhost, and if I change the ip address to the computer name, then its also working well.
The server is running on visual box, i don't know if the vistual machine cause this problem, I just want to confirm: I can use the ip address directly right?
On cliente/server, I used to get the user IP address using SYS_CONTEXT and IP_ADDRESS, and the terminal name with SYS_CONTEXT and HOST.But in web environment, these functions returned Server IP and name.I have to build a trigger to obtain the information of user IP address and terminal name to save on audit table.
I've got table with mixed address column, it consists of Country, City, House No, App. No, postal code, the data is all stored in a single column with delimiter characters. In most cases order of parts is the same, but not always. In most cases parts have appropriate prefix - h. for House No, App for App. No, c. for City (it's not English language), but not always.
How do I divide mixed address column into parts? I know there are certainly "professional" tools out there for address matching and corrections, but even these can struggle. I know also that trying to normalize postal addresses is almost always wrong idea.
That's technical task of Customer... I should divide at least 90% of rows into appropriate columns. The quantity of rows is too big for human eye.
How to grep client's IP address when LOGON to database? I write a trigger , but when compile , it show Error , Here is code :
CREATE OR REPLACE TRIGGER On_Logon AFTER LOGON ON The_user.Schema DECLARE v_addr VARCHAR2(11); BEGIN IF (ora_sysevent = 'LOGON') THEN v_addr := ora_client_ip_address; raise_application_error( '-20001', 'user IP: '||v_addr); END IF; END; [code]....
I have a sql to pull all payments from vendors for a specific time period; however, now tasked to only show the Address of each Tax Reporting Site. I have tried several commands but have not been successful.
trying to get oracle-xe-universal_10.2.0.1-1.0_i386.deb rolling on Debian/6.0.1a which coincidentally is on another server, not on my desktop, so I obviously can't reach the web frontend at 127.0.0.1:8080. And I couldn't trick it with a simple TCP proxy on the server:
nc -l -p 80 127.0.0.1 8080 and then on the client: telnet 192.168.0.252 80 bailed out with an error invalid connection to [192.168.0.252] from (UNKNOWN) [192.168.0.1] 35798
So, is there a way to change the listening IP address, or to allow IPs other than the local host to connect? I've tried some googling around,.
I am an OEM Gird Control 11g server with Oracle 11.2.0 running on OEL 5.3
I also have 2 node RAC cluster running Oracle 11.2.0 on OEL 5.3. I have installed OEM Agent on nodes of this cluster. I can see them on OEM Grid Console. When I check the configuration of the Database Instance GTRD1 (one of my target instance)I can see that the "Listener Machine Name" is the management IP address of target database server. Similarly Database Instance GTRD2 has the management IP address of target database server. When I click test conenctions it works. This is without entering any reference to this server/IP address in /etc/hosts file.
But when I select targets->all targets->Database Instance GTRD1 and then try to access performance tab, it does not connect. I get this error "The Network Adapter could not establish the connection"
Looking at the "emoms.trc" I find the follwing
2012-04-30 14:02:12,071 [EMUI_14_02_12_/console/database/instance/sitemap] ERROR perf.sitemapPerfChart logp.251 - java.sql.SQLException: The Network Adapter could not establish the connection
The Connect Descriptor was (description=(address=(host=GTRD-scan.GTRD)(protocol=tcp)(port=1521))(connect_data=(service_name=GTRD1)(instance_name=GTRD1)(UR=A)))java.sql.SQLException: The Network Adapter could not establish the connection
The Connect Descriptor was (description=(address=(host=GTRD-scan.GTRD)(protocol=tcp)(port=1521))(connect_data=(service_name=GTRD1)(instance_name=GTRD1)(UR=A)))
But when I enter the scan address in the /etc/hosts as "112.5.14.154 GTRD-scan.GTRD" Then everythign work works. NOTE: 112.5.14.154 is GTRD1 server and 112.5.14.155 is GTRD2 server
Now my questions are: 1. Do I must enter scan address/ref "GTRD-scan.GTRD" in /etc/hosts? 2. Is there are way to change it to use hostname or the IP address? 3. If I am to use scan address, then how I refer to the other IP address in hosts file?
I'd got this error, TNS-12542, address already in used on my multithreaded application.
After finding some documents about this error, it happen because other application used same port as my listener. But i'd assured that only my listener, but it didn't happen in the first running process, but after some processes (hundreds of processes).
