This will give the greatest string.
Syntax: greatest (strng1, string2, string3 … stringn)
Ex:
SQL> select greatest('a', 'b', 'c'), greatest('satish','srinu','saketh') from dual;
GREAT GREAT
------- -------
c srinu
If all the parameters are nulls then it will display nothing.
Hi dayakar,
ReplyDeleteSmokin hot stuff! You’ve trimmed my dim. I feel as bright and fresh as your prolific website and blogs!
CREATE table irt_test
(
mob numeric(20),
acct varchar(20),
mmid varchar(20),
err_msg varchar(20),
)
insert into irt_test(MOB,ACCT,MMID) values(999,123,456)
insert into irt_test (MOB,ACCT,MMID)values(999,123,456)
insert into irt_test (MOB,ACCT,MMID) values(102,856,987)
insert into irt_test (MOB,ACCT,MMID) values(102,625,987)
insert into irt_test (MOB,ACCT,MMID) values(632,152,954)
insert into irt_test (MOB,ACCT,MMID) values(632,962,357)
If mob,acc and mmid is repeated then i want to update as duplicate mob,acct,mmid
if for same mob and same repeated then i want to update as Duplicate MMID FOR same MOB
select * from irt_test
Expected result
mob acct mmid err_msg
999 123 456 Duplicate record mob,acct and MMID
999 123 456 Duplicate record mob,acct and MMID
102 856 987 Duplicate MMID for same MOB
102 625 987 Duplicate MMID for same MOB
632 152 954
632 962 357
Thanks a lot. This was a perfect step-by-step guide. Don’t think it could have been done better.
Many Thanks,
Irene Hynes
Hi Dayakar,
ReplyDeleteI learnt so much in such little time about Oracle Applications. Even a toddler could become smart reading of your amazing articles.
We had requirement that we need to alter table which contains huge data nearly 25 millions records.
Its range partitioned table and having 60 Partitions.
We want to add some extra columns to the same table.
Obviously it will take more time. What is the efficient way of doing this?
Do I need to disable all the indexes or Table gathering
I know that when we have bulk insertions into the table, disabling the indexes will help .
When we are selecting the data by applying indexed column where conditions, gathering statistics will help.
But in this case PARALLE HINT will help?
or
Do I need to go the Multi columns alter?
or
Do we have any other best solution?
Please help me to resolve the problem
Details : Table Size : 25 Millions Records
No of Partitions : 60
Partition Type : Range Partition on EntryDate Column
Oracle Version :Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production.
By the way do you have any YouTube videos, would love to watch it. I would like to connect you on LinkedIn, great to have experts like you in my connection (In case, if you don’t have any issues).
Gracias,
Sandy
Halo,
ReplyDeleteFully agree on #topic. We’re seeing a lot of projects tackle big complex problems but few seem to have taken into consideration and in particular reasons to adopt.
My table column type is clob. Field value contain double quotes
id,text_clob,date
1,"\"data1\",0,1,1,1,\"data2\"","2018-03-03 09:08:45"
can you kindly help loader query. i cant use replace in clob field.
It was cool to see your article pop up in my google search for the process yesterday. Great Guide.
Keep up the good work!
Thank you,
morgan
Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com
ReplyDeleteOracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.
ReplyDelete