Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ManjulaMadhu

    AVG function with dates and intervals

    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)...
  2. ManjulaMadhu

    split existing field

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

    insert data from table oracle 7 to table oracle 9i

    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...
  4. ManjulaMadhu

    Invalid column name error

    I suppose you are missing "and" after line_id=1
  5. ManjulaMadhu

    Which View or Table contains user SELECT text?

    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...
  6. ManjulaMadhu

    Which View or Table contains user SELECT text?

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

    Summary of Records in Second Table

    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.
  8. ManjulaMadhu

    Need good documentation for understanding DataStage

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

    Data Truncation in Version 6

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

    sql to create sql

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

    temporary tables in oracle

    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
  12. ManjulaMadhu

    trigger stopped firing SQL 2000

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

    trigger stopped firing SQL 2000

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

    Date Comparison giving false results

    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
  15. ManjulaMadhu

    Java Math Class

    It doesn't seem to be a java class.
  16. ManjulaMadhu

    trigger stopped firing SQL 2000

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

    PL/SQL vs. SQL Server

    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.
  18. ManjulaMadhu

    accept a variable in sqlplus

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

    accept a variable in sqlplus

    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...
  20. ManjulaMadhu

    Rad Only Access Question

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

Part and Inventory Search

Back
Top