i am having a tree with nodes as A-Z. i need to add data to these nodes from another table such that node A is having data as.. names of all the employees starting with alphabet 'A'..etc
i am...
The Oracle data type BFILE stores a pointer to an operating system file outside of the database, allowing the file to be accessed via SQL, while keeping the size of the database down. Questio...
hi
i have a table in db which has these lines
SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS,
SUPPLEMENTAL LOG DATA (UNIQUE INDEX) COLUMNS,
SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS...
Dear Experts
I wanna know how Can i create a user & grant the select only access to tables of 3 scheemas (namely AMP,ODC & RCL) This user should not have access to create any object ...
hi,
i want to debug my afterUpdateRowTrigger on oracle 10g. is there any debug tool like profiler for sql server 2000?
thanks
Suppose there are two machines..both of them have oracle installed..
both are in internet...I want to access database from first machine through second..
if I am making some modification in...
i created a directory like this
I know the directory name is scott_dir..When I go and look at c directory there is no path like this
'c:\new1\scott';
should i create manually or automatical...
Dear experts -
Here is the situation. I have a string nnXXXXX . I wanted to replace XXXXX with 99999.
Whatever the string that follows after the first 2 characters should b...
Hi, I had configured my flash recovery area on an external drive ( a usb drive). Now the configured drive is missing / corrupt and when I do a startup command I get the followig errror;
SQL...
am creating a simple table in oracle 10g database ,getting the error.
Can some help please .
SQL> create table CREDENTIALS
2 (
3 id bigint auto_increment NOT NULL,
4 ...
i want to insert 1MB CLOB data from flat file into oracle database table
Hi, this is the current set-up:
Backup Server: Windows 2003 SP2 (OS), Legato Networker 7.1.4 (Backup software)
Client: Windows 2003 SP2 (OS), Oracle 10g 10.2.0.1.0 (Database), Networker Mod...
We loss the SYSTEM account's password. How to get SYSTEM account on our oracle database 10g.
Im not sure what Im posting is although possible in Oracle 10g or not.
Take an example, there is a component (.dll or .exe) which interact with Active Directory and return the first name...
Dear Experts,
I develop PHP application on apache web server on my pc with oracle database. It was ok. After installed oracle developer 10g on my pc, the php based web application generates o...
The following update statement is being ran 1 or more times during any given transaction.
An uncontrolable process drops and re-creates the tmp_table before this update statment is ran. Du...
How a staging table is created?
hello,
i have a table in oracel as follows,
machine_no Volume Date
111 2 some date for all rows.
111 3
111 ...
HI, I have a Oracle 10g running on one of my networks. I need to connect to this database from a remote site, how do I do this? I am able to connect to the remote site through isqlplus and th...
emp table is PARTITION BY HASH (emp_no) PARTITIONS 100 and the table has 100 million rows.
The following delete takes a long time. I think it is accessing all the 100 partitions. So how...
We had a power outage that took down our HR perspectives folder while users were editing the database. When we run BRUNNER it gives the error message: "DB Assumed Down because Checkdb.out not ...
Hi
I've created a stored proc that returns a pipelined table.
when I am using SQL+ and doing 'select * from table(store_proc())
everything works great.
when I am trying to call the func...
if i wanted to block OEM and not any other oracle net services can this be done by just blocking a port?
I want to convert data from clob column into the blob column. Is it possible to do that using Informatica?
Hi Experts,
i have to change where condition at the run time in the stored procedure
my stored procedure is as follows
create procedure MyFirstTestProcedure as
( Param1Number;Param2Nu...
