oracle tag

46 questions

1 answers
72 views
0

I want to create random TIMESTAMP values in a range.

[Objective] I want to create random TIMESTAMP values in a range[Prerequisite] environment:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0-64bit Production [Execution SQL] TA TABLE 1: TIMESTA...

sql oracle

2 years ago

2 answers
70 views
0

ORACLE sql performance tuning. There are two date types of items in one table, and I would like to create an effective index to join them.

This is a question about performance tuning for tuning.There is currently one table in which there are two date types (TIMESTAMP(6) with local timezobe).When I write SQL, those two dates need to match...

sql oracle

2 years ago

1 answers
89 views
0

Is it possible to specify parameter Bind in SQL Server?

We are developing a database operation program at C#.Oracle sets OracleCommand's BindByName to true to by parameter namingI think it is possible to set parameters, but is there an option like this in ...

c# sql-server oracle

2 years ago

2 answers
79 views
0

Understanding the Coexistence of 32-bit and 64-bit Oracle Clients

We currently run business applications (created in VB.NET) on Windows Server 2012.The 64-bit version of Oracle 12c (database and client) is installed on Windows 10 (x64) clients, maintaining applicati...

oracle

2 years ago

1 answers
52 views
0

Error in importing dmp file in SQL Developer cannot be resolved

I want to import dmp files exported from a different database into my database, but I get the following error when importing dmp files in SQL Developer:error messages:Exception: ORA-39001: Invalid arg...

sql oracle

2 years ago

1 answers
69 views
0

I want to submit a year that meets the specified criteria in SQL.

I would like to know the total number of vacation days for each employee in chronological order and the year in which the total number of vacation days exceeds 10.It would be very helpful if you could...

sql oracle

2 years ago

1 answers
81 views
0

I want to prevent SQL from deleting comment statements on the c file created by pro*c precompilation

pro*c is used to develop a business application that handles Oracle databases, but if you write the SQL portion embedded with comments (bound by /* to */) in the pc file and precompile it.For example,...

c sql oracle

2 years ago

1 answers
96 views
0

Could you look at the virtual box error?

Hello.I usually leave two virtual machines (Linux) on my way home.However, last night, while I was up and about, this window 10 guy did an arbitrary update.Virtual machine writes Oracle VM... The virt...

oracle virtualbox

2 years ago

1 answers
86 views
0

I'm curious about the theory of ORACLE INDEX.

I'm studying about indexes.It's a source that compares indexes with those using DML I have a few questions.create table emp3( no number, name varchar2(10), salary number ); insert into emp3 values (1,...

oracle index

2 years ago

1 answers
94 views
0

Oracle is converting to mysql, but the query is too complicated.

Converting from Oracle to mysql...select days.mdate , ifnull(login_cnt,0) as login_cnt , ifnull(logout_cnt,0) as logout_cnt from ( select '2016-06-16' as mdate from ts_user where limit 1,1 ) days left...

oracle mysql

2 years ago

- 3 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656