View and table with the same name




If you have one table called CUST_ACCOUNTS and a view called CUST_ACCOUNTS -- and then you want to select from the view and not the table, how do you do that

Is there a prefix for views or something that I can have in front of the name to specify it's the view I want data from

Posted On: Monday 31st of December 2012 01:48:08 AM Total Views:  280
View Complete with Replies

RELATED TOPICS OF Oracle PROGRAMMING LANGUAGE




Quick Questions

all, A question on the /as sysdba login. Is there anyway this can be more secure This has caused a security issue with us as anyone who knows this loop-hole can log into the database as with dba privs!. My second question is, are there any logs/views for info on things like user password changes during a particular window\t Many
VIEWS ON THIS POST

51

Posted on:

Wednesday 7th November 2012
View Replies!

Privileges to see triggers

WHat privileges does the user need to have so that he can see the triggers in another users schema Appreciate your input. -Chintz
VIEWS ON THIS POST

258

Posted on:

Wednesday 7th November 2012
View Replies!

Temp tablespace

Our temp tablespace keep on hit the limit. Is there any other way to solve the problem except tuning the sort and adding space How does database system release temp space
VIEWS ON THIS POST

289

Posted on:

Wednesday 7th November 2012
View Replies!

Technet Documentation

Has anybody noticed that links on OTN to 8i documentation have suddenly stopped working I guess it's a push for 9i... For example: Click on the HTML links from http://technet.oracle.com/docs/produ...c/products.htm for most of the manuals...
VIEWS ON THIS POST

60

Posted on:

Wednesday 7th November 2012
View Replies!

Rman-06088:

I have a prodution db which I am replicating on another machine, I have done this before the only thing I have done is added six tablespaces to the production system, and then added these six tablespaces/datafiles into my restore script set new name section. However I am getting the error RMAN-06088: datafile copy /u01/oradata/ETSPROD/data/xoprod01x.dbf not found or out of sync with catalog Help please this is urgent..
VIEWS ON THIS POST

45

Posted on:

Wednesday 7th November 2012
View Replies!

REP-3335: Unable to re-open WebReports under Oracle 9i iDS

, Note that under the Reports Node in Forms Builder, in the Property Palette, I set the Filename Attribute to 1 file name as such: H:\TEMP\Consent_test.rdf. 1) Should I specificy the extension or not For some strange reasons, certain reports, I can only open them once and then when I try to reopen them again I get the following errors: ----- Report Builder REP-3335: Unhandled Internal CA Error aaaaz 36. Error PDE-PER001: Internal Error (REP-3335 Unhandled Internal CA Error. aaaaz 36). (additional error: aaaaz 70) ------------ 1) Any ideas how to resolve this Applying a Patch PT
VIEWS ON THIS POST

186

Posted on:

Wednesday 7th November 2012
View Replies!

SGA Fixed Size

What's mean here Fixed size of SGA\t I always thought PGA is a fixed size of SGA, but my sort_area_size=1M und Fixed size=0,75M!! Can someone explain me SQL> startup force Instance ORACLE lance. Total System Global Area 61216796 bytes Fixed Size 75804 bytes Variable Size 18919424 bytes Database Buffers 42143744 bytes Redo Buffers 77824 bytes
VIEWS ON THIS POST

41

Posted on:

Wednesday 7th November 2012
View Replies!

Rebuild btree index myth ?

This PDF by Richard Foote uses quotes from Burleson and Niemec which he disagrees with and considers 'myths'. Rebuilding The Truth http://www.actoug.org.au/Downloads/o..._internals.pdf The vast majority of indexes do not require rebuilding Oracle B-tree indexes can become unbalanced and need to be rebuilt is a myth Deleted space in an index is deadwood and over time requires the index to be rebuilt is a myth If an index reaches x number of levels, it becomes inefficient and requires the index to be rebuilt is a myth If an index has a poor clustering factor, the index needs to be rebuilt is a myth To improve performance, indexes need to be regularly rebuilt is a myth
VIEWS ON THIS POST

114

Posted on:

Wednesday 7th November 2012
View Replies!

tables from 7.3.4->8.1.5

export => 7.3.4 import 2 8i => 7.3.4 imp is this possinble
VIEWS ON THIS POST

101

Posted on:

Wednesday 7th November 2012
View Replies!

Start/Stop Service

how can I automatically start/stop the my db using the services from win2000/winnt.
VIEWS ON THIS POST

74

Posted on:

Wednesday 7th November 2012
View Replies!

PL/SQL compilation error

Hi! , I am creating the following package and it is giving me this wierd error as listed below. I am commented out the code and replaced it with a single statement NULL;. Even then the same error is occuring. Thanx in advance Sudip CREATE OR REPLACE PACKAGE BOP_STES AS TYPE RESULTSET_CURSOR IS REF CURSOR; PROCEDURE SP_RETRIVE_FORM_DATA (p_certificate_id NUMBER, ERROR_MSG OUT VARCHAR2, THE_RESULTS IN OUT RESULTSET_CURSOR); END BOP_STES; / CREATE OR REPLACE PACKAGE BODY BOP_STES AS PROCEDURE SP_RETRIVE_FORM_DATA (p_certificate_id NUMBER, ERROR_MSG OUT VARCHAR2, THE_RESULTS IN OUT RESULTSET_CURSOR) IS BEGIN OPEN THE_RESULTS FOR SELECT FRM_FORM_ID, FRM_FORM_NAME, FRM_IMAGE_NAME, FRM_FILE_NAME, FRM_PATH FROM TBL_BOP_FORM_TEMPLATE FRM, TBL_BOP_CERTIFICATE CER WHERE FRM_FORM_ID = CER_FORM_ID AND CER_CERTIFICATE_ID = p_certificate_id ; ERROR_MSG := 'SUCCESS'; EXCEPTION WHEN NO_DATA_FOUND THEN ERROR_MSG := SQLERRM; WHEN OTHERS THEN ERROR_MSG := SQLERRM; END; END; / CREATE OR REPLACE PACKAGE BODY BOP_STES AS * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01401: inserted value too large for column ORA-06512: at line 27
VIEWS ON THIS POST

112

Posted on:

Wednesday 7th November 2012
View Replies!

oracle-solaris

hi, can anyone tell me where the Scripts for database creation for oracle8 on solaris. bye
VIEWS ON THIS POST

91

Posted on:

Wednesday 7th November 2012
View Replies!

re-initialize redologs - syntax anyone?

I forgot the command to clear/re-initialize the redologs without having to issue a create controlfile..can't seem to readily get the command off metalink. If someone remembers it, please post. Many
VIEWS ON THIS POST

165

Posted on:

Wednesday 7th November 2012
View Replies!

Parsing of tnsnames.ora

I created a new (test) database this morning( on 816/win2000). I manually set up the listener&tnsnames. I can NOT access the new database or add it to the tree of databases in my Oracle console("Failed to parse tnsnames.ora...error 100-NLNV-NLNV string format error").No access to new database from plsql or sqlplus on server.However,I am able to access this database from other stations in the office. This has been/is a big problem to me using Oracle 816/817/9i. Is there a compat. problem with win2000. Please advise because I really need to sort out the root of this concurrent problem. Thanx in advance
VIEWS ON THIS POST

255

Posted on:

Wednesday 7th November 2012
View Replies!

How can I split values from a column using sql?

I am developing web application using csharp and MS SQL as database. There is a column in table that is storing values which as numbers and letters. Letters are in front\t like JK26262, JK26263,JK26263. Now I want to select numbers only from a table column and leave letters. In other words I want an select statement that will select values as follows: 26262 26263 26263 How can Iachieve this Kind regards. Mobzam
VIEWS ON THIS POST

162

Posted on:

Wednesday 7th November 2012
View Replies!

Import larger excel data in to Oracle table

I want to import a larger excel data in to oracle table for processing. Our basic idea was to copy the Excel data from the client side to Server side and then process excel data using SQL Loader. But we assume that this will end up in eating lot of time and we are short of any other plans. Kindly guide me is there any other easier and faster way to do this. Please recommend some good Links to do this. we are using ASP.NET, C#, and Oracle 9i.
VIEWS ON THIS POST

178

Posted on:

Wednesday 7th November 2012
View Replies!

gridview + oracle = headache

Ive been having trouble with a page ive been attempting to make. it includes a Gridview control that is linked to my sqlDataSource. What i am trying to do is be able to search the underlying oracle database using a simple 3 text box and search button setup, then having the results display in the Gridview control (3 columns). the connection to the database is working fine, i can send it values and get what i want back, but i cant seem to get it to work correctly with the text boxes that ive created on the form. everything ive read says that there is not even any code-behind needed to do what im asking but none of the tutorials or code that ive found has worked yet. heres my select statment \t \t\t\t \t \t objects 0000101002 \t\t\t \t\t\t \t\t\t \t\t\t \t\t\t \t\t\t \t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t \t \t     \t \t \t \t \t code behind Partial Class search \t Inherits System.Web.UI.Page \t Dim idnum As String \t Dim fname As String \t Dim lname As String \t Protected Sub resetbutton_click(ByVal sender As Object, ByVal e As System.EventArgs) Handles resestbutton.Click \t\t\t idbox.Text = "" \t\t\t fnbox.Text = "" \t\t\t lnbox.Text = "" \t\t\t GridView1.Visible = False \t\t\t If GridView1.Visible = False Then \t\t\t\t\t notifylabel.Text = "Type in the ID number or name(s) of the person you wish to search." \t\t\t Else \t\t\t\t\t notifylabel.Text = "" \t\t\t End If \t End Sub \t Protected Sub searchbutton_click(ByVal sender As Object, ByVal e As System.EventArgs) Handles searchbutton.Click \t\t\t notifylabel.Text = "Searching..." \t\t\t idbox.Text = idnum \t\t\t idnum = idbox.Text \t\t\t fnbox.Text = fname \t\t\t fname = fnbox.Text \t\t\t lnbox.Text = lname \t\t\t lname = lnbox.Text \t\t\t GridView1.Visible = True \t\t\t notifylabel.Text = "Seach Complete." \t End Sub \t \t Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load \t\t\t GridView1.Visible = False \t\t\t SqlDataSource1.SelectParameters("ID_NUMBER").DefaultValue = idnum \t End Sub \t End Class ------------------------------------------------ any suggestions and/or solutions would be awsome.
VIEWS ON THIS POST

180

Posted on:

Wednesday 7th November 2012
View Replies!

OLEDB 4.0 Data Connector Error

I am trying to create an xml file using vb.net; however, I get an error on the oledb connector on my page. here is my code: \t Dim strConn As String \t Dim DeeIntranetConn As OleDbConnection \t \t Sub Page_Load() \t\t\t Dim dadXML As OleDbDataAdapter \t\t\t Dim dstXML As DataSet \t\t\t Dim ssql As String \t\t\t \t\t\t ssql = "SELECT [PURCHASE ORDERS].[PO NUMBER], [PURCHASE ORDERS].ShipToCompany, [PURCHASE ORDERS].ShipAttn, [PURCHASE ORDERS].ShipStreet1, [PURCHASE ORDERS].ShipStreet2, [PURCHASE ORDERS].ShipCity, [PURCHASE ORDERS].ShipSt, [PURCHASE ORDERS].ShipZip, PORECGS1.[Part #], PORECGS1.[PO Qty], PORECGS1.[Qty Recd], PORECGS1.[Unit Recd Cost]" \t\t\t ssql = ssql & " FROM [PURCHASE ORDERS] RIGHT JOIN PORECGS1 ON [PURCHASE ORDERS].[PO NUMBER] = PORECGS1.[PO Number]" \t\t\t ssql = ssql & " WHERE ((([PURCHASE ORDERS].VendorID)=10330))" \t\t\t ssql = ssql & " GROUP BY [PURCHASE ORDERS].[PO NUMBER], [PURCHASE ORDERS].ShipToCompany, [PURCHASE ORDERS].ShipAttn, [PURCHASE ORDERS].ShipStreet1, [PURCHASE ORDERS].ShipStreet2, [PURCHASE ORDERS].ShipCity, [PURCHASE ORDERS].ShipSt, [PURCHASE ORDERS].ShipZip, PORECGS1.[Part #], PORECGS1.[PO Qty], PORECGS1.[Qty Recd], PORECGS1.[Unit Recd Cost]" \t\t\t \t\t\t strConn = ConfigurationManager.AppSettings("DeeIntranetConn") \t\t\t DeeIntranetConn = New OleDbConnection(strConn) \t\t\t \t\t\t dadXML = New OleDbDataAdapter(ssql, DeeIntranetConn) \t\t\t dstXML = New DataSet() \t\t\t dadXML.Fill(dstXML, ssql) \t\t\t \t\t\t dstXML.WriteXml("d:\inetpub\XML\XML\Newark.xml") \t\t\t Response.Write("Saved Neward.xml file!") \t End Sub Here is my web.config file \t \t \t \t \t\t \t\t \t\t\t \t\t\t \t\t\t\t\t \t\t\t\t\t\t\t \t\t\t\t\t\t\t \t\t\t\t\t\t\t \t\t\t\t\t\t\t \t\t\t\t\t\t\t \t\t\t\t\t\t\t \t\t\t\t\t\t\t \t\t\t\t\t\t\t \t\t\t\t\t\t\t \t\t\t\t\t\t\t \t\t\t\t\t\t\t \t\t\t\t\t\t\t \t\t\t\t\t\t\t \t\t\t\t\t\t\t \t\t\t\t\t\t\t \t\t\t\t\t\t\t \t\t\t\t\t\t\t \t\t\t\t\t\t\t \t\t\t\t\t\t\t \t\t\t\t\t \t\t\t \t\t\t \t\t\t \t\t\t \t Here is my web error....any ideas Server Error in '/XML' Application. The 'Micorost.Jet.OLEDB.4.0' provider is not registered on the local machine. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidOperationException: The 'Micorost.Jet.OLEDB.4.0' provider is not registered on the local machine. Source Error: Line19:\t\t\t\tdadXML=NewOleDbDataAdapter(ssql,DeeIntranetConn) Line20:\t\t\t\tdstXML=NewDataSet() Line21:\t\t\t\tdadXML.Fill(dstXML,ssql) Line22: Line23:\t\t\t\tdstXML.WriteXml("d:\inetpub\XML\XML\Newark.xml") Source File: D:\inetpub\XML\NewarkCreateXML.aspx \t Line: 21 Stack Trace: [InvalidOperationException: The 'Micorost.Jet.OLEDB.4.0' provider is not registered on the local machine.] System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper) +975886 System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) +118 System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +53 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.OleDb.OleDbConnection.Open() +37 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83 ASP.newarkcreatexml_aspx.Page_Load() in D:\inetpub\XML\NewarkCreateXML.aspx:21 System.Web.Util.CalliHelper.ArglessFunctionCaller(IntPtr fp, Object o) +5 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +784031 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061 Version Information:Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
VIEWS ON THIS POST

458

Posted on:

Wednesday 7th November 2012
View Replies!

how to perform this in oracle and asp.net,c# code?

hello evrerybody.. how toperform this queryas a oraclestrored procedure and call it from asp.net ,C#codeand dataset using parameters SELECT * FROM EMP where deptno like nvl(pDeptNo,'%') AND hiredate = pDate; , Is your problem solved, if yes then mark one or many posts as answer which helped you in solving your problem. Or if you figured out solution in a different way then kindly share the solution so it can be usefull for others.
VIEWS ON THIS POST

168

Posted on:

Wednesday 7th November 2012
View Replies!

Update Query Help

I would appreciate some help, I cannot get my query to work: UPDATE\t journey SET\t \t journey.occupancy=occupancy-1 \t \t \t \t Inner Join journey \t \t \t \t On passengers.journey_id = journey.id \t \t \t \t Inner Join shuttle \t \t \t \t On shuttle.id = journey.shuttle_id WHERE\t shuttle.id = '1' AND \t \t\t passengers.passenger_name = 'bill gates' It is used when a cancelation is made to reduce the occupancy for that journey to reflect that passenger cancelling, my table/field names are okay and my links are right but I get the error: #1064-YouhaveanerrorinyourSQLsyntax;checkthemanualthat correspondstoyourMySQLserverversionfortherightsyntaxtouse near'InnerJoinjourneyOnpassengers.journey_id=journey.id'atline3
VIEWS ON THIS POST

69

Posted on:

Wednesday 7th November 2012
View Replies!

Oracle triggers calling .exe

Is it possible to have a trigger call a .NET executable Each time a new record is inserted or updated, I want to compare the newly inserted/updated record with another record in another database and do further processing. My idea was to have the trigger call a .NET app which will do the comparing and further processing. Has anyone encounter a issue like the one described above\t
VIEWS ON THIS POST

210

Posted on:

Wednesday 7th November 2012
View Replies!

I want to know value of cell in excel.

I'm use Excel for database , I want call value on cell " G3 " only on worksheet. please help me.
VIEWS ON THIS POST

189

Posted on:

Wednesday 7th November 2012
View Replies!

Install and using aspnet tables over MySQL db?

Hi all, How can I install aspnet 2.0 tables over MySQL database to use it with logins control and profiles and roles simply like using file aspnet_regsql and how to configure the web application on web.config file to use it Best regards
VIEWS ON THIS POST

126

Posted on:

Wednesday 7th November 2012
View Replies!

How to access file in WSS(Web Storage System) through browser or C# code?

If I use OWA(Outlook Web Access) to access WSS, it can access directory. For example, http://localhost/public/myfolder. If I point to a file in such directory, for example http://localhost/public/myfolder/a1.xml, then browser will display 403 error and a1.xml can not be accessed. Similarity, if I use following code to acesss http://localhost/public/myfolder/a1.xml, it still tell me the 403 error from catch statements: try { WebClient client = new WebClient(); client.Credentials = new System.Net.NetworkCredential("username", "password"); inputStream = client.OpenRead("http://localhost/public/myfolder/a1.xml"); reader = new XmlTextReader(inputStream); } catch (WebException webEx) { Console.Write(webEx.ToString()); } Would you please tell me how to resolve this problem
VIEWS ON THIS POST

234

Posted on:

Wednesday 7th November 2012
View Replies!

Getting connection to work

I have an applikation that have a connection to a MySQL database, and I got a webspace so that I could publish my applikation. To test the connection I made a very simple testapplikation, that I can't get to work. I'm getting the error: Microsoft.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified After contact with support they made their own testapplication which worked fine. But even if I cut and past their connectionstring, my applikation won't work My application is this which I made using Visual Studio (showing only code behind): stringconnectionString="Driver={MySQLODBC3.51Driver};Server=mysql01.crystone.se;Database=perssonkoefoed_se;uid=ke4abeme3a;pwd=8a1i3alu6u;option=3"; OdbcConnectionmSqlConnection=newOdbcConnection(connectionString); stringqueryString="select*frombooksample"; OdbcDataReaderobjReader; OdbcCommandobjCmd=newOdbcCommand(queryString,mSqlConnection); objCmd.Connection.Open(); objReader=objCmd.ExecuteReader(); Grid1.DataSource = objReader; Grid1.DataBind(); objReader.Close(); objCmd.Connection.Close();Their application is this made as one page:\t "server"> private const string ConnStr = "Driver={MySQL ODBC 3.51 Driver};Server=mysql01.crystone.se;Database=perssonkoefoed_se;uid=ke4abeme3a;pwd=8a1i3alu6u;option=3"; protected override void OnInit(EventArgs e) { base.OnInit(e); using(OdbcConnection con = new OdbcConnection(ConnStr)) using(OdbcCommand cmd = new OdbcCommand("select * from bookSAmple", con)) { con.Open(); dgrNames.DataSource = cmd.ExecuteReader( CommandBehavior.CloseConnection | CommandBehavior.SingleResult); dgrNames.DataBind(); } } body { font: 100% Verdana; } "center"> records in the 'Names' table: "dgrNames" HorizontalAlign="Center" CellPadding="3" Runat="server" />
VIEWS ON THIS POST

188

Posted on:

Wednesday 7th November 2012
View Replies!

Example

can any one send one example for how to create storedprocedure in mysql
VIEWS ON THIS POST

70

Posted on:

Wednesday 7th November 2012
View Replies!

storing data into DataSet from excel file using Oledb provider

I'm stroing data into DataSet from excel file using Oledb provider in asp.net c# application. query: SELECT * FROM [Sheet1$] everything is working fine but my concern is that 1st row should be skiped and 2nd row should be used for heading and rest for datarow. I need help on urgent basis.
VIEWS ON THIS POST

180

Posted on:

Wednesday 7th November 2012
View Replies!

MySql with my_aspnet_roles

Hi Guys, I'm using MySql and have it hooked up to an asp.net site using the .Net Connector. I was wondering if I could use the auto- generated roles and membership database provider (with tables such as my_aspnet_roles and my_aspnet_membership) or would I have to create roles and membership tables of my own (like the one given here) Many
VIEWS ON THIS POST

93

Posted on:

Wednesday 7th November 2012
View Replies!

Connecting to a MySQL Database

I am a complete newbie at this and was wondering if someone could give me some help. I am looking to connect to a MySQL database usingto ASP.Net and was wondering if anyone had a simple way to do this. I havetried some examples fromthe internet but some are either for previous versions or do not work. The script languageI am using is VB. Any and all help would be much appreciated.
VIEWS ON THIS POST

29

Posted on:

Wednesday 7th November 2012
View Replies!

Database Scalability

I would like to learn some more about database scalability, what kind of traffic a database can handle, how you expand and when its time to do that. Can anybody recommend some good websites on the topic
VIEWS ON THIS POST

41

Posted on:

Wednesday 7th November 2012
View Replies!

Starting Enterprise Manager for 10g DB in Memory Access Mode

I just wonder if is it possible to start EM(for Oracle 10g) by default in "Memory Access Mode" mode If so, then how to configure EM to start in this mode, because when my system is heavily loaded, I can not even start EM in standard(SQL Access) mode I've googled nearly half of a day without answers to this issue... Any ideas are welcome! , Yes, I've found the same info myself, but it is useless though... As I said, I cannot even normally start EM when system is slow/hung! From (http://www.oracle.com/technology/pub...part2.html#sga) excerpt: "Here's how it works: In the Oracle Enterprise Manager UI, choose the Performance tab and scroll down to the bottom of the page, to the section labeled Related Links...Note the link called "Monitor in Memory Access Mode." ... Note the "View Mode" drop-down menu in which the "Memory Access" option is selected." This is useless in my situation anyway...
VIEWS ON THIS POST

49

Posted on:

Thursday 15th November 2012
View Replies!

sql across schemas

I have a database that has approx. 60 schemas that have many of the same tables. I need to write a SQL statement (or procedure) that queries a particular table across the schemas and returns the results per schema. So, my table is EVENTCAT and the 2 cols I want to report on are ECATCODE and SINGLEEV. Heres what I need the report to look like. OWNER EVENTCAT SINGLEEV SCOTT BASE 1 FOLLOWUP 2 FINAL 1 STEVE BASE 0 SAM BASE 1 FOLLOWUP 2 I'd be greatful for any suggestions on how to handle this.
VIEWS ON THIS POST

73

Posted on:

Thursday 15th November 2012
View Replies!

replication example

I have to setup replication, so that when a table is updated, the same table on another database is also updated. The update is only once is a while, and there will only be one master site. I have tried to follow the Oracle doc., but seem to get lost in the different scenerios. Does someone have a link to a good site that may have a basic example
VIEWS ON THIS POST

125

Posted on:

Friday 16th November 2012
View Replies!

question on size of segment

hi! just a question on the segment size, please find the part on "initial 1m next 2m pctincrease 50 minextents 5" on this site.. http://asktom.oracle.com/pls/ask/fp...:7149039425561 he said 1 + 2 + 3 + 4.5 + 6.75 meg of space rounded UP where did 3 came from i mean 1 is the initial then 2 next extent what is 3 4.5 is 3 + 1.5 from the PCTINCREASE
VIEWS ON THIS POST

123

Posted on:

Friday 16th November 2012
View Replies!

partitioning an existing table

I want to partition an existing non-partitioned table. Can I do this without recreating the table
VIEWS ON THIS POST

280

Posted on:

Friday 16th November 2012
View Replies!

oraenv for NT

Has anyone got an equivalent for oraenv on NT they would be able to share Run in batch
VIEWS ON THIS POST

65

Posted on:

Friday 16th November 2012
View Replies!

xml data file size question

I'm not sure if this is the correct forum or not, but here it goes. I'mworking on an app that is usingOracle 9 as the database. I'm connecting to the db using VB2.0 We are running into some performanceissues within theweb app. My question is, we did a data dump from the stored procedure being used and sent the output to an XML file via toad and that file came to the size of 32 mb. Then in the web app, I wrote the dataset out to an XML file as well,and noticed that the XML file from .NET is 55 mb in size and its from the same store procedure that we ran in toad. Does anyone know why there would be a size difference between the xml files
VIEWS ON THIS POST

122

Posted on:

Tuesday 20th November 2012
View Replies!

Need help with this stored Procedure+sql

Mate, \t\t\t\t\t\t Please tell me what i have done wrong in the below stored procedure. the procudure got created but at runtime it throws me an error 'Invalid Object Name 'TEMP''. i actually tried to decaled this as a temporary table like #TEMP. but its not solving my problem. So i Request u to help me ! CREATE PROC [dbo].[GLAS_PROC_LISTING_PAGE]\t\t\t\t\t\t\t\t\t\t\t @TABLENAME VARCHAR(50),\t\t\t\t\t @TABLE_CODE VARCHAR(50),\t\t\t\t\t @IS_FILTER VARCHAR(1),\t\t\t\t\t @SEARCH VARCHAR(500),\t\t\t\t\t @STR VARCHAR(1)\t\t\t\t\t\t\t\t\t\t\t\t\t\t AS\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t BEGIN\t\t\t\t\t\t\t IF @STR='1'\t\t\t\t\t /* COMMON_RET_TABLE_NAMES */\t\t\t\t\t \t\t\t\t\t SELECT CODE,NAME,PAGENAME,TBLHEAD FROM COMMON_TABLENAMES\t\t\t\t\t\t\t\t\t\t\t\t\t WHERE CODE=@TABLE_CODE\t\t\t\t\t \t\t\t\t\t \t\t\t\t\t IF @STR='2'\t\t\t\t\t /* COMMON_CUR */\t\t\t\t\t \t\t\t\t\t DECLARE @COLNAME VARCHAR(30)\t\t\t\t\t\t\t\t\t\t\t\t\t DECLARE @IS_ACTIVE VARCHAR(1)\t\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t DECLARE MYCURSOR CURSOR FOR SELECT COLUMNNAME FROM COMMON_FIELDNAMES\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t WHERE TBL_CODE=@TABLENAME AND COLUMNRANK IS NOT NULL AND COLUMNDESCR IS NOT NULL\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t ORDER BY COLUMNRANK\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t DECLARE @STRCOLNAME VARCHAR(500)\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t SET @STRCOLNAME = ''\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t SET @IS_ACTIVE = 'N'\t\t\t\t\t\t\t\t\t\t OPEN MYCURSOR\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t FETCH NEXT FROM MYCURSOR\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t INTO @COLNAME\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t WHILE @@FETCH_STATUS = 0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t BEGIN\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t SET @STRCOLNAME = @STRCOLNAME + ',' + @COLNAME\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t FETCH NEXT FROM MYCURSOR\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t INTO @COLNAME\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t END\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t CLOSE MYCURSOR\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t --SELECT LEN(@STRCOLNAME) - 1\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t SET @STRCOLNAME = SUBSTRING(@STRCOLNAME, 2, LEN(@STRCOLNAME))\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t BEGIN\t DECLARE @TEMP TABLE (COLUMNNAME VARCHAR(500)) INSERT INTO TEMP VALUES(@STRCOLNAME)\t\t\t\t\t\t\t\t\t\t EXEC('SELECT ' + @STRCOLNAME + ' FROM ' + @TABLENAME )\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t END\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t DEALLOCATE MYCURSOR\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t --@STRCOLNAME\t\t\t\t\t\t\t \t\t\t\t\t \t\t\t\t\t IF @STR='3'\t\t\t\t\t /* COMMON_GETCOLWIDTH */\t\t\t\t\t \t\t\t\t\t \t\t\t\t\t SELECT COLUMNDESCR, COLUMNWIDTH FROM COMMON_FIELDNAMES WHERE TBL_CODE = @TABLE_CODE\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t \t\t\t\t\t IF @STR='4'\t\t\t\t\t /* COMMON_SAMPLE_EX */\t\t\t\t\t \t\t\t\t\t SELECT COLUMNDESCR,COLUMNNAME FROM COMMON_FIELDNAMES\t\t\t\t\t\t\t\t\t WHERE TBL_CODE=@TABLE_CODE AND IS_FILTER= @IS_FILTER ORDER BY COLUMNRANK\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t \t\t\t\t\t IF @STR='5'\t\t\t\t\t /* COMMON_RET_COLUMN_NAMES */\t\t\t\t\t \t\t\t\t\t SELECT * FROM COMMON_FIELDNAMES WHERE TBL_CODE = @TABLENAME AND COLUMNDESCR IS NOT NULL AND COLUMNRANK IS NOT NULL\t\t\t\t\t\t\t\t \t\t\t\t\t \t\t\t\t\t IF @STR='6'\t\t\t\t\t /* COMMON_RET_SEARCH */\t\t\t\t\t \t\t\t\t\t DECLARE @COLNAME1 VARCHAR(30)\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t DECLARE MYCURSOR1 CURSOR FOR SELECT COLUMNNAME FROM COMMON_FIELDNAMES\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t WHERE TBL_CODE=@TABLE_CODE AND COLUMNRANK IS NOT NULL AND COLUMNDESCR IS NOT NULL\t\t\t\t ORDER BY COLUMNRANK\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t DECLARE @STRCOLNAME1 VARCHAR(500)\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t SET @STRCOLNAME1 = ''\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t OPEN MYCURSOR1\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t\t\t\t FETCH NEXT FROM MYCURSOR1\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t INTO @COLNAME1\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t WHILE @@FETCH_STATUS = 0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t BEGIN\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t SET @STRCOLNAME1 = @STRCOLNAME1 + ',' + @COLNAME1\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t FETCH NEXT FROM MYCURSOR1\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t INTO @COLNAME1\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t END\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t CLOSE MYCURSOR1\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t --SELECT LEN(@STRCOLNAME) - 1\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t SET @STRCOLNAME1 = SUBSTRING(@STRCOLNAME1, 2, LEN(@STRCOLNAME1))\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t BEGIN\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t --INSERT INTO TEMP VALUES(@STRCOLNAME)\t\t\t\t\t\t\t\t\t\t\t\t\t EXEC('SELECT ' + @STRCOLNAME1 + ' FROM ' + @TABLE_CODE + ' WHERE 1=1 ' + @SEARCH)\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t END\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t DEALLOCATE MYCURSOR1\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t --@STRCOLNAME\t\t\t\t\t\t\t\t \t\t\t\t\t END
VIEWS ON THIS POST

129

Posted on:

Tuesday 20th November 2012
View Replies!

connection string for Oracle database c# dot net

how to connect the oracle database from the asp.net C# code..
VIEWS ON THIS POST

179

Posted on:

Tuesday 20th November 2012
View Replies!

DataTable as a parameter in PL/SQL procedure?

I'm trying to pass something like a DataTable into my stored procedure. I'm used to looping through a DataTable in C#, but I'm wondering what the equivalent is in PL/SQL\t I've seen something like this: TYPE t_Orders IS TABLE OF myTable.Orders%TYPE INDEX BY PLS_INTEGER But I think that only contains one column... or not\t Here's what I'm looking for: PROCEDURE Insert_Orders(p_DataTable IN \t\t%TYPE, \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tResultset OUT SYS_REFCURSOR) IS BEGIN LOOP through the datatable INSERT ...; END;
VIEWS ON THIS POST

107

Posted on:

Tuesday 20th November 2012
View Replies!

PL/SQL works but not in ASP.NET App!!

I have a stored proc on Oracle 10g. This proc has an IN statement. SELECTh.last_name, h.first_name FROMhuman h WHERE human_number IN ('10','14','16',NULL) This works great in PL/SQL developer, and it even works great when I test it passing ('10','14','16',NULL) as a parameter. I.e. WHERE human_number IN HUMAN_NUMBERS_IN However, when I pass it as a varchar2 in the ASP.NET app it does not work. I do not have the tools to trace it, the DBA's have a request form I have to fill out and the earliest would be end of next week they could put the trace on it. I am wondering why passing the list of numbers which are actually varchar2's in the database as a comma delimited list does not work using this OracleParameter _human_numbers = new OracleParameter("P_Human_Numbers", OracleDbType.Varchar2); // "('10','14','16',NULL)"_human_numbers .Direction = ParameterDirection.Input; _human_numbers .Value = Human_Numbers; command.Parameters.Add(_human_numbers ); Your help is greatly appreciated.
VIEWS ON THIS POST

54

Posted on:

Wednesday 21st November 2012
View Replies!

ReturnValue in a Procedure...

... i'm working with Oracle for the 1st time (i'm used to SQL Server)! I've researched but found no answer: is there anyway to retrieve a value from a Oracle Procedure I know this is possible (and easy) to execute in SQL. I'm devolping a Windows App and the returnValue is kind of important to manage bugs and possible errors!
VIEWS ON THIS POST

254

Posted on:

Wednesday 21st November 2012
View Replies!

Connecting to Oracle

My .net 2.0 application, accssing Oracle,that works fine on my development machine does not work on my production server. The error messgae says: Exception Details: System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. Can anyone tell me what exactly do I have to install on the production server and what the url for downloading it is
VIEWS ON THIS POST

79

Posted on:

Wednesday 21st November 2012
View Replies!

[HYT00] [MySQL][ODBC 3.51 Driver]Access denied for user

Hi Expert I have connection problems with my database when running my local computer in IIS server. I installed mySQL 4.0, MySQL Front and MYODBC 3.5 and configure everything. I ran in several other computers and it works fine, but not this particular computer. When I tried to retrieve the item, there is error: ERROR [HYT00] [MySQL][ODBC 3.51 Driver]Access denied for user 'XXX@'localhost' (using password: YES) Exception Details: System.Data.Odbc.OdbcException: ERROR [HYT00] [MySQL][ODBC 3.51 Driver]Access denied for user 'XXX'@'localhost' (using password: YES) Appreciate for your help!
VIEWS ON THIS POST

240

Posted on:

Wednesday 21st November 2012
View Replies!

MySql Connector .NET and the DbProviderFactory

... I have downloaded the MySql Connector .NET form www.mysql.com . My connectionstring uses the MySql.Data.MySqlClient provider. When i use the DbProviderFactiry to create connections, readers and so on, it comes up with and error, saying that the provider has not been installed proberly... What is the proper way If i don't use the DbProviderFactiry, and use the MySql Connector .NET like this: \t\t\t\t\t MySqlDataReader reader = null; \t\t\t\t\t try \t\t\t\t\t { \t\t\t\t\t\t\t string strConn = ConfigurationManager.ConnectionStrings[connectionStringName].ConnectionString; \t\t\t\t\t\t\t string strProvider = ConfigurationManager.ConnectionStrings[connectionStringName].ProviderName; \t\t\t\t\t\t\t MySqlConnection myConn = new MySqlConnection(strConn); \t\t\t\t\t\t\t MySqlCommand cmd = new MySqlCommand(selectStatement, myConn); \t\t\t\t\t\t\t myConn.Open(); \t\t\t\t\t\t\t reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); \t\t\t\t\t } \t\t\t\t\t catch (Exception Ex) \t\t\t\t\t { \t\t\t\t\t\t\t throw new Exception(Ex.Message, Ex); \t\t\t\t\t } \t\t\t\t\t return reader; I get the following error: Type 'MySql.Data.Types.MySqlConversionException' in assembly 'MySql.Data, Version=1.0.7.30072, Culture=neutral, PublicKeyToken=c5687fc88969c44d' is not marked as serializable. What could be the issue here , I use something like this in my webconfig : \t \t \t\t \t ---> and place the MySQL driver in the .bin directory. I get no exception errors. Hope that helps, if it does maybe, you can help me as I progess through my understanding of .NET 2.0. I have aprobI'm still stuck on see: "Gridview MySQL and Parameters" @ http://forums.asp.net/1214631/ShowPost.aspx ,with no replies.
VIEWS ON THIS POST

73

Posted on:

Wednesday 21st November 2012
View Replies!

Data Connections with Oracle 10g

I'm not sure if anyone has run into this problem, but we have an application that was running with Oracle 9i and everything worked fine. We've upgraded to Oracle 10g, and we are having rouble establishing a connection to this. If anyone has any info, it would be appreciated.
VIEWS ON THIS POST

68

Posted on:

Wednesday 21st November 2012
View Replies!

compare blobs in informix database

Hi I have a table in informix database in which a field is there i.e note of text type. when i campare it in the select statement. odbc gives an error i.e "Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Informix][Informix ODBC Driver][Informix]Blobs are not allowed in this expression" Pleasehelp me. Priya
VIEWS ON THIS POST

230

Posted on:

Wednesday 21st November 2012
View Replies!

Oracle Helper class

Hi all, I remember someone creating an oracle helper class something like the SQL helper class a while back but I can't remember where I saw this or even who did it. If you remember this and know where it can be found, I would appreciate a link.
VIEWS ON THIS POST

194

Posted on:

Wednesday 21st November 2012
View Replies!

Inserting NULLS into MySQL database.

Hi all, I'm completely new to this so please excuse if my code is all over the place - I've tried to copy and modify as much as possible. I am trying to create a website that will display the data from one database (mysql) and then return some of the data and some more user input to a second database (also mysql) the reason for using two databases is unimportant. The code below works fine in terms of connections, but falls over in that it inserts new records where all field are NULL (not the input that I wanted them to be). Any help would be greatly appreciated.
VIEWS ON THIS POST

66

Posted on:

Wednesday 21st November 2012
View Replies!

Update Error

, I am trying to update a column based on another column in the same table (student table) and a column from another table (school table) Code is: update student_table set student_code = (select l.student_code from school_table l, student_table n where l.school = n.schoolname) I get the following error ORA - 01427 Single-row subquery returns more than one row
VIEWS ON THIS POST

159

Posted on:

Saturday 29th December 2012
View Replies!