sql - Connect By Prior with previous values -


i'm sorry, tried find answer, found not. have previous(!) arnt parentartnr , posnr parentposnr in query. tried connect_by_root, top artnr , posnr. tried sys_connect_by_path(t1.artnr, '/') parentartnr, returns tree.

do know how can that?

this sql works fine, it's without parent values.

select      level,     t1.artnr,      t1.posnr      smstlpos t1 start      t1.artnr = '057516' connect t1.artnr = prior t1.kompartnr

i as:

select   level,  t1.artnr,   t1.posnr,  t0.artnr parentartnr,  t0.posnr parentposnr   smstlpos t1 start   t1.artnr = '057516' connect t1.artnr = prior t1.kompartnr

or example declare variable value update... have no idea.

here same want oracle in sql server:

with   n(kompartnr, artikel_nr, level, parentartnr, parentposnr) (     select smstlpos.kompartnr,            smstlpos.artnr,            1 level,            smstlpos.artnr parentartnr,            smstlpos.posnr parentposnr       smstlpos      smstlpos.artnr='51269'  -- artnr isn't constant       union      select smstlpos1.kompartnr,            smstlpos1.artnr,            n.level + 1,            n.parentartnr,            n.parentposnr       smstlpos smstlpos1, n      n.kompartnr = smstlpos1.artnr ) select * n

omg, did it! :d in sys_connect_by_path, in format /10/20/30/40 , wanted(from example) 30. firstly used substr , /10/20/30, found position of '/' , again used substr on previous substr. or have better idea? 

select   level,  smstlpos.artnr,   smstlpos.posnr,  substr((substr(sys_connect_by_path(smstlpos.posnr, '/'),0, (instr(sys_connect_by_path(smstlpos.posnr, '/'), '/',-1)-1))), (instr(substr(sys_connect_by_path(smstlpos.posnr, '/'),0, (instr(sys_connect_by_path(smstlpos.posnr, '/'), '/',-1)-1)), '/', -1))+1) parentposnr,  substr((substr(sys_connect_by_path(smstlpos.artnr, '/'),0, (instr(sys_connect_by_path(smstlpos.artnr, '/'), '/',-1)-1))), (instr(substr(sys_connect_by_path(smstlpos.artnr, '/'),0, (instr(sys_connect_by_path(smstlpos.artnr, '/'), '/',-1)-1)), '/', -1))+1) parentartnr   smstlpos start   smstlpos.artnr = '057516' connect smstlpos.artnr = prior smstlpos.kompartnr

Comments

Post a Comment

Popular posts from this blog

php - Wordpress website dashboard page or post editor content is not showing but front end data is showing properly -

Image
recently have uploaded wordpress site onto server. have uploaded wordpress site in sub-folder under root folder ../root(domain root folder)/wordpress (where host wordpress folder). now problem content data in page or post in dashboard of wordpress admin panel not showing - see image. but data showing in front view - see image. if not browser cache issue , not issue happened tinymce editor during upgrade; try add config file: define('concatenate_scripts', false);
Read more

How to get the ip address of VM and use it to configure SSH connection dynamically in Ansible -

i trying ip address of vm , trying use establish ssh vm. following script: --- - hosts: localhost become: yes connection: local gather_facts: false serial: 1 vars_files: - createvmvars.yml tasks: - name: gathering vm info. vsphere_guest: vcenter_hostname: "{{vcenter_hostname}}" username: "{{vcenter_username}}" password: "{{vcenter_password}}" guest: "{{guest_name}}" vmware_guest_facts: yes register: var - debug: msg="{{var.ansible_facts.hw_eth0.ipaddresses[0]}}" - name: establishing ssh connection. script: /home/shasha/devops/scripts/ssh_configure.sh "{{var.ansible_facts.hw_eth0.ipaddresses[0]}}" following content of ssh_configure.sh : #!/bin/sh ssh-keygen -t rsa ssh-copy-id $1 but when running playbook, getting following error while executing third task: error! 'var' undefined but debug module(second task) printin
Read more

javascript - Get parameter of GET request -

i make request: createxhrrequest( "get", fileurl, function( err, response ) { if( err ) { alert( "error get!" ); } alert(response); }); and full response: { "status" : "ok", "message" : "jvberi0xljqkjdduxdgkmy how can jvberi0xlj ? i try response.message , response["message"]. nothing works. just simple access this: var json = json.parse(response); json.message
Read more