Search results for query: *

Hi, Presuming that both the dates are of the same datatype(Date), it is not necessary for casting them. By the way, DAY TO SECOND in the query ? If its an alias , then wrap it in quotes like SELECT org,workbasket,task, AVG(close_date - creation_date) "DAY TO SECOND",COUNT(task_id)...

How do you plan to do it? SQL or any other tool ?

Hi, The upgrade /Migration paths from older releases to Oracle 9i is like this: • For version Version 7: o Migrate to Oracle 8.0 or Oracle 8i o Upgrade to Oracle 9i How are you trying to get data from version 9 to 7 ? If you are trying through links, then its recommended to...

I suppose you are missing "and" after line_id=1

Just to add some points to my earlier reply, The view, v$sqltext, does contain the full text of recent SQL statements. There are some problems though with this information. It does not contain bind variable values, so the actual rows affected are not recorded here. The view, v$sqltext, does...

I think you can query v$sqltext and get the last DML issued from sql_text

hi, You dont have to resummarize the totals everytime rows are added/deleted. Create a trigger on table A- on insert/delete where in you can add/substract the new values to the already existing total in Table B.

Did you read through the documentation or help ? I suppose thats elaborate..

Though there's no round-about solution, we make sure that the target is having a width equal or more than the source.

try : select 'drop table '||table_name||' cascade contraints;' from user_tables;

if you are asking for the syntax: create global temporary table test1 ( c1 number, c2 number)<on commit delete rows>; the on commit parameter is optional and can have one of these values : delete rows(this is default) /preserve rows

yes, But the OP was asking how to check the status of the trigger .

you can check in user_objects for status where objecT_name=trigger name and object_type='TRIGGER'

try this: select * from ( select a.*, row_number() over ( order by timestamp desc) rn from table1 a where TIMESTAMP >to_date('08/03/02 03:06:59','mm/dd/yy hh24:mi:ss')) where rn=1

It doesn't seem to be a java class.

you can check on the status of the trigger. It looks as though the trigger is disabled.

Firstly, I would say that - Like Microsoft's Transact-SQL (T-SQL)is to SQL server , So is PL/SQL to Oracle. So basically, PL/SQL is a language for Oracle , If you are asking if there is any difference between PL/SQL and T-SQL then , I would say, yes, there are vast differences.

Hey, I got it. set verify off Thanks for your time,anyway

Hi, I have a script that accepts a variable and then some queries with this variable. eg: set pages 0 set feedback off accept new prompt seqid Select count(*) from T_LE_PROFILE Where le_id >= &new and rownum < 5; Select count(*) from T_LE_ADDR Where le_id >= &new and rownum < 5; Now, when...

or maybe, you can try to give &quot;read-only&quot; ie select access on the tables that are in the objects.