Hi,
I have 2 combo boxes in a form , the second depending on the first.
I want the second combo box to become blank every time i change the selection in the first but be able to make the sel...
Dear Expert,
I have 3 database block
first block is a master block
fields r route_id,route_no,route_name.
and has a sequence for route_id .
---------------------------------
2n...
I have 5 years of SQL Server experience. How to pick up Oracle (just general Oracle database and queries for Java developers) in the shortest time? Any suggestions or material to recommend?
...
Experts,
I am preparing Linux Red Hat for an installation of Oracle 11g. I am currently at the step where i need to add missing required packages. I got dependancy error on a file elf...
I'm looking for a software tool that can map out tables graphically from an oracle database (8i version) can you help me?
I want to save the excel file as pipe delimited.
i tried to do this....
save as (tab delimited) and then
cat xxx.txt | tr '/t' '|' > yyy.txt
Issue: some rows are good. But some ar...
I have an Oracle 9i running in Solaris 8. I need to add a new datafile to the tablespace and I have some questions.
Currently the Tablespace has 3 datafiles one on U1 and the other in U2. U...
I would like to get a list of ALL products that are either original or superceding products based on a group ID. For example I have two tables as follows:
Groups
-------------------------...
i have form has database block, this block has fields ,one of them is active indicator (Y,N) I wrote code in the active indicator suppose when i chose (N) nothing i can change in the other fie...
I want to create a copy of another table but without any data... How to do it in Oracle
Hi,
I have a simple report with our own built in template(created by somebody else). All i want to do is add a line after each row of data. I cant find a way to do that.
Can someone tell...
simple q.
in Oracle 9.2, how to compare LONG Type containing String text to a Column of VARCHAR2.
select * from table1 t1, table2 t2 where t1.long_value = t2.varchar2_value
how can i e...
Hi,
I have a PL/SQL loop that saves the input of a number for each row that has been saved.
Before I save the numbers to the DB I need to sort them from smallest to highest and then set a ...
Hi,
I am using the sql developer 1.5.3, toad 9.7.2.5 as database client tools to connect to oracle 10g, Where i can i see all the list of roles,ganted privileges to those roles though these ...
Hi experts
Please provide me a solution to supress FRM-40209 error message. Here's the requirement - There are about 50 database text items in the form that are grouped accodingly. The user s...
Hi, EE experts,
First is the easy one, and I hope solving this one will help the rest of my challenge.
1) why the column heading separator bar did not make the heading break into two lines?
...