Data dodania Pytanie
2016-12-24 12:12 no Execute Oracle Procedure Java »
JAVA code public boolean userReg(User user) throws SQLException, ClassNotFoundException { Connection conn = null; CallableStatement cs = null...
(1) odpowiedzi
2016-12-24 00:12 Inline view limitations »
SELECT in_ev.type, pl.name, in_ev.year FROM places pl INNER JOIN (SELECT e.type, e.place_id, e.year FROM events e)in_ev ON...
(1) odpowiedzi
2016-12-23 22:12 Connect by return more rows than expected »
I am making a query for retrieving "future months" based on a project's forecast budget. Basically I am taking the last forecasted date (START_DATE) ...
(3) odpowiedzi
2016-12-23 20:12 Oracle Database 12 c , SQL Server Translator Is not Translating query »
I have installed SQLServer Translators as oracle document require to use 12 c jdbc jar so i replace this jar with jdbc jar. I have created transport a...
(0) odpowiedzi
2016-12-23 10:12 Create an Excel File (.xlsx) using PL/SQL »
In relation to my previous question Return the SQL Statement of an Explicit Cursor, i was able to generate an Excel (.xls) file using DBMS_SQL and UTL...
(3) odpowiedzi
2016-12-22 21:12 TROUBLE IN MULTIPLE SUBSELECT QUERY »
I need to find the name, function, officename and the salary of all employee with the same function as PETER or a salary greater or equal than the sal...
(2) odpowiedzi
2016-12-22 15:12 What is the difference between TRUNC and TO_DATE in Hive »
Hi i trying to find out what the difference between using a TRUNC and TO_DATE is in Hive. Currently within oracle I wrote the following case stateme...
(1) odpowiedzi
2016-12-22 05:12 ORA-32795: cannot insert into a generated always identity column »
Guys I am trying to execute below insert statement and I keep getting the error: cannot insert into a generated always identity column the state...
(2) odpowiedzi
2016-12-21 18:12 INNER JOIN performance with '<' or '>' condition »
I have two tables with the column SessionOrder. This column is an integer datatype and have the following index: CREATE INDEX OSIDX_<internal name&...
(3) odpowiedzi
2016-12-21 15:12 Disable all foreign key constraints associated to specific table »
I have table 'MY_TABLE' which has a primary key 'CODE' , this primary key has several foreign key constraints referencing it and I need to disable the...
(3) odpowiedzi
2016-12-21 08:12 Oracle query to fetch the previous value of a related row in same table »
I have a table Student which has name and ratings year wise. Name Year Rating Ram 2016 10 Sam 2016 9 Ram 2014 8 Sam ...
(2) odpowiedzi
2016-12-20 14:12 Multiple rows with null values - i want one row with not null »
My query result below: ID desc Year pid 0006845503 tes1 null null 0006845503 null 2017 nul...
(2) odpowiedzi
2016-12-20 13:12 Oracle - grouping values along interval »
I need to query a table, containing a step id + value. The result will list the intervals, along with their associated value. Intervals here are defin...
(2) odpowiedzi
2016-12-20 08:12 Oracle sql math calculation using current and previous row values »
I have the following table: ID A B C 1 1 23 22 2 2 19 20 3 5 18 15 4 3 12 12 Columns A and B are constants. I want to calc...
(2) odpowiedzi
2016-12-19 21:12 Sharing Oracle views between users with preexisting table permissions »
Is it possible to grant permission to use a view when the grantee already has select permissions on the underlying tables but the grantor does not hav...
(1) odpowiedzi
2016-12-19 20:12 How to transform a table into node pairs using SQL »
I have a database structured for user clicks. Every time someone clicks from a website to visit another website, I capture the username, website, and ...
(2) odpowiedzi
2016-12-19 07:12 PL SQL script to concatenate based on the column values »
I am stuck at one point while writing a PL SQL script. My requirement is to find the matching asset numbers, concatenate them and insert into a new t...
(3) odpowiedzi
2016-12-18 16:12 How to output the a record that is the result of a procedure? »
So, let's say I have a table like this one: CREATE TABLE MEETINGS( MEETING_DAY DATE, MEETING_ROOM NVARCHAR2(10), MEETING_DURATION NUMBER(...
(1) odpowiedzi
2016-12-18 14:12 Cannot convert String to date in Oracle 11g »
I'm trying to insert Date into table from user input but something doesn't work. I have the following Query : INSERT INTO DOCTORS.TREATMENTS ...
(1) odpowiedzi
2016-12-18 13:12 How to select unique records by ORACLE »
When I perform "SELECT * FROM table" I got results like below: ID Date Time Type ---------------------------------- 60 03/03/...
(3) odpowiedzi
2016-12-17 16:12 Using Dates in PL/SQL »
I am very new to using PL/SQL and I have created a procedure but I cannot figure out the correct syntax in order to get the current month and year's d...
(1) odpowiedzi
2016-12-17 15:12 Working with dates in Oracle SQL »
I am very new when it comes to using SQL and what I am attempting to do is select the waterUsage and electrcityUsage using only the month and year and...
(3) odpowiedzi
2016-12-17 13:12 query optimization for max function in oracle »
I am having a table name x which contain week-no where datatype of week number is varchar2 which fetches max(week-no) in 22 second. I need to fetch ro...
(1) odpowiedzi
2016-12-16 21:12 Managed ODP.NET Calls to PUBLIC Database Link tables cause TNS errors »
Our application uses managed ODP.NET code to call a variety of Oracle Procedures. For one of our clients, who is using public database links, and ...
(2) odpowiedzi
2016-12-16 17:12 Localhost doesn't forward requests to oracle docker container »
I m trying to switch from vagrant to docker (too late to go back now). I've deleted my oracle vbox already, and I have: Installed docker for mac Pu...
(2) odpowiedzi
2016-12-16 16:12 How do I create a Variable in PL/SQL whose value persists? »
I am writing a Procedure in which I need a value in a variable that I can both change and persist. To be more specific, this needs to be a counter...
(1) odpowiedzi
2016-12-15 15:12 Oracle: convert numbers to words in other language than English »
I'm trying to convert numbers in words. select to_char(to_date(:number,'j'),'jsp') from dual; SELECT TO_CHAR (TO_DATE (24834, 'j'), 'jsp') FROM DU...
(3) odpowiedzi
2016-12-15 12:12 TRUNC(date) with subquery in oracle »
I have a IF condition which checks the dates in the subquery as shown below IF (TRUNC(lv_d_itr) IN (SELECT next_day(TRUNC(to_date('01-01-17','dd-mm-y...
(2) odpowiedzi
2016-12-15 05:12 Performance and Readability of REGEXP_SUBSTR vs INSTR and SUBSTR »
From My other question, Using REGEXP_SUBSTR with Strings Qualifier, I'm trying to decide which approach would be better to use. The Resulting Data se...
(4) odpowiedzi
2016-12-14 13:12 Root cause of deadlock? »
I see below details for one of the deadlock detected in oracle 12g trace files but i am not getting why deadlock is happening here ? Deadlock happens...
(1) odpowiedzi
2016-12-14 11:12 sort order by desc not working as expected »
I have this query in SQL SELECT Book FROM Library ORDER BY Book desc My desired sort [Expired]Web Publishing Co., Ltd. [Expired]sBox Co.,Ltd [Exp...
(2) odpowiedzi
2016-12-14 00:12 Increasing Parallellism in Spark Executor without increasing Cores »
I am running a Spark-Kafka Streaming job with 4 executors(1 core each). And the kafka source topic had 50 partitions. In the foreachpartition of the ...
(2) odpowiedzi
2016-12-13 20:12 Case statement in Oracle with one condition returning the actual column »
I'm writing a CASE statement in ORACLE over TOAD which returns the actual value if it meets certain conditions otherwise returns a new string. The fo...
(2) odpowiedzi
2016-12-13 19:12 Build pyramid in SQL (ORACLE) »
I saw it before, but I don't have any idea how to build it? May be some one have any idea) I need to get result like: 1 11 111 1111 11111 ...
(2) odpowiedzi
2016-12-13 18:12 Take one string variable and use it in an 'IN' statement »
I have a procedure which accepts a parameter called p_my_list_of_numbers. This is a comma delimited string which looks something like this '1,4,5,8,9,...
(1) odpowiedzi