Hi,
One of my friends was able to get this through in case of a fixed set of rows..
Here is the way you can do it.
create table temp_trans(
col1 varchar2(10)
)
Suppose you insert 3 rows in the table--- then,
select max(decode(rownum, 1, col1, null)),
max(decode(rownum, 2, col1...
Santa,
Your questions are valid. But basically, there is no business requirement to achieve this. My friend was asked this question in an interview and we were wondering if this is possible.
Assume that the table is a restricted one with finite number of rows - we can assume it to be 10. Since...
Suppose I have a table with only one column. When I query the table
SELECT COL1 FROM TABLE1;
This gives me the result
COL1
-------
VAL1
VAL2
VAL3
VAL4
...
But my requirement is to have the display in the format
VAL1 VAL2 VAL3 VAL4 ...
Is there a way to achieve the above?
Regards.
Need to get some information related to Character set UTF-8 and ISO-8859-1
Version 9i
Currently when we implemented UTF-8, every special character occupied an additional byte. This means that we need to possibly double the field length in the oracle table.
To avoid this, can we implement...
Hi All,
I am using Informatica for my ETL processes. I have a couple of fact tables and 5 aggregate tables. After my daily load, I would like to analyze all the indexes in the fact and aggregate tables.
Is there a way by which I can dynamically analyze the indexes of a particular table after...
Hi,
I currently have a summary table that is created in a very complex manner. This summary table consists of data for each and every user and his security access. The front end queries this table with filter conditions such as userid, and other components.
This table is running into a lot of...
Thank you very much maswein and mufasa...
I was able to come out with a different solution for the same.
I used flags in the master table that indicates inclusion or exclusion. Depending on the flags I use Case statements for joining the columns correspondingly.
Actually, I wanted to solve this...
HI..
there is no fixed list. what i gave was just an example.. all the 3 columns could be like the one i explained.. thats the reason why i have trouble finding a solution.
I have a master table with following columns
Table1
-----------
Code
Type
LookupValue
Code and Type columns are primary keys.
The sample data for this table will look like this
Code Type LookupValue
-------------------------------------------------------
A all 1
B exclude X 2
C...
I have a master table with following columns
Table1
-----------
Code
Type
LookupValue
Code and Type columns are primary keys.
The sample data for this table will look like this
Code Type LookupValue
-------------------------------------------------------
A all 1
B exclude X 2
C...
When you login into desktop, do you login as that same user or as an Administrator. So would this issue relate to any Security Filter (on that attribute).
The other possibility could be element cache. You could delete all the Cache objects for that project and then try listing the elements.
Hi..
I have a number of packages. A few of them are invalid. I use Embarcadero RapidSQL as a tool for querying purposes.
The problem is that when I try to validate the packages by recompiling them using the click options of the tool, one or more other packages automatically gets invalid.
I am...
I realised that the application updates table2 but defers a commit on it until the entire transaction is complete. In the meanwhile, the plssql tries to select from table2. I verified that the plsql doesnt select anything from table2.
when i insert the record manually in table1, this does not...
Hi,
I have a front-end application that inserts a record in a table. There is an insert-update trigger on that table(table2) that calls a pl-sql.
there is a piece of select statement in the plsql block.
*********
select col1, col2, col3
into var1, var2, var3
from table1
where cond1
*********...
Is there any institution that provides certification in Datawarehousing technology.
Would be interested in knowing of any such ones.
thanks in advance.
Thanks for the article, but I have some doubts.
Whenever we use select from a view, Oracle executes the underlying sql (contructing the view) at run time.
If I have updated the view, from where will Oracle get the updated data.
Does this mean that updatable views are physically stored?
this is something that i have not heard of. is it even possible in oracle??????
why dont you update the table..
or if u still want to make some conditional changes, modify the sql used to construct the view.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.