Database Design For Storing Client Address Information For All Its Branches?

Jul 27, 2012

I have to design a database so that the performance is optimum and joins are optimum between tables.

Requirement - I have several banks as clients globally, like HSBC, RBS, AMEX etc. Each bank operate globally, and are divided like the geographies, regions etc. For eg. HSBC is operating from US, UK, ASIA, AUSTRALIA. Each geoagraphy is further divided/childs, like, in ASIA has INDIA, PAKISTAN, SRI LANKA, CHINA. Further, it is divided, like in India, it has cities like DELHI, BOMBAY, CHENNAI etc., then further it has within Delhi - Lajpat Nagar, Rohini, Pashim Vihar etc.

As per the above scenario, I need to store addresses, phone numbers, of all the branches of all clients. Also, there is one more condition like in the above defined hierarchy, later on, a new hierarchy can be added, like In INDIA, it can further divided in States and then its local cities.

View 3 Replies


ADVERTISEMENT

Forms :: How To Get Client IP Address

Feb 15, 2010

method to get the ip address of Client machine using oracle forms .

I am using Oracle forms 6i and application server 9i.

View 9 Replies View Related

Forms :: Get Client IP Address Using 10g Rel.2?

May 2, 2011

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 ?

View 2 Replies View Related

ODP.NET :: How To Get IP Address And Machine Name Of Client

Oct 15, 2012

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.

View 8 Replies View Related

SQL & PL/SQL :: Retrieve IP Address For Client Who Do The Transaction

Apr 19, 2011

am using oracle 10g

and i want to retrieve IP address for client who do the transaction

and i try to using some selects like select terminal from v4session but it return the IP for application server

so i think to use commands ipconfig

how can i call windows commands by oracle

View 8 Replies View Related

SQL & PL/SQL :: How To Grep Client IP Address When LOGON

Aug 4, 2011

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]....

View 13 Replies View Related

Client Tools :: How To See Information Before Commit

Feb 24, 2013

I want to see the pending operations before commit. How can I view what operations are going to commit when I enter the commit.

View 7 Replies View Related

What Will Be Database Design Of Any Food Shop

Mar 21, 2009

i am a beginner in database design.i want to know what will be the database design of any food shop like pizza hut..i have created some tables...i am confuse with design of order table..

employee_details
-ID primary key
-name
-address
-date_of _joining
-salary

product_details
- category_name ,foriegn key
- product_name,primary key
- category
- unit price
-discount

categories
-category_name , primary key

View 3 Replies View Related

Client Tools :: SqlPlus Version - How To Get Bit Information

Sep 26, 2013

Oracle client version whether it is of 32-bit or 64-bit.

Microsoft Windows [Version 6.0.6002]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.

C:>sqlplus -v
SQL*Plus: Release 10.2.0.1.0 - Production
C:>

it shows me only version not bit information.is there any other command to get it.

View 26 Replies View Related

Oracle 11g Client / ORA-12533 Illegal ADDRESS Parameter

Jul 10, 2011

I am working on a database application which works as a data access layer. The application uses OCI interface to connect and query to the Oracle Database. This application is certified on Oracle 9i and 10g client and works fine without any issue, but when I am certifying the application on Oracle 11g client, I am getting connection failed problem and following Oracle Error is displayed.

ORA-12533 illegal ADDRESS Parameter.

There is no change in the environment setting between Oracle 10g and Oracle 11g.

Following are the details of the environment

Version of Oracle 11g client is 11.1.0.6.0
Version of Oracle Database is 11.1.0.6.0.
Platform - Solaris 5.9 on sparc v9

On enabling client trace with support level also does not work. It shows TNS error TNS-12533 illegal ADDRESS Parameter.

what could be the possible reasons that the connection is failing with Oracle 11g client, while the same is working with Oracle 10g client. As I said there is no environmental difference when performing this test. The only change is ORACLE_HOME setting for the corresponding Oracle client version.

View 2 Replies View Related

Forms :: Get Client IP Address And Machine Name In Oracle 10g Without Webutil

Sep 26, 2013

How can we get client ip address and machine name in oralce forms 10g without webutil.

View 3 Replies View Related

Database Design - Multiple Irrelevant Fields

May 15, 2009

I am designing a database as a practice exercise, but have come across a problem.

Here is my design:

Branch Manager Employee
------- ---------- ----------
BranchID ---- ManagerID |---- EmpoyeeID
... | EmployeeID ---- ...
Manager ---- EmployeeIDOfManager
...
Branch

Note: The ... in the tables are just placements symbolizing that there are multiple irrelevant (to this thread) fields.

The problem is with the field highlighted in italics whilst the primary keys are in bold. I need to somehow retrieve that ID, but I can't create a many-to-many relationship.

View 14 Replies View Related

SQL & PL/SQL :: Storing Images In Oracle Database And Publishing On Web Page

Jan 21, 2012

I have a web page written by pl/sql and html which some jpg files are published. Currently they are linked by html from a directory source. There are almost 70000 files which makes 1.15 gb. I want to store them in our oracle database but I have never done this before.

What I want to learn is how will be the performance for selecting from many jpg files with select statement and how much space would they keep in the database?

View 9 Replies View Related

Server Administration :: Size Storing JPG File In Database

Feb 13, 2012

I am storing customer's snaps in a table ( column's data type as LONG RAW) using oracle forms Webutil. Now there are 250 snaps in the table. The file type of these snaps is JPG with the average size 30KB.

I made a backup using export utility before storing these snaps and the exported DMP file's size was 36MB. Now after storing these just 250 snaps of 30KB the DMP file's size is gone over 300MB.

i need to change column's datatype? or some where in oracle forms's image item. Because on window's file system the size of these files is just 8MB.

View 8 Replies View Related

QUOTE V$DATABASE Displays Information About Database From Control File

Feb 8, 2011

The documentation for v$database says: QUOTE V$DATABASE displays information about the database from the control file. Is it safe to assume that there will only ever be one row queried from this view?

View 2 Replies View Related

SQL & PL/SQL :: Display Office Address / House Address And Emp ID In Single Query?

Feb 23, 2013

I have two tables emp , emp address as below

emp table :
emp_id emp_name,
1 rajesh
2 suresh

emp address table :

emp id emp_addresstype emp address
1 O kukatpally
1 H Hitech
2 O Kolkata
2 H hydar nagar

I need the query to display the Office address & House address & emp id in single query

ex: 1,Kukatally,hitech
2,kolkata,hydarnagr

View 3 Replies View Related

Changing A Lot Of Information In Database

Feb 18, 2011

I have been implementing a script to change a lot of data in a database production.Because of this the database will be 100% dedicated to the execution of that script, in the sense that nothing else will be running in this period (the application will be stopped).

what can i do to improve performance of that execution? is there any oracle manual online for this type of problem? I do not know if it's possible, but I'm thinking of things like disabling locking mechanism (if possible I could run instead of a process many processes in parallel), disabling index growing (during the process), disabling constraints.

View 1 Replies View Related

Forms :: Image Path Save In Database And Image Name As Design Number?

Jun 3, 2009

I create a simple table for image

CREATE TABLE image_table (
Design_no varchar2(10),
filename VARCHAR2(255) PRIMARY KEY,
image LONG RAW);

Then i create simple block of image_table

its show me in this website [URL] My question is i don't want to give my form path always.i want to save my picture path in my database and the name of my picture always same as my design_no column.

For example i want to save a picture in my database i will copy my picture in d:shahzaib1234.jpg now i want the path d:shahzaib save in database and when i copy my picture which path= d:shahzaib and file name = Design no its will automatically save in database.

View 4 Replies View Related

Security :: How To Find User And IP Address From Oracle Database

Jun 19, 2013

Last week we have realized that a user who connects through SQL Developer(as nothing wrong found in application server logs) has made a serious change in the database which created a real mess. The user has done some mischief in some calculations by making some inserts and updates in some important tables in our production database.

How can I find which user or from which IP the change is made.

View 6 Replies View Related

PL/SQL :: Find Database Server IP Address And Port Number

Aug 21, 2012

Is it possible to find the Ip address and Port number of a database server in Oracle 10g version?

actually i wanta to connect it through Putty.

View 7 Replies View Related

Server Administration :: How To Get Hardware Information From Database Level

Nov 22, 2010

How Can We Get Hardware Information In Oracle Database 8i for example harddisk size,volume,processor etc. i want database run only specified harddisk

View 1 Replies View Related

Tnsnames.ora File Cannot Handle Connection Information For More Than One Database

Mar 12, 2007

I am having problem with my tnsnames.ora file.seems the file cannot handle connection information for more than one DB. It worked fine in the beginning, after that, whenever i had to connect to a DB, i had to keep switching and renaming 5 files, with respect to whichever database I want to connect to. this is the entries in the file, for 2 D's and it wont work, with just one in each it works, but not for two...

newtpt =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp)
(PROTOCOL = TCP)
(HOST = ipadd/virtualname)
(PORT = 1521)
[code]....

I am sure, nothing wrong with teh IP/virtualname, cause with just one of these in the file, they work excellent.I tried leaving line between the connection strings for each DB, without leavin lines, etc..

View 2 Replies View Related

Slow Database - V$session Has Lots Of Active Sessions With 00 As Sql-address?

Oct 1, 2012

Server:
Windows 2008 R2 x64
Oracle Database 11g Release 11.2.0.1.0 Standard Edition

I recently applied the Oracle® Database Server Version 11.2.0.1 Patch 16 I have several databases running on this box with the same application.Since then I've had lots of customers complaining about slow systems. The server has plenty of RAM availableI also have several other servers all on the same versions, same patch, running the same application with no issues.

Looking at v$session there are often lots of active sessions that have a sql_address of "00". I've never seen this before and I regularly look at v$session, as you can see for below these have been running for a while. The sessions do drop off but I am at a loss as to what is happening.

select username, last_call_et, sid, serial#, user#, status, sql_address, sql_hash_value
from v$session
where username is not null and status = 'ACTIVE'
order by last_call_et desc, sid

[code]...

View 8 Replies View Related

Forms :: Get Client IP Address When Initializing Forms

Jun 25, 2010

How to get the client machine IP in Forms 10g without using webutil? I know the function Webutil_clientinfo.get_ip_address. But Webutil is not working in when new form instance. And I need get client ip address in trigger PRE-FORM.

sys_context('userenv', 'IP_ADDRESS') return address of server, not client.

OR

How to make the trigger WHEN-CUSTOM-ITEM-EVENT in Webutil starts before triggers "WHEN-NEW-FORM-INSTANCE" and "PRE-FORM" ?? To use webutil_ clientinfo.get_ip_address

View 30 Replies View Related

SQL & PL/SQL :: Retrieving Names Of Tables That Contain Similar Information In Oracle Database?

Nov 16, 2010

it's possible to retrieve the names of tables that contain similar information in an oracle database.

View 7 Replies View Related

Server Administration :: IP Address / Host Name Or Domain Of Oracle Database Servers

Mar 27, 2012

Due to some some Network issues . we have planing to move oracle database one domain to another domain changing domain name and IP address of oracle database . if want to change oracle database 10g(10.2.0.5.0) 32 bit windows version what are setting s to change in oracle database.

View 3 Replies View Related

Client Tools :: Can Use Oracle Client Version To Create A Database In That Server

Jan 13, 2011

can we use oracle client version to create a database in that server.

View 3 Replies View Related

Client Tools :: How To Connect From Client To Oracle Database In Unix

Dec 11, 2012

I have new virtual UNIX machine and I installed oracle client on /usr/lib/oracle. Also I have a oracle database and I am able to connect to this database from my desktop sql developer.

So now I am trying to connect from new UNIX machine. Where I created tnsnames.ora file under /usr/lib/oracle/network/admin and before connecting did export the following

export TNS_ADMIN=/usr/lib/oracle/network/admin
export ORACLE_HOME=/usr/lib/oracle/
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$HOME/bin:/sbin:$ORACLE_HOME/bin
export ORACLE_SID=VFIODSD1

when I try

# sqlplus
username :xxxxxxx
password : xxxxxxx

ORA-12545: Connect failed because target host or object does not exist. Not sure what I missed here. using same tns file I am able to connect from sql developer on windows.

View 1 Replies View Related

HR Schema And Jsf Web Design?

Jul 13, 2013

how can ı reach hr schema I watched alot of video and have read so much writing from oracle but my data base haven't HR schema table like
emlployees
countries
jobs

how can ı add these hr schema
2) how can ı create web page with adf web applicaiton jsf

1) adding a search button
2) search fieldand I need to list my search results

View 1 Replies View Related

SQL & PL/SQL :: How To Design Subprogram Which Can Generate Pk Value

Sep 15, 2011

i mean which can generate a primary key when the table name and column name are passed as parameters

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved