Your column contains strings, and not all of them can be cast to integers. I see no reasonable method for performing the task described, given the data you've provided.

Oracle

expression cannot be used as an assignment target

8 Nov 2010 by #realJSOP

I'm not familiar with oracle, but are you permitted to change the value of an incoming parameter? Could it be a type mismatch problem?

Oracle

ORA-00923: FROM keyword not found where expected

17 Nov 2010 by #realJSOP

Try it this way:SELECT a.ID AS login_ID, a.NAME AS login_NAME, a.USER_TYPE AS login_USER_TYPE, a.PASSWORD AS login_PASSWORDFROM login a

Oracle

get row paramter from oracle procedure to .net

25 Dec 2010 by #realJSOP

To find out, put a breakpoint at the end of the method, and run the code under the debugger.

.NET

Oracle

project system student affairs at faculty in language oracle

6 Apr 2011 by #realJSOP

Well, we have no idea what the requirements are, or any constraints to be placed on the system, or the user interface you want to use. Do you want to use .Net, Oracle Forms, or what? Part of what the assignment is teaching you is how to deisgn as well as implement the appropriate software. If...

Oracle

ORA-12541: TNS:no listener

13 May 2011 by #realJSOP

Your IP address isn't complete - you're missing one of the octets.

Oracle

How to connect ORACLE database in LAN PC?

17 Jun 2011 by #realJSOP

Maybe this will help:Oracle FAQ[^]If not, google is your playground.

Oracle

network

Finding the role of a user

31 Aug 2011 by #realJSOP

sysdba is a privilege, not a role. Here's some code that might work:http://www.adp-gmbh.ch/ora/misc/recursively_list_privilege.html[^]

C#4.0

Oracle

how to use multiple database in single package in oracle

21 Nov 2011 by #realJSOP

Yes, it's possible, and if you know how to do it in Sql Server, you pretty much know how to do it in Oracle. The query syntax is a little different, but unless it's a really complex query, you shouldn't have any problems moving to Oracle.

Oracle

Hierarchy query in Sql sever

30 Nov 2011 by #realJSOP

There are a few ways you can do this:0) Pass the ID's to a stored procedure in a comma-delimited string, and in that stored proc, parse the string of IDs into a temporary table, and then perform a query using the temp table together with your actual data table.1) Perform a series of...

Oracle

Fetching Data very Slow from Oracle 11gR2 Database.

26 Dec 2011 by #realJSOP

Improving your database design (indexes, keys, relationships, and queries) is pretty much your only hope. Of course you already knew htis, so your question ends up being pointless.

Windows

Oracle

Suggestion for Application Architecture

28 Dec 2011 by #realJSOP

0) Use SQL Server for the database.1) Create your app in the form of either a asp.net web page or a Silverlight module.Writing desktop apps that require deployment adds to the cost. A web site can be accessed by hundreds of users simultaneously, and if deisgned appropriately, it can allow...

How do I load missing DLL

31 Jan 2017 by #realJSOP

Set the project's target to x86.

.NET2.0

Oracle

exceptions

Generating SQL from expression trees

7 Mar 2018 by #realJSOP

You can use LinqPad to see the sql.

How to pass datatable parameter in C# to storeprocedure in oracle

18 Jul 2019 by #realJSOP

Google odp.net. You need to bulk copy the data.

MVC

Oracle

Retrieving result dynamically from pivot or pivot XML in oracle

4 Sep 2020 by .NET- India

Hi,I want to get the data using Pivot dynamically but not able to get if possible then please let me know i'm sending my query here belowSELECT * FROM( SELECT ROW_NUMBER() OVER (PARTITION BY IAI_COVERNUMBER,IAI_VERNO ORDER BY IAI_COVERNUMBER) AS RNO, IAI_COVERNUMBER AS...

SQL

Oracle

Generate columns from a table column having XML string

11 Jan 2017 by .NET- India

In a table column i've data as given below 1 Record- 001 2 Record- 002

Oracle

Select only columns without null or blank values in oracle

13 Jan 2017 by .NET- India

How can I select only columns that don't have null valuecol1 col2 col320 12 null25 null nullDesired outputcol1 col2 20 12 25 nullWhat I have tried:Not getting way to come out.......................................................

Oracle

Set commandtimeout in oracle

31 Jan 2017 by .NET- India

How to Set CommandTimeout in oracle. As we do in Sql Server in window application C#What I have tried:Getting no CommandTimeout as Sql Server

Oracle

Passing parameter from report to subreport in RDLC

29 Jan 2015 by /\jmot

This error message hints that either the report parameter has not been passed from the parent report to the child report or that the wrong format of report parameter or an unacceptable value for the report parameter has been passed from the parent to the child report (I mean the subreport when I...

how do insert more than no_of record continuosly using loop(not use in cursor) in pl/sql

4 Feb 2015 by /\jmot

You can use..While Loop in Sql.ref.http://stackoverflow.com/questions/6069024/syntax-of-for-loop-in-sql-server[^]https://msdn.microsoft.com/en-IN/library/ms178642.aspx[^]http://stackoverflow.com/questions/4487546/do-while-loop-in-sql-server-2008[^]

SQL

Oracle

How Do I Set A Constraint For A Date Filed Removing Time

18 Feb 2015 by /\jmot

Well, in SQL Server 2008, there's a new datatype called "DATE" - you could use that column and create an index on that.You could of course also add a computed column of type "DATE" to your table and just fill the date portion of the DATETIME column into that computed column, make it...

SQL

Oracle

How Can I Set Auto Increment Property In Oracle 11G Database For Primary Key Column

7 Jan 2014 by 121ss

how can i set auto increment property in oracle 11g database for primary key columni have used a code like thatcreate table test_tab( id number primary key);create sequence test_seq start with 1 increment by 1 nocycle;create or replace trigger test_trg before insert on...

Oracle

database

How to fix this "with" clauses error

27 Jan 2022 by 13_J@d@_13

The reason Oracle is reading the query as recursive is because the Temp table name is Dates and the table name in the second select is also named Dates. Just rename the temp table something different (i.e. Dates1, etc.,). ;-) YOUR CODE Line 1:...

SQL

Oracle

Right outer join query in oracle

1 Jul 2013 by 16Sonali

Hi,Can u plz send me the query for right outer join on multiple table if one column is same in all table

Oracle

oracle query for date subtraction excluding weekend

4 Sep 2013 by 16Sonali

Please tell me the query in oracle which will minus one date from other date excluding weekends.e.g.if Actual end date is 10 th Oct 13 and Baseline end date is 4th Oct 13. So as per normal calculation difference is 6 days. However, when we consider Network days then we need to minus the...

Oracle

how to work on command window with oracle10g using c#.net

1 Jul 2011 by 204.sharma

hello, i want to alter table or merge some table in oracle 10g database.i want to do all this on a button click event.i am thinking that i pass all my query in form.cs and when i click the button the command window open with login in database and queries.i use process class but it...

Windows

Oracle

how to display image from oracle blob data

16 Jul 2011 by 204.sharma

Hii, i am trying to display image from Blob datatype of oracle10g in .net windows application.i am using filestream to get the image but the when i set the steam object for display image it show the error (Cannot access a closed file).My code is below.OracleConnection con = new...

Applying FilterExpression on SqlDataSource and binding the result to GridView

8 May 2010 by 4277480

Sample table to explain the problem (EmployeeID,EmployeeName,ManagerID)In my item template of my gridView I have a dropDownList which binds as follows:When you choose dataSource I set EmployeeName to be the field that is being displayed and the EmployeeID for the value. Then in the Edit...

For dummies: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

29 Aug 2019 by 4bakra

I'm really green, so please bear with me :) me and my friend are working on educational project, which is working in oracle. We started to use physical machine for it and when we finished, I decided to transfer everything to virtual machine, but database does not work anymore. Physical server is...

Oracle

For dummies: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

29 Aug 2019 by 4bakra

I fixed it somehow, if anybody needs to know, here is what I did: sqlplus /as sysdba SQL>ALTER DATABASE RECOVER; Database altered. SQL>ALTER DATABASE OPEN; Database altered. At lease this worked for me and now I can connect to both DBs. Thank you.

Oracle

Oracle - extract images from BLOB

12 Sep 2019 by 4bakra

Hello, I'm really green. I want to extract images (JPGs) from Oracle PDB. Table Looks something like this: select * from BOB.USER_ID t LINK_ID ID_SCAN 1 340101001 ... 2 340101002 ... 3 340101003 ... 4 340101004 ... 5 ... If possible, I want...

Oracle

extract

image

Convert SQl query to Oracle 10g query

7 Oct 2013 by 7prince

Convert SQL query to Oracle 10g queryAsked by: ocdcHow can I convert the query below to Oracle query? . Oracle doesn't use TOP 1 WITH TIES SELECT TOP 1 WITH TIES EmployeeID , EmployeeName , Profit AS "2ndTopProfit"FROM (SELECT TOP 2 WITH TIES ...

Oracle

Update Oracle 10g Query - increase salary 12% using update query

7 Feb 2013 by 7prince

How can I write update query for the query below to increase the salary 12% ? Thanks.SELECT * FROM (SELECT * FROM (SELECT * FROM (SELECT s.empid employeeid, s.ename employeename, ...

Oracle

Oracle 10g INSERT query

7 Feb 2013 by 7prince

INSERT query below gives me an error. The error is: cannot insert NULL into empidIs there anything wrong with my insert statements below. Thank you.--- INSERT EMPID 5 TIMES GREATER THAN THE LARGEST EXISTING EMPIDINSERT INTO SALESPERSONS (empid)SELECT MAX(EMPID) * 5FROM...

Oracle

modify query by adding UPDATE statement

9 Feb 2013 by 7prince

The query below works and gives me the most TopProfitted salesperson. How can I modify the query below to include UPDATE statement to increase the salary of 12% ?---Find the most TopProfited salesperson and increase the salary of that --salesperson 12%SELECT * FROM (SELECT * ...

Oracle

using RANK or DENSE_RANK in Oracle 10g

9 Feb 2013 by 7prince

How can I re-write the query below using Rank or Dense_rank in Oracle 10g?SELECT sqthree.employeeid, sqthree.employeename, to_char(sqthree.Topprofit,'$99,999.99') as TopProfitFROM ( /* #3 - select First and Second position */ SELECT sqtwo.employeeid,...

Oracle

PL/SQL - modifying the program

13 Feb 2013 by 7prince

Currently, the query output is; There are 2 items with the highest price: $80.00How can I show the partids for the highest price in the program below as well.?I would like the output to be: There are 2 items with the highest price: $80.00 with partids(This should be the partids of...

Oracle

PL/SQL - WHEN NO DATA FOUND ERROR HANDLER

18 Feb 2013 by 7prince

How can I fix the code below so that I won't get ERROR OTHERS ORA-01403: no data found at the end of the returned rows? It shouldn't be there If I am returning records?Stanwood Consulting 6099 15-DEC-95 $22.50Stanwood Consulting 6099 15-DEC-95 $7.50ERROR...

Oracle

Want help for SQL Query

22 Dec 2012 by __TR__

TrySELECT P.Id, P.Name, P.Amount FROM person PINNER JOIN ( SELECT Min(Id) AS Id, Name FROM person GROUP BY Name) T ON P.Id = T.Id

SQL

Oracle

MySQL

How can i find the third highest value in a table?

7 Jan 2013 by __TR__

TrySELECT a.Salary FROM MyTable aWHERE 3 = (SELECT COUNT(DISTINCT (b.Salary)) FROM MyTable b WHERE a.Salary

SQL

Oracle

database

Query to search for a company name in Company talble

1 Aug 2012 by _Amy

Hi,A partial part of as you are saying, can be done using Sql Like[^].You should read this : Internal Site Search Engine[^].--Amit

Oracle

ASP.NET

How can i find a part of a value from sql table

8 Aug 2012 by _Amy

You should use LIKE[^] operator to get the specified data from database.Read more about LIKE here[^].--Amit

SQL

Oracle

table recovery from DB

10 Sep 2012 by _Amy

You should use FLASHBACK TABLE statement to recover the table. Refer the links below:Oracle Flashback Drop: Undo a DROP TABLE Operation[^]FLASHBACK TABLE [^]Performing Flashback and Database Point-in-Time Recovery[^]And also try this[^].--Amit

Oracle

How to generate coloumns dynamically in Grid?

26 Feb 2013 by _Amy

A simple solution: use AutoGenerateColumns="True" and let the gridview to decide the number of columns dynamically.--Amit

How can i show distinct values in .net from back end tables?

4 Mar 2013 by _Amy

Try this query in your datatable:var uniqueColors = (from dbo in MainTable.AsEnumerable() select dbo.Field("Column").Distinct();--Amit

how to create oracle database

6 Jun 2013 by _Amy

You should read the documentation. Refer the link below:Creating a Database with the CREATE DATABASE Statement - Steps[^]--Amit

Oracle

How to upload file and how to save it in database?

19 Nov 2012 by _Amy

Hi,Refer the links below for the similar solution:Uploading files to database in C#[^]Upload and Download File From Database Using GridView[^]MSDN : FileUpload Class[^]Hope it helps!--Amit

How to set substitution type in OracleParameter

7 Jun 2011 by _Ares!!!

Hi All!I know Builder C++ and Delphi have Oracle components(TOracleDataSet for example) which have Substitution type. How can I get it in C#?I tried to do this: private string query = "select * from tb_zone t where t.employee=:p1 :p2 "; public void test() { ...

Oracle

What is benefit of using parameterized function for query?

10 Jul 2013 by _Asif_

Check below linkeshttp://codebetter.com/davidhayden/2006/01/05/parameterized-queries-and-performance/

Oracle

ASP.NET

How to resolve the Error :ORA-01036: illegal variable name/number

1 Aug 2013 by _Asif_

The problem is here!o_Cls_OracleConnect.Parameter_Int32("MAKER_ID", makerid);at this point you are declaring a parameter named :makerid but at the time of parameter creation you are creating it as MAKER_ID.strBuilder.Append(" MAKER_ID =:makerid , ");To fix this issue do...

Oracle

ASP.NET

How to return parameterized query as query with parameters values and not(:i_GroupID)or(:i_DpIntID)

4 Aug 2013 by _Asif_

There is a serious issue in your approach. The function qry_getUserRights is creating oracle connection objects and parameters but has not been used. The function returns simple SQL which later executes by obj_oc.GetDataSet function. Will this function create parameters present in the sql? No i...

Oracle

ASP.NET

How to learn Oracle database?

14 Aug 2013 by _Asif_

Check this linkhttp://www.oracle.com/technetwork/tutorials/index.html[^]one of the best Q&A for oraclehttp://asktom.oracle.com/pls/apex/f?p=100:1:0[^]

SQL

Oracle

SQL-Server

How to give Return out put value in Oracle Stored Procedures

27 Aug 2013 by _Asif_

In oracle you declare parameter as out parameter to return a value. See below example and tweak your code accordingly.CREATE OR REPLACE PROCEDURE test_proc ( p_iKey IN VARCHAR2, p_retVal OUT INTEGER)ASBEGIN DELETE FROM myTable WHERE theKey = p_iKey; IF(...

Oracle

Need a Oracle SQL Query for select

27 Aug 2013 by _Asif_

Take below query as hintselect C.Company_Name, O.Year, O.Order_Type, COUNT(ORDER_ID)from ORDER O INNER JOIN COMPANY C ON O.COMPANY_ID = C.COMPANY_IDGROUP BY O.YEAR, C.COMPANY_NAME, O.ORDER_TYPE

SQL

Oracle

oracle query for date subtraction excluding weekend

4 Sep 2013 by _Asif_

Check this linkCalculate diffference between 2 dates in SQL, excluding weekend days[^]

Oracle

oracle store procedure

17 Sep 2013 by _Asif_

I don't understand the logic behind this stored procedure. But anyway try thisCREATE OR REPLACE PROCEDURE spIsUserExist ISt_username VARCHAR2(50);BEGINselect count(*) INTO t_username from useraccounts where username=username;END spIsUserExist;

Oracle

Correct it in Oracle

1 Sep 2014 by _Asif_

Oracle Sequence is the alternative of Identity in SQL Server. You need to create a sequence using below SQL CommandCREATE SEQUENCE student_seq MINVALUE 1 MAXVALUE 999999999999999999999999999 START WITH 1 INCREMENT BY 1 CACHE 20;and then you can easily use sequence in following...

Oracle

How to get the first ten character as output from Query in Oracle !!!

4 Sep 2014 by _Asif_

Try thisselect empno, TO_CHAR(INCREMENTDATE, 'DD/MM/YYYY') AS UPDATEDINCRDATE, INCREMENTDATEFrom sr_incr_details Where EMPNO=123Order By INCREMENTDATEand Ignore the last column.

Oracle

ASP.NET

How to remove null values or how to bring multiple columns value into one

13 Feb 2015 by _Asif_

Don't know what exactly you want but an alternative approach could be likeCREATE GLOBAL TEMPORARY TABLE TMP_TBLE (COL1 INT, COL2 INT, COL3 INT) ON COMMIT DELETE ROWS;INSERT INTO TMP_TBLE(COL1, COL2, COL3)SELECT 100, NULL, NULLUNION ALLSELECT NULL, 200,...

SQL

Oracle

How Can I Run A Ddl Statement That Is Not Running In Oracle Form Developer But Working In Plsql

29 May 2015 by _Asif_

There are syntax error in your script. Is your script really compile? Check belowdeclare meritz merit%rowtype; cursor cursor_a is select * into meritz from zish.merit where ROWNUM

Oracle

Verifying Database Design Issues Against Predefined Quality Rules Using Schema Views

6 Dec 2016 by _Asif_

This article helps in identifying database design issues like certain fields missing, nullable fields, Primary key not found issues in production environment using SQL Server schema views.

Query Problem : Right Outer Join.

10 Aug 2011 by _Damian S_

Why not have a couple of lists... one that lists the current forms/permissions for the selected user, and one that lists the available forms.Two queries, one with an inner joing (to get the forms they are already assigned) and one with a simple left join to get the forms that they aren't...

SQL

Oracle

Can some body explain this query ...

18 Nov 2013 by _Damian S_

NULL IS NULL will simply return true, hence that part of the where clause is completely pointless, as regardless what happens with the subsidiary_id field, the result of the OR will always be true.

SQL

SQLite

Oracle

SQL select query to select table name having a particular field and value

17 Feb 2013 by _Maxxx_

Quick and dirty suggestion..Select * from(Select Name , 'TableA' as TableName from TableAunionSelect Name , 'TableB' as TableName from TableBunionSelect Name , 'TableC' as TableName from TableC)where Name = 'JQuery'If this works for you you could always create a view out...

SQL

Oracle

Condition Statement in SQL Server IF...Else

5 Dec 2013 by _Maxxx_

something likeselect *from T_ANALYSER_RESULTSWhere AnalysersID = IsNull(@p_analyserID, AnalysersID)And ResultDate >= IsNull(@p_Date_from, ResultDate)And ResultDate

Condition Statement in SQL Server IF...Else

5 Dec 2013 by _ProgProg_

Hey Guys,I am trying to make a Stored Procedure in SQL Server 2008 R2That Takes 3 Parameters (AnalyserID,Date_From,Date_To)Actually, The User Might not send the three parametersso, When the stored procedure is executed it might have 1 parameter value or 2 or three or not taken any...

Condition Statement in SQL Server IF...Else

5 Dec 2013 by _ProgProg_

Thanks to you all GuysThis is the right AnswerALTER PROCEDURE [dbo].[SP_T_ANALYSER_RESULTS_GET_BY_AnalyserID_Date]@p_AnalyserID INT,@p_Date_From datetime = null,@p_Date_To datetime = nullASDECLARE @query varchar(2000); SET @query = 'SELECT * FROM T_ANALYSER_RESULTS...

help for inserting date in oracle

11 Aug 2012 by _Raj sinha

for inserting date in oracle you need to use to_date function. try this one.insert into table_name(date_field)values(to_date('2003/05/03 21:02:44', 'yyyy/mm/dd hh24:mi:ss'));Raj

Oracle

i want to write a subquery where i can write a new column by subtracting earlier 2?

5 Jul 2013 by a2ulthakur

select (select dtleavefrom from dilpreet.leavedetails minus select dtleaveto from dilpreet.leavedetails) as newcol from dilpreet.leavedetails

Oracle

SQL-Server

unable to capture the value of selected node in treeview?

5 Jul 2013 by a2ulthakur

Public Sub BindTreedetails() treedetails.Nodes.Clear() Dim sql As String = "select a.zbaid,b.zbaname from brvpn.user_reviewbranch a, phasezero.zba_master b where a.empno='" & Request.QueryString("wempno") & "' and a.zbaid=b.zbaid and closedate is null and zbatype='BR' order by...

Oracle

how to use the value of gridview row to populate another gridview?

7 Jul 2013 by a2ulthakur

i have a gridview in which when i click the select command button what should happen is it should allow me to fetch a column value to be added in my sql query to fill another gridview select distinct a.*,b.active from ranu.desgmaster a, tt.employees b where (b.active= 'T') and a.desgid...

Oracle

i have a treeview from which i am capturing values whats happening is when i select more than one value my query does not work ?

7 Jul 2013 by a2ulthakur

Dim selected As String = "" For Each node As RadTreeNode In treedetails.Nodes If node.Checked = True Then selected += node.Value + "" End If Next tn &= " and a.zbaid in (" & selected & ")"when i check though breakpoints...

Oracle

how to get value of one month in sql ?

8 Jul 2013 by a2ulthakur

i used like in my query it workedselect * from table where columndate like 'FEB-13%'it shows me alll the records of February

Oracle

i have a button in my template field in gridview what i want is on button click i want a popup window to open asking for password?

8 Jul 2013 by a2ulthakur

i have a button in my template field in gridview what i want is on button click i want a popup window to open asking for password and when authentication is complete it will redirect me to another page. i am new to vb.net so is there any way of getting a popup window opened at button click event...

Oracle

how to show logged in user as first record on top inside gridview column?

8 Jul 2013 by a2ulthakur

i have a gridview with employee designation and a querystring in page which has employee no. what i want is the employee who is logged in his designation should be shown on top of my gridview column

Oracle

gridview hidden column works fine in the 1st go then it gets messy?

11 Jul 2013 by a2ulthakur

i have a dropdown list according to whose selected value i have to show and hide a column in gridview. i am able to do this but there is a problem sometimes the code works fine and the column gets hidden other times it is shown.here is my code sample

Oracle

how to bind same gridview with two different data tables based on dropdown selection?

13 Jul 2013 by a2ulthakur

my problem is i have a dropdown list in which i have 2 options gatepass and leave now for the leave gridview i have declared bound fields and i am populating it from a datasource let that datasource be dt1 now for gatepass (dt2) option i want to use the same gridview but the columns are not same...

Oracle

ASP.NET

i need to merge to unrelated datatables into one dataset when i am doing this its only taking data from 1st table ?

13 Jul 2013 by a2ulthakur

my problem is i have two data tables i want to merge them in a dataset which when i am doing its not able to locate the elements of 2nd datatable con.Open() Dim str As String str = "select ProductCategoryKey,ProductCategoryAlternateKey,EnglishProductCategoryName from...

SQL-Server

Oracle

ASP.NET

Generating html page along with inserting data in database whenever user fills details in feedback form ?

11 Aug 2013 by a2ulthakur

i have a requirement i have to generate a HTML file whenever data is inserted into database from a feedback form. The Html form will serve as an instant data-display mechanism? i have done the insertion part but i don't know how to go about generating Html file of all the data filled in feedback...

SQL-Server

Oracle

ASP.NET

Find first date missing in postgresql. Have a table and I want to find out first non-existing date starting from now() to now()+30days. Lets assume today is 21.

21 Jun 2021 by a_horse_with_no_name_2

i have a table and i want to find out first non-existing date starting from now() to now()+30days. lets assume today is 21. >| userId | dates | | 1 | 2021-06-22 00:00:00| | 1 | 2021-06-24 00:00:00| | 2 | 2021-06-21...

SQL

PostgreSQL

Oracle

Uploading files to the database using C#

28 Feb 2014 by aa00101

HiI'm trying to upload files to Oracle database and retrieve it. However, I didn't find it a comprehensive example to follow. There are some codes I didn't understand . .Please have a look at my codes and help me to do it.Thank youExample I followed : ...

Oracle

Input string was not in a correct format

8 Apr 2014 by aa00101

I'm using oracle and C# to download files that I uploaded.The upload file is working fine but the download function is not.I think the reason behind it,is passing the wrong string format but I don't know how to correct it.I tied to usetryparse but didn't work because I think I didn't use it well...

VS2012

Oracle

ORA-01036: illegal variable name/number in C#

8 Apr 2014 by aa00101

HiCan anyone help me please fox this error? I tried anything I know but still getting same error.Thank you cmd.ExecuteNonQuery(); conn.Close(); GridView1.EditIndex = -1; BindData();

Oracle

Best way to handle the errors & Managing Logs

9 Jan 2012 by Aabidhabanu

Hello frens, I am working in Layered Architecture.We are working towards re-design a new product.My team is in the verge of discussions & analysis to follow the best way to manage errors & maintains log for it without using third party tool such as Log4Net irrespective of the platform...

C#4.0

SAP

Oracle

how to make stored procedure for display all data from table in oracle

19 Oct 2011 by aamir sajjad

CREATE OR REPLACE PROCEDURE skeletonISBEGIN select * from table_nameEND;it is better to use column name instead of * in select such as table_name.Id for performance reasons

Oracle

how to make stored procedure for display all data from table in oracle

19 Oct 2011 by aamir sajjad

may be this link help you. actually we need to define cursor as far as i recall to retrieve values using providerhttp://msdn.microsoft.com/en-us/library/ms971506.aspx[^]

Oracle

Current table name for Data Grid View

2 Feb 2013 by Aarti Meswania

this wayDataSet ds = new DataSet();OracleDataAdapter ndadptr = new OracleDataAdapter("SELECT * FROM "+ listBox1.SelectedItem.ToString(), OrConn.conn);ndadptr.Fill(ds);dataGridView1.DataSource = ds.Tables[0];dataGridView1.DataMember = ds.Tables[0].Name;then you will...

.NET

Oracle

ODP.NET

Sub Query More than one row How ?

18 Apr 2013 by Aarti Meswania

try this...SELECT bovd.CusCode, bovd.RecQty from BookOrdVehDetail bovd INNER JOIN VehicleSalesDetail vsd ON bovd.CusCode = vsd.CusCodeWHERE (SELECT sum(cast(bovd1.Qty AS int)) From BookOrdVehDetail bovd1 Group By bovd1.CusCode having bovd.CusCode=bovd1.CusCode)>(select count(vsd1.RecNo)...

SQL

Oracle

SQL-Server

Error inserting datepart

2 May 2013 by Aarti Meswania

example...insert into tablename( mysqldate ) values( '2013-12-25'--format is yyyy-MM-dd )Happy coding!:)

Oracle

IF/ELSE in WHERE statement in ORACLE

5 May 2013 by Aarti Meswania

Try This,SELECT P.*FROM PTABLE PLEFT JOIN MTABLE M ON P.MATERIALID = M.MATERIALIDLEFT JOIN NTABLE R ON P.MATERIALID = N.MATERIALIDWHERE M.MATERIAL = CASE WHEN P.MATERIAL IS NOT NULL THEN N.MATERIAL ELSE P.MATERIAL ENDHappy Coding!:)

T-SQL

Oracle

Searching a phone number from DB

22 May 2013 by Aarti Meswania

this way...Select Number from Contacts where convert(varchar,Number) like '%4567%'Happy Coding!:)

SQL

Oracle

DROP TABLE IF EXIST in oracle

29 May 2013 by Aarti Meswania

if you want to check table exist or not then query should like below...select count(*)from all_objectswhere object_type in ('TABLE','VIEW')and object_name = 'your_table_name';OR...DECLARE tbl_exist PLS_INTEGER;BEGINselect count(*) into tbl_exist from user_tables where...

Oracle

Oracle / PLSQL: ROUND function ISSUE

6 May 2017 by Abdirizak Mohamed

Hi Guys I have issue of Round in Oracle / plsql; I'm Developing System Transfer Different Currency; What I have tried: Example: SELECT ROUND(14787 / 3.6697,2) FROM DUAL; Result: 4029.48 Checking SELECT ROUND(4029.48 * 3.6697,2) FROM DUAL Result : 14786.98 So 14787 != 14786.98 so what...

Convert sql server insert script into oracle insert script?

17 Mar 2015 by Abdul Imran

Convert sql server insert script into oracle insert script?this sql server script below..INSERT [dbo].[tblPayMaster] ([NoteNumber], [NoteDate], [CentreCode], [ParamCode], [Fromdate], [ToDate], [PayedServiceType], [PayedEmployeeType], [PayedServiceStatus], [LocationType], [LocatonCode],...

Oracle

Oracle command query return no rows in C#

18 Apr 2018 by Abdullah...

Hi, i'm using below code to retrieve date from oracle db. i'm using oracle client 11.2.0. when i copied query to SQL Developer, query resulted rows. do i have to configure oracle client 11.2.0 to be able to use it ? or what i have to do to be able to get desired result ? Thanks in advance. ...

Oracle

Country, State/Region/Province and City Database for a new site

27 Jan 2020 by abdulsafran

Hello Dear Experts,For my latest web site, I need latest information about Country, it's States/Regions/Provinces and it's Cities. Could you please let me know where can I get those information freely?

SQL

Oracle

MySQL

Sql query to be solved the salary of employee dealing with customer having id=4 has been doubled

24 Feb 2020 by Abed Al Rahman Hussien Balhawan

create table employee (emp_id integer not null, manager_id integer not null, emp_name char(20) not null, emp_tel char(10), emp_salary number not null, hire_date date, constraint pk_employee primary key(emp_id) ); create...

SQL

Oracle

database

Sql QUERY the salary of employee dealing with customer having id=4 has been doubled

2 Mar 2020 by Abed Al Rahman Hussien Balhawan

customer table (CUST_ID,CUST_NAME,CUST_ADDRESS,EMP_ID) Employee table(EMP_ID,MANAGER_ID,EMP_NAME,EMP_TEL,EMP_SALARY,HIRE_DATE,DEPENDENT_NAME) The salary of employee dealing with customer having id=4 has been doubled What I have tried: ...

Oracle

database

Sql query update, customer with id=3 had his account balances increased by 10

2 Mar 2020 by Abed Al Rahman Hussien Balhawan

customer table (CUST_ID,CUST_NAME,CUST_ADDRESS,EMP_ID) has table (CUST_ID,ACCOUNT_NUMBER) table account(ACCOUNT_NUMBER,ACCOUNT_BALANCE) Customer with id=3 had his account balances increased by 10% What I have tried: UPDATE account SET...

SQL

Oracle

database