Oracle

Hi, we have 5 databases and we want to host it to production Server (Windows Server 2012). what is the recommended solution to host Multiple databases i.e, Hosting All 5 Databases on Seperate VM is Better or All 5 DB Should be hosted in Seperate Physical Servers? Pls. Advise. I am not much into DBA

How do you differentiate Apps schema from other schemas?

Sridevi KoduruMar 18, 201974310Forum

I am having 2 servers, 1 web server and 2nd oracle server (Oracle 8i) after some time we lost database connectivity with our Oracle server from the Web server, due to this user is not able to login to the webpage.

Value Sets are a Set or List of Values (LOV) that are usually predefined and are used in Flexfields and concurrent programs. Value sets can be said as container of values . A value set is used in Oracle Applications to restrict the values <span style="color: #222222; fo

Sridevi KoduruNov 8, 201899410Forum

What are the steps to learn complete databse??

hi guys some how my laptop windows was corrupted so i have to intall it again but i lost all my software like vs mssql mongodb and oracle i didnt had any backup of them can anyone tell me that how and from i can get them again.

In this video, I have explained the process of downloading virtual-box software from Oracle's site and then we will go into its installation process. After installation, we will create a Virtual Machine and will look into the configuration of that newly created VM like Virtual Hard Drive.

Zia Ahmed ShaikhSep 25, 20188,220250Video

ihave done ms sql server now i wanna do oracle what are the diffrence betwen them. can i directly get online certificate like microsoft gives MTA

Ankur SharmaSep 10, 201889610Forum

This article shows the use of Oracle cursors for loops with an appropriate example. The process of opening, fetching, and closing is handled implicitly by a cursors FOR LOOP. If there is a need to FETCH and PROCESS each and every record from a cursor, the cursor FOR LOOP is helpful for that.

Nipun TomarAug 31, 201820,9431,000Article

I am calling one activity for csv download in IE9 utilizing OAF system. Subsequent to handling gets finished, program is demonstrating the csv to Save or Download. Yet, the issue is my program gets hanged with handling mouse sign, for which I need to press F5 to slaughter the session. https://goo.gl/DeoSsF At that point program is enabling me to Open/Download the CSV document. The prob is ,I am ready to close the session at program level as I have been utilizing OAF and no javascripts codes are being utilized as a part of my code. HttpServletResponse response = (HttpServletResponse)pageContext.getRenderingContext().getServletResponse(); response.setContentType( "text/csv" ); response.setHeader( "Content-Disposition" , "attachment; filename=" + file_name + ".csv" ); ServletOutputStream pw = null ;

Hi, I have alegacy SSIS package which is started failing suddenly. It has select query from Oracle. SELECT a.INVENTORY_ID, a.VERSION_NAME FROM TESTDATA.INVENTORY_VERSION a INNER JOIN (SELECT INVENTORY_ID, MAX(LAST_UPDT_DTTIME) AS mupdtdt FROM TESTDATA.INVENTORY_VERSION b WHERE (ACTIVE_FLAG = 'Y') GROUP BY INVENTORY_ID) maxinv ON maxinv.INVENTORY_ID = a.INVENTORY_ID AND maxinv.mupdtdt = a.LAST_UPDT_DTTIME WHERE (a.ACTIVE_FLAG = 'Y') GROUP BY a.INVENTORY_ID, a.VERSION_NAME ORDER BY a.INVENTORY_ID I don't have any oracle experience, getting following error Error: System.InvalidOperationException: Internal .Net Framework Data Provider error 30. at System.Data.ProviderBase.DbBuffer.Validate(Int32 offset, Int32 count) at System.Data.ProviderBase.DbBuffer.PtrToStringUni(Int32 offset) <div id="p

Tushar DikshitApr 22, 20185,81910Forum

Please any one help me.I am new in oracle.I have .bak file for oracle 11g.I want to restore that .bak file into oracle 11g database.

How can to make dataGridview updated dynamically after insert,update or delete, however dataGridview updated but after I close the program? I use Oracle 10g.

Mujeeb MohammedMar 12, 20181,34110Forum

Hi, How to install Oracle 11g R2 in CentOS 7. Thanks

How to make Oracle database 10g accept and retrieve arabic values in WAP?

Mujeeb MohammedMar 6, 20181,44210Forum

Hey, I have one table in which every year employee increment records inserted.I have requirement to fetch last record inserted in table. I am trying this query in oracle Select * from table where employee_id=111 order by Next_Increment_date desc offset 0 rows fetch next 1 rows only Thanks in advance

Amit Kumar SinghDec 19, 20171,00410Forum

Hi the example you have given is very nice. It will be even more helpful if u can send me ER diagram for the library system which has been posted.

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,43710Forum