Your writing shines! There is no room for gibberish here clearly you have explained about Query to To check if multi-org is setup. Keep writing!
My name is Donal and I'm new to the site so just wanted to introduce myself and say hi and post my first question so let me know if I am making any stupid mistakes as I may be a bit green on how this works!
Basically I have data stored in a 2 fields as follows: Org_ Parent Org_child The Org_Parent field is repeated with the same value 3 times but the org_child has 3 separate values. I need a query that will represent the data in a flat format .i.e. in 4 separate fields as follows:
cost centre(org_parent field): Sub-Division(first value in org_child field): will always start with a 6 digit number Division(second value in org_child field): will always start with a 4 digit number ending with 2 zeros Branch(third value in org_child field): will always start with a 4 digit number ending with 3 zeros
See attached excel spread sheet for how data currently looks and how it should look after the query
Follow my new blog if you interested in just tag along me in any social media platforms!
Fully 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
Oracle 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.
Hello There,
ReplyDeleteYour writing shines! There is no room for gibberish here clearly you have explained about Query to To check if multi-org is setup. Keep writing!
My name is Donal and I'm new to the site so just wanted to introduce myself and say hi and post my first question so let me know if I am making any stupid mistakes as I may be a bit green on how this works!
Basically I have data stored in a 2 fields as follows:
Org_ Parent
Org_child
The Org_Parent field is repeated with the same value 3 times but the org_child has 3 separate values. I need a query that will represent the data in a flat format .i.e. in 4 separate fields as follows:
cost centre(org_parent field):
Sub-Division(first value in org_child field): will always start with a 6 digit number
Division(second value in org_child field): will always start with a 4 digit number ending with 2 zeros
Branch(third value in org_child field): will always start with a 4 digit number ending with 3 zeros
See attached excel spread sheet for how data currently looks and how it should look after the query
Follow my new blog if you interested in just tag along me in any social media platforms!
Best Regards,
Renina
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
ReplyDeleteHi There,
Thanks for highlighting this and indicating about Query to To check if multi-org is setup where more study and thought is necessary.
I have some statements that I need to schedule in a procedure.
Drop Table u_system.emp_load;
CREATE TABLE u_system.emp_load
(employee_number CHAR(5),
employee_atten_time TIMESTAMP,
machine_number CHAR(3),
in_out CHAR(2)
)
ORGANIZATION EXTERNAL
(TYPE ORACLE_LOADER
DEFAULT DIRECTORY user_dir
ACCESS PARAMETERS
(RECORDS DELIMITED BY NEWLINE
FIELDS (employee_number CHAR(4),
employee_atten_time CHAR(20) date_format TIMESTAMP mask "dd/mm/yyyy hh24:mi:ss",
machine_number CHAR(4),
in_out CHAR(1)
)
)
LOCATION ('emp2.dat')
);
insert into u_system.emp_attend(employee_number,employee_atten_time,machine_number,in_out)
select * from u_system.emp_load;
Follow my new blog if you interested in just tag along me in any social media platforms!
Thanks,
Preethi
Oracle 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