Search results for query: *

Frederico is correct, if you do not have "FUNCTION" indexes for those conditions, the explain plan will show "FULL TABLE SCAN's". And . . . SQL #1 would definitely be faster. [3eyes] ---------------------------------------------------------------------------- The person who says it can't be...

You can use wget or curl [3eyes] ---------------------------------------------------------------------------- The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Try something like this: DEF Owner_='SCOTT' DEF Newusr='NewUser' SET LIN 120 PAGES 0 TERM OFF ECHO OFF VER OFF SPO Grant_ddl.sql SELECT CASE WHEN Otype = 'TABL' THEN 'GRANT SELECT, INSERT,UPDATE,DELETE ON ' || Owner|| '.'|| Oname|| ' TO...

If your EMPLOYEES table has no rows, the cursor does not return anything DUH! [banghead] ---------------------------------------------------------------------------- The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

If you want to receive any help, you will need to: Write a clear explanation of the problem in proper English, with proper grammar and punctuation. Do not post in all capitals or use IM-speak like "U", "Ur", "U r", "Plz", "prb", "qry" or any acronym that is not well-known by the community...

And what conditions define the "original team"? Post the query that base on a person just gets this "original team". [3eyes] ---------------------------------------------------------------------------- The person who says it can't be done should not interrupt the person doing it. -- Chinese...

If your source file is named "test.txt", you could try something like this: awk ' $0 ~ "Test Case Number" {t=$NF} $0 ~ "Transaction Type" {if($NF=="Sale"||$NF=="Refund"){print t": "$NF}} ' test.txt [noevil] ---------------------------------------------------------------------------- The...

First you need to explain (clarify) what you mean by "...copy from the line that says "Test Case" to another "Test case" Post an example of the results you expect. [3eyes] ---------------------------------------------------------------------------- The person who says it can't be done should...

Remove the "[@]" from "for i in $userarray[@]", it's not necessary. [banghead] ---------------------------------------------------------------------------- The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

No it doesn't, because you are omitting the duplicates -- or -- is it you only want to update ONE of the duplicate rows? [banghead] ---------------------------------------------------------------------------- The person who says it can't be done should not interrupt the person doing it. --...

BITMAP. :p ---------------------------------------------------------------------------- The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Try this: awk -vexpected='/f2:200,/f2:201,/f2:300,/f2:301,/f2:600,/f3:600,/f4:400,/f4:500,/f4:600,/f5:400' 'BEGIN{n=split(expected,x,","); for (i in x) print "Expected#"i,x[i]} { for (i=1;i<=n;++i){ f0=substr(x[i],1,3);s0=substr(x[i],5,3);s=$1;f=$2; if (f0==f&&s<s0) {printf"%s %s <...

As posted above: ---------------------------------------------------------------------------- The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

1) Configure rman (just once): CONFIGURE DEFAULT DEVICE TYPE TO DISK; CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET; CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'Y:\orabackup\ORCL\%d_%U'; #<= location of backups # Other configuration statements . . . 2) Code backup...

Try: /usr/sbin/sshd -T|awk '{k=$1; a[k]=a[k]","$2;}END{for (k in a) print k,a[k];}' [3eyes] ---------------------------------------------------------------------------- The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

None, just make sure it is not the "default" temporary tablespace. Remember also to change it for the users that have this temp tablespace as default. [3eyes] ---------------------------------------------------------------------------- The person who says it can't be done should not interrupt...

Try this: SQL> WITH Prod_Tab (Product_Code, Category) 2 AS (SELECT 'A145041', 'Filters' FROM DUAL UNION ALL 3 SELECT 'A452002', 'Hardware' FROM DUAL UNION ALL 4 SELECT 'A145041', 'Hardware' FROM DUAL UNION ALL 5 SELECT 'A245666', 'Film' FROM...

Perhaps something like this? (not tested) UPDATE ( SELECT T1.Transaction_Code , T1.Technical_Description , T1.ROWID Row_Id , D1.Code D1_Code , D1.Descr D1_Desc FROM Table1 T1 , ( SELECT '3001' Code, 'EDI...

Try something like this: SELECT F.Group_Number , D.Name Disk_Name , D.PATH , G.Name Group_Name , Dbf.File# , Dbf.Name FROM V$asm_File F , V$asm_Disk D , V$asm_Diskgroup G , V$datafile Dbf WHERE D.Group_Number = F.Group_Number AND G.Group_Number =...

Try: SELECT Tablespace_Name, File_Name FROM Dba_Data_Files; ---------------------------------------------------------------------------- The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb