Oracle

Hi, My data is like this formate.-Using Query SELECT DISTINCT W.CONTRACTNUM, W.STARTDATE,W.POSITIONDESC, W.RATE801 FROM BI_HZ_ETL.LEM_CNRLEMCRAFTRATE W WHERE W.CONTRACTNUM='A689' GROUP BY W.CONTRACTNUM,W.POSITIONDESC,W.STARTDATE,W.RATE801 ORDER BY W.CONTRACTNUM,W.POSITIONDESC,W.STARTDATE CONTRACTNUM POSITIONDESC RATE801 STARTDATE A689 ACC+PR 71.88 2/6/2022 A689 ACC+PR 72.77 1/1/2023 A689 ACC+PR 73 1/1/2024 A689 ADM+L1 45.07 2/6/2022 A689 ADM+L1 47.86 1/1/2023 A689 ADM+L1 48.01 1/1/2024 A689 ADM+TK 53.11 2/6/2022 A689 ADM+TK 56.41 1/1/2023 A689 ADM+TK 56.58 1/1/2024 A689 CO+HSE/DSP 93.15 1/1/2023 A689 CO+HSE/DSP 93.15 1/1/2024 A689 CO+MAT 67.35 2/6/2022 A689 CO+MAT 72.23 1/1/2023 A689 CO+MAT 72.46 1/1/2024 A689 CO+PR 71.88 2/6/2022 A689 CO+PR 76.37 1/1/2023 A689 CO+PR 76.61

We are using LDAP to find the list of active users. From DB we are connecting to LDAP. The DB Servers are on Linux Azure Cloud. From DB Servers to LDAP Servers we raised a Azure Firewall request for both port 636(Encrypted Port) and 389(Non Encrypted Port). Firewall rules are in place and connectivity is working. Now from DB able to connect to LDAP over port 389 but not able to connect to LDAP over port 636. For port 636 it gives following error DBMS_LDAP Still Fails: ORA-31202: DBMS_LDAP: LDAP client/server error: SSL handshake failed What needs to be done for this,please can someone suggest?

Aniket NarvankarJan 2, 20243,93810Forum

I have two tables one is students_Games and one is students tables both have a student_id a primary foriegn key relationship now based on their games I am putting them in some queue Student table {Student_id,name,Address} Students_games(id,Student_ID(FOREIGNKEY,game_code), table_ID student_id game Code 1 1 200 2 2 200 3 2 300 4 3 200 5 3 300 6 4 870 My Qyuery is like this Select * from studnets ss join students_games gg on gg.Student_id=ss.student_Id where gg.Games_code in (200,300) Now when i run this for student id 2 and 3 it will return two,two rows one for 200 and one for 300 , now I want to set the prioirty like if there is 200 available then it must return 200, if not then it should return 300 if both of them not present then it should return 0 . how to query it like that i mean if 200 game code is available then chose it for every student and don't chose 300 for it if 200 is available if 200 is not available then chose 300 as game code if both of them not there then chose 0

Database name is TEST, user name test, pass test1234 I create fake acocunt, conection to db work Data are located ond next loaction: When connected do db OTHER USERS/MASTER/Table1 How to read that data to datarid? I try this cod and have error: NETWORK LIBRARY: Name-Value syntax error Error number: ORA-00303 private void TABLE_fill() { String connectionString = "Data Source=(" + " TEST = " + " (DESCRIPTION = " + " (ADDRESS = (PROTOCOL = TCP)(HOST = test.localdomain.intra)(PORT = 1521)) " + " (CONNECT_DATA = " + " (SERVICE_NAME = TEST) " + " (INSTANCE_NAME = TEST) " + " ) " + " ) " + " User Id=test; password=test1234; "; OracleConnection con = new OracleConnection(); con.ConnectionString = connectionString; con.Open(); OracleCommand cmd= new OracleCommand(); cmd.CommandText = "select * from Table1"; cmd.Connection= con; cmd.CommandType = CommandType.Text; //cmd.ExecuteNonQuery(); OracleDataReader dr = cmd.ExecuteReader(); dr.Read(); System.Data.DataTable dataTable = new System.Data.DataTable(); dataTable.Load(dr); ListDataGridView.DataSource = dataTable; ListDataGridView.Update(); ListDataGridView.Refresh(); }

Account Description Beginning Balance Debits Credits <td colspan="2" style="background-color:#dfeaf3; border-bottom:none

Upload an Excel file in ASP.NET, read worksheet data with OleDb into a DataSet, and insert each row into an Oracle table.

Ziauddin ChoudharyOct 18, 20234,5031,000Article

Can I install Oracle 23c (free) in a server with CentOS and use it for learning and training. Also no license cost or any other cost .. Please advise.

In this article, I want to explain how to improve your application performance using Oracle Data Provider for .NET (ODP.NET) and the new features exposed by the underlying Oracle Call Interface.

John Charles OlamendyJul 25, 202322,9191,000Article

Hi, Error - ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 1 in I have declared SP Parameter. P_user_id varchar2 DEFAULT '', P_USER_PASSWORD varchar2 DEFAULT '', P_OUT_USER_ID OUT NUMBER , P_OUT_MSG_ID OUT NUMBER Regards, Pratik

SIGNIFICANCE OF (+) symbol in the join in Oracle SQL

Krishnaveni ShanmugabaluMay 12, 202324,094250Blog

PROCEDURE InsertCustomerEvaluation( cef_cust_id IN VARCHAR, cef_ce_id out number)AS cef_c_e_id NUMBER; BEGIN BEGIN SELECT CEF_CUSTOMER_EVA_SEQ.NEXTVAL INTO cef_c_e_id FROM dual; cef_ce_id:=cef_c_e_id; INSERT INTO CEF_CUSTOMER_EVALUATION ( C_E_ID, CUST_ID, E_R_ID, SCORE, FILLED_DATE ) VALUES ( cef_ce_id, cef_cust_id, 1, '', sysdate ); END; END InsertCustomerEvaluation; Below is my code in back end. public int InsertCustomerEvaluation(string CUST_ID) { OracleParameter C_E_ID = new OracleParameter("C_E_ID", OracleDbType.Decimal); C_E_ID.Direction = ParameterDirection.Output; try { ce_id = _context.Database.ExecuteSqlRaw ("DECLARE C_E_ID NUMBER; BEGIN CEF_APP.InsertCustomerEvaluation(:CUST_ID,:C_E_ID);:C_E_ID:=C_E_ID; END;", new OracleParameter("CUST_ID", CUST_ID), C_E_ID); } &nb

By following these best practices and utilizing the various date and time functions in Oracle SQL, you can effectively work with and manipulate date/time data in your queries.

Krishnaveni ShanmugabaluApr 12, 20238,354250Blog

Error in Accessing DBMS_Crypto package Encrypt and Decrypt Function Getting Error "PLS-00201: identifier 'SYS.DBMS_CRYPTO' must be declared" select sys. DBMS_CRYPTO.encrypt (UTL_RAW.CAST_TO_RAW ('ABCDEFGH12345'), 4356 /* = dbms_crypto.DES_CBC_PKCS5 */ , 'A1A2A3A4A5A6CAFE') from dual;

I am trying to connect to oracle sql developer through .net application but getting this error ORA-12154: TNS:could not resolve the connect identifier specified Please let me know how can this issue be resolved

Aniket NarvankarMar 3, 20231,34010Forum

In this blog, you will learn how to create an index in oracle.

Arvind YadavFeb 21, 20233,800250Blog

In this blog, you will learn how to create Table Structure from Existing Table in Oracle SQL.

Arvind YadavFeb 21, 202324,593250Blog

Hello, I want to get records between date range, using Oracle-PL/Sql. Following is the query: Select * From [Table_Name] where (to_date(P_End_Date, 'DD/MM/YYYY') between to_date(FromDate, 'DD/MM/YYYY') and to_date(ToDate, 'DD/MM/YYYY')); P_End_Date, FromDate and ToDate are of Varchar datatype I am getting error in query as ORA - 01843:Not a valid month P_End_Date column has Hypen(-) or Slash(/) in some records in my table, will it affect error in query ? Thank you

I have no problem connectiong to ORACLE using the classic default authentication user/password. In such a case, I use a connection string like string conn = "User Id=mike;Password=\"mike\";Data Source=localhost:1521/oraservice;Pooling = false;Connection Timeout=60;"; I attempted to find information about how to connect via Kerberos, without luck. Somewhere I saw that there may be another parameter in the string, called Integrated Security = yes. However, when I try to use it, I get the message that it is an invalid parameter. I am also sure I have to somehow pass the paths to these two Kerberos file Configuration File: krb5.conf Cache File: KRB5cc_<userid> Anybody had experience with Oracle/Kerberos access in C#?

I would like to ask a simple question I have oracle database in which I have Training Database Now when I am using ASP.NET ENTITY data model from database and giving my connection detail I am able to see all tables in the Training database, Now I require 3-4 more tables which the DBA created under DATABASE-->OTHER USERS-->TESTUSER so I am using same connection information for my entity data model I am able to see the tables of training but not able to see the tables which the DBA created under other users-->testuser any idea/?

hi dear all... how can i using scanner device in form oracle builder 10g or any javaclass .jar that i could to embeded within my project in oracle form 10g

basim salihJul 29, 20221,20210Forum

I have a table in which I have Users ( userId,User_National_number,Date_Of_registratration) I have another excel sheet in which I have (user_social_number) I want to add two more columns in my excel with one columne as boolean yes/no and one as date , I would like to update the excel sheet I want to show Yes in front of user_social_number in my excel sheet if that user is available in my table along with its date of registration , How can I query that ,

Does anyone have any experience with the following error? Thanks, Will Server Error in '/RSWeb' Application. Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. 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: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. ] System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction) +202 System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact) +600 System.Data.OracleClient.OracleConnection.Open() +32 AMAT.DataAccess.Utilities.DAMapHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, OracleParameter[] commandParameters) +54 AMAT.DataAccess.MasterDB.Master.GetSingleDRValue(String