Hi Debasisdas,
Yes i am performing DML on the same.
I have checked the object type in the DBA_OBJECTS where distinct output is VIEW,SYNONYM.
User Profile
Collapse
-
How to avoid DeadLock ORA-04020 error (on views)
Hi All,
I have 29 set of jobs which will access the same VIEW, and the jobs will run one after the other
My concern here is the view is going to to a invalid state after processing some of the jobs and it is getting failed for the next job.
When we re-run the job it is working fine.
i need to run these all jobs in a single stretch without going VIEW as a INVALID.
can we have a... -
That is ok Nepomuk, ls -ltr | head -n 10 will 10 lines ...
but my concern is headings of the columns for 'ls -ltr' ..
like
permissions filename size .. etc...Leave a comment:
-
Not exactly external tables .. but the files coming from different upstream systems and get loaded into the database via sql loader.
I want to know for a particular table where the data being populated...Leave a comment:
-
Data Being Populated
Hi All,
Can anybody tell me the solution for the below senerio.
I have a set of tables and they have been populated from different feeds (files)using sql loader.
my concern is how to find out ,for a pariticular table from where the data is getting populated.
Thanks in advance... -
select * from user_tables where table_name like 'ABC%';
This Query will give you all the tables having ABC as it name
select * from user_tab_cols where column_name like 'ABC%';
This Query will listy all the columns having ABC in the column nameLeave a comment:
-
-
ls - ltr with Heading
Can any one tell me how to get the column heading when we type 'ls -ltr ' to list the files in a particular directory..
Thanks in advance -
Delete Duplicate rows without using ROWID
Please can anyone tell me how to delete duplicate rows from a table without using the pseudo column ROWID in the query
Thanks in Advance -
Example
I have procedure to which the user can pass emp id or name of the employee and the output of the procedure is the salary of the given input
here there will be 2 different select statements one with empno in where clause and the other with name in where clause
here i will use the same ref cursor for both the select statements and i can pass the ref cursor as output variable .Leave a comment:
-
-
Hi,
If you want use Group by Clause in your query then you must and should use any of the aggregate function.
or else system will throw an error message like
ORA-00979 :not a GROUP BY expression.Leave a comment:
-
Query required to display a row from table
Hi,
Could you please help me?
The table is given below
Name Phone No
-------------------------------
A 1
A 2
A 3
B 1
B 2
Now I want to display the row as shown below
Name Phone1 Phone2 Phone3
A 1 2 3... -
select max(sal) from (select distinct sal from emp order by sal desc)
where rownum =&n;
enter n =3;Leave a comment:
-
ORACLE 8i Vs ORACLE 9i
Can anybody list me differences or enhancements over ORACLE 8i and ORACLE 9i
Differences between ORACLE 8i and ORACLE 9i -
AdusumalliGopikumar replied to Clarification regarding "Raise Application Error" and "seq_collision exception"in OracleRaise_applicati on_Error is used to defined a user defined exceptions to the stored sub programmes
raise_applicati on_error(-20001,'user defined exception',TRUE/FLASE);
if 3rd arg is TRUE it stores the user defined exceptions in Stack
if it is FALSE then it will clear all from stack
it's range starts from -20001 to -99999Leave a comment:
-
I think this might work now ,
alter table sip add partition by range(si_id)
(partition p1_si values less than (50001),
partition p2_si values less than (100001),
partition p3_si values less than (150001),
partition p4_si values less than (200001));Leave a comment:
-
-
about dblink
can anybody explain me about dblink
and how to connect to other database from one datbase? -
A query using where clause,
group by clause,
having clause
and order by clause.
i got it
select ename,job,deptn o,sal
from emp
where sal>=2500
group by deptno,job,sal, ename
having deptno =10
order by ename desc;
or
select ename,sal
from emp
where sal=(select avg(sal)
...Leave a comment:
No activity results to display
Show More
Leave a comment: