Oracle

I need to return "-1" if username exixts and i need to return 1 if username is new and then insert values into table. This procedure is for Registering UserName and Password For Login -------------------------------------------------------------------------------------------------------------- CREATE OR REPLACE PROCEDURE debopriyo_savelogindetails ( p_nameofuser debopriyo_logindetailstable.nameofuser%TYPE, p_username debopriyo_logindetailstable.username%TYPE, p_userpassword debopriyo_logindetailstable.userpassword%TYPE ) IS v_count number; v_returncode number; BEGIN select count(t.username) into v_count from debopriyo_logindetailstable t; if(v_count>0) then v_returncode := -1; ELSE v_returncode := 1; INSERT INTO debopriyo_logincredentials (nameofuser, username, userpassword) VALUES (p_nameofuser, p_username, p_userpassword); END IF; RETURN v_returncode; END;

i want to became a Dot Net developer , there will be sql is the most important for a developer .

I have a datatable in C# that I want to pass as parameter in oracle stored procedure by converting into xml. I have achieved it using sp_xml_preparedocument in SQL Server but, I want to implement same in oracle.

Anil JhaAug 8, 20177,43710

I have one requirement where the table will be like this --------------------- Name | Amount | --------------------- Raju | 2000 | ---------------------- Rajesh | 4000 |</

I have data in notepad, need to upload to oracle server using toad software. Suggest me.

Pavan RamamurthyJul 27, 20171,03010

Dear all, My machine is 64-bit Windows 7 with 8GB RAM. I have installed Oracle 11g Client - both 32-bit and 64-bit. I am using SQLDeveloper to connect to the client. Toad is not working - Error - "Cannot load oci.dll file" - I checked in BIN Folder - FIle is there. My Queries are - 1. My portal has backend as Oracle. WHen I run it on my machine to debug, it gives error - BadImageFormatException. This will occur when running in 64 bit mode with the 32 bit Oracle client components installed Exact Error Message - Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. How to solve this ? 2.In SQLDeveloper - How to find which client the SQLDEveloper has connected to. 3. TOAD - From where to download TOAD That is compatible with Oracle 11g client.

Hi all i have one query with union select name from employee_1 Union select name from employee_2 , here i want to display all employee results , if i have an employee with name ='ganesh' , if there is no such employee with name='ganesh' then dont return any result from query pls help me on this

when i execute my query i don't get the needed result the word "conversion" was showed in place of my word result

SELECT NARRATION,PARTICULARS,TO_CHAR(VOUCHER_DATE,'dd-Mon-yyyy') VOUCHER_DATE, nvl(CREDIT,0) RECEIPT, NVL(DEBIT,0) PAYMENT, NVL(CREDIT,0) - nvl(DEBIT,0) BALANCE,SUM (NVL(CREDIT,0) - nvl(DEBIT,0)) OVER (PARTITION BY VOUCHER_DATE ORDER BY ROWNUM) CUM_BAL FROM EGMSDBA.VOUCHER_DETAILS WHERE NARRATION IN ('Cash Receipt','Cash Payment','Cash Deposit') AND VOUCHER_DATE BETWEEN '01-Apr-2016' AND '01-Apr-2017' ORDER BY VOUCHER_DATE,VOUCHER_SL_NO; NARRATION PARTICULARS DATE RECEIPT PAYMENT BALANCE ------------------ ----------------------- ----------- ----------------- ----------------- --------------------- Cash Receipt Aroma Agrotech Pvt Ltd 21-Feb-2017 100000 0 100000 Cash Payment Dalmir S/O Surat Singh 21-Feb-2017 0 550 94500 Cash Payment Dilbag S/O Ramkishan 21-Feb-2017 0 2500 92000 Cash Payment Dilbagh S/O Sewa 21-Feb-2017 0 1700 90300 Cash Deposit Canara Banks 21-

Hai, i need to convert row into column in mysql without using case

snowal rajApr 7, 20173,09810

HI FRNDS i have insert the data in db . here i m assign task to some and store data in another table . i have a table like user id, assign , date, Creadted by , category now i insert the data form the data base using assign dropdown list and save to another table and update also and my another table where i changed assign data to some save in below table user id, assign , date, category here also updated data successfully but if i update the data so want to see old value in this table how to do this means if i update dropdownlist means assign to other old value how to show in table . create or replace PROCEDURE RECORD_INSERT_ASSIGN ( P_USER_ID NUMBER, P_ASSIGN VARCHAR2, P_CREATED_DT DATE, P_USER_ID OUT NUMBER ) AS BEGIN END RECORD_INSERT_ASSIGN ;

How to install Oracle database on my matchin. I have two files winx64_12102_database_1of2 and win64_11gR2_database_2of2. but it can installed succesfully.

Henok YeshitilaMar 17, 201794210

Unable to delete record in trigger. Can we write Delete statement in After Update Trigger in Oracale? For Example : - My Trigger : Create or replace TRIGGER TranxMaster_after_update AFTER UPDATE ON Transaction FOR EACH ROW DECLARE vcrTranxID VARCHAR2(100); BEGIN INSERT INTO TRANSACTIONNew ( ID, MOBILENO, TrnTYPE, AMOUNT, TranxID) VALUES ( :new.ID, :new.MOBILENO, :new.TrnTYPE, :new.AMOUNT, :new.TranxID) SELECT TranxID INTO vcrTranxID FROM TransactionNew WHERE ID=:new.ID; IF vcrTranxID IS NOT NULL THEN DELETE FROM Transaction WHERE ID = :new.ID; End IF; END;

Subhashkumar YadavMar 9, 20171,39110

Hai, I need to get difference of two datetime, and that diff value is set in next column. like Date Duration 28-02-2017 17:46:00 28-02-2017 17:47:00 00:01:00 28-02-2017 17:49:00 00:02:00 28-02-2017 17:55:00 00:06:00 Total 00:09:00

snowal rajFeb 28, 201792410

Hi frnds I have a db with procedure trigger n all. Now i want to copy this db and use to my another system so how to do this?, 2... i have mvc project and how to copy tht project and use to another sys. Note -- firstly that project i need to send by mail becz its more mb so how to send tht project

Hi frnds how to insert data using oracle data base in mvc using stored procedure?

hi frnds I created procedure using oracle data base. here I am using 3 tbles where I want to insert the data using 3 tables I created this but getting error I am sharing the code please let me know where I did mistake I checked by internet but not getting solution CREATE OR REPLACE PROCEDURE PROC_INSERT_RECORD ( P_PROJ_ID VARCHAR2, (table1) P_ASSIGNEDTO VARCHAR2, P_DUE_DT VARCHAR2, (table 2) P_PROB_STATEMENT VARCHAR2 (table 2) ) AS BEGIN --add Record. INSERT INTO App_UsER (PROJ_ID, ASSIGNEDTO, DUE_DT, PROB_STATEMENT) VALUES(P_PROJ_ID, P_ASSIGNEDTO, P_DUE_DT, P_PROB_STATEMENT); COMMIT; END PROC_INSERT_RECORD;

hai, I need Time Wise Sales Report in mysql,I get the Report like , Time Amount 19:00:00 2 20:00:00 3 21:00:00 0 22:00:00 0 23:00:00 9 but I need sum the Amount each time like Time Amount 19:00:00 2 20:00:00 5 21:00:00 5 22:00:00 5 23:00:00 14 This is My Query <span style="color: #111111; font-family: 'Segoe UI', Arial, sans-serif; font-size: 14px; background-

snowal rajFeb 4, 201793710

hai, I have some data like Date Amount 30-01-2017 19:07:46 10 30-01-2017 19:08:52 20 30-01-2017 19:15:10 65 30-01-2017 19:16:58 85 30-01-2017 19:17:13 48 30-01-2017 19:20:05 165 30-01-2017 19:20:29 15 30-01-2017 19:38:53 98 30-01-2017 19:40:15 35

snowal rajFeb 3, 20171,00810

Hi frnds i am new on linq . i have a table with entityframework using oracle. now i want select stmt using linq so please tell me how to do that and where i will write to this stmt .

From C# Code, I'm trying to call a PACKAGE.PROCEDURE() from Oracle. In this simple example I should get one value from the procedure call, but all I get is error: > wrong number or types of arguments in call to 'RETURN_NUM' The procedure is declared as follows: PROCEDURE return_num(xNum OUT NUMBER) AS BEGIN xNum:= 50; dbms_output.put_line( 'hello world ' || xNum); END ; C# code: Oraclecon.Open(); OleDbCommand myCMD = new OleDbCommand( "TEST.return_num" , Oraclecon); myCMD.CommandType = CommandType.StoredProcedure; myCMD.Parameters.Add( "xNum" , OleDbType.Numeric); OleDbDataReader myReader;&n

In a table column i've data as given below <PivotSet> <item> <column name = "RNO">1</column> <column name = "MIN(INSGRP)">Record- 001</column> </item> <item> <column name = "RNO">2</column> <column name = "MIN(INSGRP)">Record- 002</column> </item> <item> <column name = "RNO">3</column> <column name = "MIN(INSGRP)">Record- 003</column> <div id="pastingspan1" style="

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 below SELECT * FROM( SELECT ROW_NUMBER() OVER (PARTITION BY IAI_COVERNUMBER,IAI_VERNO ORDER BY IAI_COVERNUMBER) AS RNO, IAI_COVERNUMBER AS INSGRP FROM IAI_ACTUALINSURERS INNER JOIN PLY_POLICY ON (IAI_COVERNUMBER=PLY_COVERNUMBER AND IAI_VERNO=PLY_VERNO) WHERE IAI_COVERNUMBER in ('0011520','0010891') <div id="pastingspan1" style="font