Converted sql Query to Oracle
-
Hi all..... This is my oracle statement...while executing its giving an error: 21/29 PL/SQL: ORA-00923: FROM keyword not found where expected please help me to solve this issue.. its urgent... create or replace PROCEDURE PEAP_SelectEmpAppraiser ( AppraiserID IN VARCHAR2 DEFAULT NULL, Cur_RCT1 OUT GLOBALPKG.RCT1 ) AS BEGIN EXECUTE IMMEDIATE 'TRUNCATE TABLE PEAP_SelectEmployeesByApr'; INSERT INTO PEAP_SelectEmployeesByApr SELECT emp_code AS EmployeeID, emp_code || ' ' || l_name || ' ' || f_name AS SurNameFirstName FROM emp_master WHERE (Appraiser = PEAP_SelectEmpAppraiser.AppraiserID); Insert into PEAP_SelectEmployeesByApr SELECT emp_code as EmployeeID ,emp_code || ' ' || l_Name || ' ' || f_Name AS SurNameFirstName FROM emp_master WHERE ( Reporting_To = PEAP_SelectEmpAppraiser.AppraiserID) and isnull ( Appraiser , '') = '' and emp_code not in ( select EmployeeID from PEAP_SelectEmployeesByApr); OPEN Cur_RCT1 FOR SELECT DISTINCT EmployeeID, SurNameFirstName FROM PEAP_SelectEmployeesByApr; END; / please help me to resolve..its very urgent...
-
Hi all..... This is my oracle statement...while executing its giving an error: 21/29 PL/SQL: ORA-00923: FROM keyword not found where expected please help me to solve this issue.. its urgent... create or replace PROCEDURE PEAP_SelectEmpAppraiser ( AppraiserID IN VARCHAR2 DEFAULT NULL, Cur_RCT1 OUT GLOBALPKG.RCT1 ) AS BEGIN EXECUTE IMMEDIATE 'TRUNCATE TABLE PEAP_SelectEmployeesByApr'; INSERT INTO PEAP_SelectEmployeesByApr SELECT emp_code AS EmployeeID, emp_code || ' ' || l_name || ' ' || f_name AS SurNameFirstName FROM emp_master WHERE (Appraiser = PEAP_SelectEmpAppraiser.AppraiserID); Insert into PEAP_SelectEmployeesByApr SELECT emp_code as EmployeeID ,emp_code || ' ' || l_Name || ' ' || f_Name AS SurNameFirstName FROM emp_master WHERE ( Reporting_To = PEAP_SelectEmpAppraiser.AppraiserID) and isnull ( Appraiser , '') = '' and emp_code not in ( select EmployeeID from PEAP_SelectEmployeesByApr); OPEN Cur_RCT1 FOR SELECT DISTINCT EmployeeID, SurNameFirstName FROM PEAP_SelectEmployeesByApr; END; / please help me to resolve..its very urgent...
here is a nice tool to help you do it http://www.swissql.com/products/sql-translator/sql-converter.html?adwords26s2&gclid=CLj-vvbQ2ZsCFR2dnAodXl8wAg[^]
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
here is a nice tool to help you do it http://www.swissql.com/products/sql-translator/sql-converter.html?adwords26s2&gclid=CLj-vvbQ2ZsCFR2dnAodXl8wAg[^]
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
I realy dont undestand what you saying :)
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
I realy dont undestand what you saying :)
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
see I have a storedprocedure in SQL 2005 and using SwissSql tool i have migrated that SP to oracle 10g. (that is the one which i have send) now when i execute this in oracle its giving an error the below: PL/SQL: ORA-00923: FROM keyword not found where expected
-
see I have a storedprocedure in SQL 2005 and using SwissSql tool i have migrated that SP to oracle 10g. (that is the one which i have send) now when i execute this in oracle its giving an error the below: PL/SQL: ORA-00923: FROM keyword not found where expected
I really dont know Oracle Syntax i have never worked with Oracle, let me ask a Friend mybe he can help. Please hold
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
see I have a storedprocedure in SQL 2005 and using SwissSql tool i have migrated that SP to oracle 10g. (that is the one which i have send) now when i execute this in oracle its giving an error the below: PL/SQL: ORA-00923: FROM keyword not found where expected
I have a friend who can Help you interactively. Go to gmail and invite "Vuyiswamb" i dont have Oracle and i dont use it, i use only Microsoft SQL :)
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
I have a friend who can Help you interactively. Go to gmail and invite "Vuyiswamb" i dont have Oracle and i dont use it, i use only Microsoft SQL :)
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
Cool :) Waiting for you in Gmail :)
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
Cool :) Waiting for you in Gmail :)
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
i cant use Gmail in ofc..Pls tel him to help through ths (anyway i hv send u the query na)
The Problem i dont have Oracle and neither he and will depend on you to run queries. he will help you debug it.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
The Problem i dont have Oracle and neither he and will depend on you to run queries. he will help you debug it.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
ok den tel me steps.. the problem is : WHERE ( Reporting_To = PEAP_SelectEmpAppraiser.AppraiserID) and nvl( Appraiser , '') = '' and emp_code not in ( select EmployeeID collate database_default from PEAP_SelectEmployeesByApr); here After the employeeid from keyword is missing its saying... here 'collate database_default' is there in between of employeeid and from keyword.. the SQL query is working with this.. but i doubt is there any specific format to be used for 'collate database_default'?
-
ok den tel me steps.. the problem is : WHERE ( Reporting_To = PEAP_SelectEmpAppraiser.AppraiserID) and nvl( Appraiser , '') = '' and emp_code not in ( select EmployeeID collate database_default from PEAP_SelectEmployeesByApr); here After the employeeid from keyword is missing its saying... here 'collate database_default' is there in between of employeeid and from keyword.. the SQL query is working with this.. but i doubt is there any specific format to be used for 'collate database_default'?
but why we need "collate database_default " here ?
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
but why we need "collate database_default " here ?
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
if i remove am getting another error like : PL/SQL: ORA-00942: table or view does not exist not able to find out the temporary table 'PEAP_SelectEmployeesByApr'
it is Difficult to help you.but your query is not complicated. try to run this separately before using them in sp, if they can run then they can run in a Sp.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
it is Difficult to help you.but your query is not complicated. try to run this separately before using them in sp, if they can run then they can run in a Sp.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
Can you post separated parts here , i will tell you where you went wrong.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
Can you post separated parts here , i will tell you where you went wrong.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
Am new to oracle...can u just help me to convert the given below sql query to oracle? create PROCEDURE [dbo].[PEAP_SelectEmployeesByAppraiser] ( @AppraiserID varchar(12) ) AS SET NOCOUNT ON; Create Table #PEAP_SelectEmployeesByAppraiser_All (EmployeeID varchar(6) null, SurNameFirstName varchar(150) ) Insert into #PEAP_SelectEmployeesByAppraiser_All SELECT emp_code AS EmployeeID, + emp_code + ' ' + l_name + ' ' + f_name AS SurNameFirstName FROM emp_master WHERE (Appraiser = @AppraiserID) Insert into #PEAP_SelectEmployeesByAppraiser_All SELECT emp_code as EmployeeID, + emp_code + ' ' + l_Name + ' ' + f_Name AS SurNameFirstName FROM emp_master WHERE (Reporting_To = @AppraiserID) and isnull(Appraiser,'') = '' and emp_code not in (select employeeid collate database_default from #PEAP_SelectEmployeesByAppraiser_All) Select Distinct EmployeeID, SurNameFirstName from #PEAP_SelectEmployeesByAppraiser_All
-
Am new to oracle...can u just help me to convert the given below sql query to oracle? create PROCEDURE [dbo].[PEAP_SelectEmployeesByAppraiser] ( @AppraiserID varchar(12) ) AS SET NOCOUNT ON; Create Table #PEAP_SelectEmployeesByAppraiser_All (EmployeeID varchar(6) null, SurNameFirstName varchar(150) ) Insert into #PEAP_SelectEmployeesByAppraiser_All SELECT emp_code AS EmployeeID, + emp_code + ' ' + l_name + ' ' + f_name AS SurNameFirstName FROM emp_master WHERE (Appraiser = @AppraiserID) Insert into #PEAP_SelectEmployeesByAppraiser_All SELECT emp_code as EmployeeID, + emp_code + ' ' + l_Name + ' ' + f_Name AS SurNameFirstName FROM emp_master WHERE (Reporting_To = @AppraiserID) and isnull(Appraiser,'') = '' and emp_code not in (select employeeid collate database_default from #PEAP_SelectEmployeesByAppraiser_All) Select Distinct EmployeeID, SurNameFirstName from #PEAP_SelectEmployeesByAppraiser_All
AS i said before i dont do oracle, am not familiar with Oracle.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
AS i said before i dont do oracle, am not familiar with Oracle.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/