oracle - How to Copy data from table with a nested table column -

-

I have a table that has a column in the form of nested table.

I want to copy the data of this table in the second, how we choose the INSERT section, it seems challenging:

Consider the field which is the nested table, the phone_list whose Type is a user defined type "TBL_PHONE_EXTN", which is a table of "typ_phone_extn". Type 

  or type _phone_pen as the object (phone_number VARCHAR2 (20), extension VARCHAR2 (10)); / Type or type tbl_phone_extn as the command of typ_phone_extn; /   
 clearly fails below: (ORA-90094 :: with invalid identifier) ​​ 
  sch2.sub_pat_address (INSPIRE) at pat_address_id , Pat_id, ** phone_list, ** last_updated_by) SELECT pat_address_id, pat_id, ** phone_list, ** last_updated_by by sch1.sub_pat_address;   
 then I try:  
  SE1, pat_idress_id, pat_id, ** tbl_phone_extn (typ_phone_extn (phone_number, extension)), ** last_updated_by by sch1 Sub_pat_address, ** table (phone_list) **;   
 What does the nested table do when I end up with more records than I want - that is, if a specific pat_address_id had a phone_list of 5 phones, then this 5 records in combination Gives me and can not be put to me  
 So the question is, how to put nested (nested table column) and put it in the new table? Well, CTAS can be an option, but it requires a whole new table instead of INSERT. Any help would be greatly appreciated.   
 
 
 You can use unnecessary elements to rejoin the nested table, its actual collection type Back to Casting: Submit (collect_phone_extn (phone_number, extension)) as the SELECT pat_address_id, pat_id, cast (tb_phone_extn), last_updated_by sch1.sub_pat_address, table (phone_list) GROUP by pat_address_id, Pat_id, last_updated_by;   
 And then you can use that to put your own, obviously.  
 The only reason is that you can see that there will be a problem with your basic simple entry. Each schema had its own type and their tables were created using their own types, but then you have the  ORA -00932: Inadequate Datatype  or  ORA-01031:  ORA-00904  rather than insufficient privileges  is received.  
 Even if you have a privilege on the types of schema, then Oracle UDT will have to type  Precise  - not enough for them to be equally constructed. If they have separate entries in  ALL_OBJECTS , then they are not interchangeable.

Comments

Post a Comment

Popular posts from this blog

java - ImportError: No module named py4j.java_gateway -

-
I'm trying to call the Python using the Java program py4j . I've been installing the plug-in Eclipse and test name Piidvi project. I'm trying to execute the following part of the code found on py4j webpage: Import from py4j.java_gateway to JavaGateway, java_import gateway = JavaGateway () jvm = gateway.jvm java_import (jvm, '' Org.eclipse Kkorkrisorsej. * ") Vrkspes_rut = Jvankresourkesplginkgetvrkspas (). GetRoot (Gateway .help (workspace_root, '* Projects *') project_names = [project.getName () (for projects workpace_root.getProjects))] print (Projekt_nam) But I There is an error in import. I have checked that the P4JJ is present in the Jar Eclipse plugin directory. Can anyone help please? I had to install the py4j application
Read more

python - Receiving "KeyError" after decoding json result from url -

-
I am new to Python I am trying to parse JSON result from a URL. Basically, I was using the following: response = urllib.request.urlopen (url) json_obj = json.load (response) It should be a stroke "str 'not' bytes' in the lines of a given" JSON object, so after searching on the StackoverView Flo, I decode the response in this way: F = urllib.request.urlopen (Url) charset = f.info (). Get_param ('charset', 'utf8') data = f.read () decoded = json.loads (data.decode (charset)) If I print "decode" I is as follows: { 'link': { 'summary data': 'https: // localhost / piwebapi / streams / p0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / summary' 'value': 'https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / price ',' InterpolatedData ':' https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTE...
Read more

.net - Creating a new Queue Manager and Queue in Websphere MQ (using C#) -

-
"itemprop =" text "> I am writing applications that use WebSphere MQ to send messages. My unittests (for flow), I want to verify that I have put the correct message on the response queue. I am trying to figure out how to do this. My main obstacle is that I think it might be scary to clear the queue before running in my queue because the same queue can be used by other applications, I thought a decent solution would be a new line The manager will remove the queue for my solidarity and after using it. So my question is: Is it possible to use C # by using queue manager and queue? After the For future reference and future people, who want to make queues. I thought how to make and remove IBM MQ QE (not quenhers) with PCM messaging. It is not very simple, but it can be done. We have implemented it in a library and it is being used to create and delete commands before and after integration tests. The most important part of the code in this library is shown in the...
Read more