Oracle

Dear Team, I have a project with backend as Oracle. But, while accessing the ORacle Database from Visual Studio 2017, I am getting the following error - OCIEnvCreate failed with return code -1 but error message text was not available. PLease guide - How do I resolve this ?

How to import export database with in Oracle along with data or without losing data

Procedure Name Start Time End Time Elapsed Time Script1 021219 05:23:34 021219 05:23:38 4 Seconds Script2 021219 05:23:39 021219 05:23:39 0 Second Script3 021219 05:23:40 021219 05:24:00 20 Seconds

Kumar MalloluMar 13, 202085210

Why Oracle Certification is too Important to becoming an Oracle Administrator If Someone having more than 6 years of experience then can he get a good opportunity in the marketing industry? If yes then list out the companies who are hiring with this approach and How?

CREATE OR REPLACE PROCEDURE USPX_TEST ( NAME IN VARCHAR2,cb_results_cursor OUT SYS_REFCURSOR) IS BEGIN OPEN cb_results_cursor FOR SELECT * FROM EMPLOYEES WHERE EMP_NAME = NAME ; END USPX_TEST; Please provide me how to convert this same procedure in postgreSQL. NOTE: we need to return the result in a cursor using out parameter Thanks in advance...

What will be the query of below mentioned question in Oracle ? Display each employee’s last name, hire date, and salary review date, which is the first Monday after six months of service. Label the column REVIEW. Format the dates to appear in the format similar to “Monday, the Thirty-First of July, 2000.”

Vikas Kumar GargFeb 10, 20201,78210

I have input data like example need to convert as decimal Ex : 24:30:02 output as 24.5 Thank you.

Hey, While fetching Datetime, I am getting result as 21/02/2016 but when i assign this value to another Datetime,it's show 21/02/16.20 gets remove. Thanks

Amit Kumar SinghJul 23, 20191,25610

I have table1 and it has child tables, i want to reinsert data into every table. how to write scriept for this.? please help me on that.

I want to restrict my user dont enter password in sequential letters and numbers too,Is there any method in Oracle databse to achieve my this goal? Actually i did all the client requirement related to password security through Oracle Database SP, but i am unable to do this requiremet. is there anyone who help me out ? Thanks in Advance...

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, 201974310

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, 201899410

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.

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, 201889610

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,81910

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,34110

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,44210

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,00410

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.