Covert from T-SQL procedure to Oracle procedure.
this is my T-SQL query,
ALTER PROCEDURE dbo.PRO_SELECT_CERTIFICATION_Accreditations
AS
BEGIN
SELECT[AccreditationID], [Accreditation], [Description]
FROM[Accreditations]
END
In one table I have data. Check the excel sheet i have attached.
One procedure to convert the data as mentioned in the excel sheet .
I need a PL/SQL code to convert an excel file to xml file.
View 3 Replies View RelatedI want to replace below multiple call to procedure with a Single query. Currently this proc is getting called multiple times from application.
FUNCTION f_get_shows_info(i_booking_wk_id IN NUMBER, i_screen_id IN NUMBER)
RETURN VARCHAR2 IS
v_act_shows booking_wk_screen.act_shows%TYPE;
v_expected_shows booking_wk_screen.expected_shows%TYPE;
v_return VARCHAR2(50);
BEGIN
SELECT NVL(act_shows, 1), NVL(expected_shows, 1)
INTO v_act_shows, v_expected_shows
FROM booking_wk_screen
WHERE booking_wk_id = i_booking_wk_id
[code]...
Is there anyway through which we can achieve this in Oracle 10g.
i have the below query
select to_char(report_date, 'YYYY MM Mon'), count(1) no_of_times
from (
select to_date('&&YYYYMMDD', 'YYYYMMDD')+rownum report_date
, mod(rownum,14) mod_result
from all_objects
[code]...
need to convert as procedure based on input date parameter.I will pass the input date from java environment and need to see the sql query output in front end.
I have to change some queries from SQL to Oracle but I couldn't convert these queries because they use some system tables in SQL that I don't know the equivalent Oracle tables. Following are SQL Queries
1. SELECT name, xtype FROM sysobjects WHERE xtype IN('U', 'V') AND name <> 'dtProperties' AND objectproperty(id, 'IsMSShipped') = 0 ORDER BY name
2. SELECT tS.name FROM sysobjects AS tS WHERE (tS.name IN (SELECT name FROM sysobjects WHERE xtype = 'U') AND xtype ='U') OR (tS.name IN (SELECT name FROM sysobjects WHERE xtype = 'V') AND xtype ='V')
3. SELECT o.name as TableName, c.name as FieldName, c.colid as Field_Ordinal, t.name as FieldType, c.length as FieldLength, c.prec as FieldPrecision, c.scale as FieldScale, c.isnullable, c.iscomputed, CASE WHEN c.status & 0x80 > 0 THEN 1 ELSE 0 END AS isidentity, columnproperty(o.id, c.name, 'IsRowGuidCol') as isrowguidcol FROM (sysobjects o JOIN syscolumns c ON o.id = c.id) JOIN systypes t On c.xtype = t.xtype WHERE o.xtype IN ('U', 'V') AND (t.xtype = t.xusertype)
I need to convert below functionality in Oracle. At present it is working with SQL server
current_end_time TIMESTAMP,
current_start_time TIMESTAMP
current_duration int
current_end_time := DATEADD(second, current_duration/10, current_start_time)
the below merge statements has outer join.
merge into merge_st t
using (select * from merge_st1) src
on (t.id=src.id(+))
when matched then update set name=src.name;
I need to convert oracle joins to ANSI joins. I have tried below
update (select t1.name as t1_name,t2.name as t2_name
from merge_st t1 lef outer join merge_st t2
on(t1.id=t2.id))
set t1_name=t2_name;
It statements shows error like cannot modify the non key preserved tables.I have cheked these table has contains whether primary key or not.there is no constraints for these tables.Our application, constaints handle in front end. so we cannot create any constraints in oracel database.how to convert oracle joins to ansi join?
convert a HTML to PDF format using plsql using oracle 9i.
View 9 Replies View RelatedI have a normal table like step 1 and I want to get a output like step 2. get the output from Columns to row in simple sql.
Step 1)
Table Name: Rat_table
------------------------------------------
Column : year and rating_name
year rating_name
------ -----------
2011 'Sucessful'
2010 'Not Rated'
Step 2)
Table Name: Rat_table
------------------------------------------
rating_name 'Sucessful' 'Not Rated'
year 2011 2010
How to convert Oracle 10g Forms to Oracle 6i Forms ?
View 2 Replies View RelatedI have Table like
ID |A |B |C
---------------------------------------------------
4 |0000 |ALL |6
7 |0000 |ALL |3
8 |TEST |ALL |3
and my expected should be like this
ID |ColumnName |Value
-------------------------------
4 |A |0000
4 |B |ALL
4 |C |6
7 |A |0000
7 |B |ALL
7 |C |3
8 |A |TEST
8 |B |ALL
8 |C |3
in oracle 11g we have the option call pivot and unpivot but i dont know how achive this in 10g.
what is the code for converting oracle reports to pdf.
View 11 Replies View RelatedI have a data synch procedure where I am extracting data from an Oracle table and inserting it into a SQL Server table. The Oracle column is VARCHAR2 and the receiving SQL Server column is Binary. I am receiving a conversion error. I have tried HEXTORAW in the Oracle procedure but it does not work. What data type can I use.
View 5 Replies View RelatedHow To Convert Data from Reports 6i to oracle Tables.
View 2 Replies View RelatedCan we convert or export oracle 9i dump to 8i dump ?
View 1 Replies View RelatedI'm converting a SQL Server db to Oracle 10g. So far it's going pretty well. However, I've hit a significant performance snag trying to run queries against the converted view whose SQL is below. In SQL Server it runs pretty quickly, 10-15 secs. This query presently returns about 1.7 million records. code below, and assuming I've done nothing to optimize the database or the objects involved,
BS
------------------
CREATE VIEW DST_TMP_VIEW_ACCT_XACTN_CRN AS
SELECT CUSTACCNUM,
FUNDID,
[code]...
We want to convert our application from Jena TDB to Oracle. In our ontology there are 40.000 triples. Oracle takes 6.8 sec. while Jena TDB takes 0.59 sec. Oracle is much slower than jena TDB. You can see both codes below. There are no inferencing for both apps. How can I improve the performance of Oracle?
Both applications and their data sources are running on same machine.
Oracle code:Oracle oracle = new Oracle(szJdbcURL, szUser, szPasswd); Attachment attachment1 = Attachment.createInstance( new String[] { szSchemaName, szImpactName }, new String[] { }, InferenceMaintenanceMode.NO_UPDATE, QueryOptions.DEFAULT); graph1 = new Graph Oracle Sem(oracle, szModelName, attachment1);m = new ModelOracleSem(graph1); listSubclass = m.listStatements(null,)
[code]....
I am using oracle database 9iR2 (9.2.0.8) on windows 2003 server.
Is there any method to convert following output in to ASCII format ??
select ename from scott.emp;
ENAME
--------
SMITH
ALLEN
WARD
JONES
MARTIN
BLAKE
CLARK
SCOTT
KING
TURNER
ADAMS
i m using oracle 9i (9.2.0.8.0) & developer 2000..I am getting below mentioned error when i convert Oracle Report to excel format.
"Report Builder
REP-1401:'afterreport':Fatal PL/SQL
error occurred ORA-43356 : Message 43356
not found; product = RDBMS ; facility = ORA "
Inspiration of a java program that converts a oracle database to one single XML document?
View 1 Replies View Relatedhow can convert number from Arabic to English in oracle report builder
View 2 Replies View Relatedi want to convert oracle database(schema data) to postgresql database
which tool would be best and url to download and steps to convert from one database to another ?
I have a road network which is shape file format and i want to export it to oracle spatial format using any free tool, I am using arcgis 9.3.1 and Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bi,
View 2 Replies View RelatedIf I have a sql file containg 'EXECUTE Proc_Test' i.e or any other procedure then to call that sql file what I will mention in the job_type.
OR
If the sql file contains a procedure and I want to call that file through scheduler then what I need to mention in the job type.
My question is--> Is it possible to create procedure with embeded C code ?
View 10 Replies View RelatedWhy we can not use the Oracle Procedure in an SQL Statement?
View 12 Replies View RelatedI have a procedure where my end result will give like
INSERT INTO ABC(A,B,C,D,ID) SELECT 1,2,3,4,P_ID FROM BBC WHERE P_ID=300;
this is a bulk insert where having 30 records.if one record fail then nothing will be commited.error willbe moved into my error log table.
I want the insert statement to be record by record and commit the successful one and move the error into error log table.
how to disable procedure on oracle
View 3 Replies View RelatedOracle procedure can run simultaneously?
Here is my concern, my procedure is already running manually and as per schedule time the same procedure will call by other application in the same time, So now procedure can run simultaneously or it will show any error message?