check taht
http://download-east.oracle.com/docs/html/B10255_01/ch1.htm#1023960...
rectoverso
Last Activity: Mar 7 '07, 04:18 AM
Joined: Mar 2 '07
Location:
-
there is an oracle tool that do this.
if you don't find that.
you can do an odbc connection from access to oracle and then insert your data
from access to oracle
but first check for the oracle tool it's a good tool and it works fine...Leave a comment:
-
the function consider the values as string. and for strings 9 is greatest than 24 because it compare it at 2
thanks...Leave a comment:
-
another way is the policy
you can do a policy that restrict the access for a user...Leave a comment:
-
excuse
the script is
declare
i number := 0;
j number := 0;
begin
for c in ( select table_name from user_tables ) loop
execute immediate ' select count(*) from '||c.table_name into i;
j := j + i;
end loop;
dbms_output.put _line(' my total count is '||j);
end;...Leave a comment:
-
you can do it using dynamic sql in the procedure
declare
i number := 0;
j number := 0;
begin
for c in ( select table_name from user_tables ) loop
execute immediate ' select count(*) from '||c.table_name into i;
j := j + 1;
end loop;
dbms_output.put _line(' my total count is '||j);
end;...Leave a comment:
-
try this
insert into table1 using (select * from table2 where <condition> order by field1 )...Leave a comment:
-
sorry the call is
B]begin
gen_nou (to_date('31-jan-2007','dd-mon-yyyy'));
end;[/B][/QUOTE]...Leave a comment:
-
try this for your call
begin
gen_nou (to_date('31-jan-2007','yy-mon-yyyy'));
end;...Leave a comment:
-
if the tables are'nt in this user schema you can revoke the updates privileges to to user from this tables (a user must have a privilege to do an operation in another schema tables)
if the tables are in the user schema so you can write a system trigger that fires updates on tables and thereso block the updates for this user
you can write a system trigger that fires updates in the tables and ver...Leave a comment:
-
i think that your problem is here
l_con.prepareCa ll("{call PIM_TEST()}")
your function has to parameters wich ar'nt null so you call it without parameters...Leave a comment:
-
This occurs when you insert into the child table before inserting in the parent table.
you have to find the foreign keys in the table where you are inserting.
with this keys identify the parent tables, therofore do your insert in the parent tables and thereso you insert in your table.
If you have to insert later in the parent tables (it's no recommended to do that), you can disable the foreig keys in...Leave a comment:
-
- Have you a date_modified column in your table?
if it's the case. Why you don't use this :
select * from
( select * from yourtable order by date_modif desc)
where rownum <= 10...Leave a comment:
-
this can do it;
SELECT OWNER, REFRENCED_NAME
FROM ALL_DEPENDENCIE S
WHERE REFERENCED_TYPE = 'TABLE'
AND NAME = 'YOURVIEW'
AND TYPE = 'VIEW';
You can use a dba view also. You must to connect as sysdba. then script is :
SELECT OWNER, REFRENCED_NAME
FROM DBA_DEPENDENCIE SWHERE REFERENCED_TYPE = 'TABLE'
AND NAME = 'YOURVIEW'
AND TYPE =...Leave a comment:
-
You say that the table is in a separate database. So you must use a database link or create a synonym in your schema for the destination table.
Thank you...Leave a comment:
-
hi,
what is the error message...Leave a comment:
No activity results to display
Leave a comment: