er diagram to sql

\tnsnames.ora or write one of their own content as follows:# Generated by Oracle configuration tools.ORCL =(DESCRIPTION =(Address_list =(ADDRESS = (PROTOCOL = TCP) (HOST = 10.5.10.252) (PORT = 1521)))(Connect_data =(service_name = ORCL)))The above three must pay attention to, in addition some Windows version of the tnsnames.ora.txt behind the txt to be removed;4, double hit open plsql point cancel650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/75/C7/wKiom1ZCWg2jjIVYAACFBK6WYNE843.png

'), (' Den ', ' MCI ', 3376)DECLARE @ROOT as INT = 1;With SUBSAs(Select empid,empname,0 as LVl,CAST ('. ') +cast (EMPID as VARCHAR (10)) + '. ' As VARCHAR (max) as path, 0 as cycle from dbo. EMPLOYEEwhere Empid [email protected]UNION ALLSelect C.empid, C.empname, P.lvl +1, cast (P.path + cast (c.empid as varchar) + '. ' as varchar (max)),Case is p.path like '%. ' +cast (c.empid as varchar) + '.% ' then 1 else 0 endFrom subs as P joins dbo. EMPLOYEE as C on C.mgrid =p.empid and P.cycle =0)Select