Click here to Skip to main content
15,918,333 members
Home / Discussions / Database
   

Database

 
AnswerRe: Help needed on string function Pin
Kornfeld Eliyahu Peter24-Mar-15 7:42
professionalKornfeld Eliyahu Peter24-Mar-15 7:42 
GeneralRe: Help needed on string function Pin
Ambertje24-Mar-15 23:43
Ambertje24-Mar-15 23:43 
GeneralRe: Help needed on string function Pin
Johan Hakkesteegt8-Apr-15 2:36
Johan Hakkesteegt8-Apr-15 2:36 
QuestionVB.NET MYSQL DATATABLE Pin
Pauls Pauls21-Mar-15 4:33
Pauls Pauls21-Mar-15 4:33 
AnswerRe: VB.NET MYSQL DATATABLE Pin
Peter Leow21-Mar-15 4:56
professionalPeter Leow21-Mar-15 4:56 
AnswerRe: VB.NET MYSQL DATATABLE Pin
manchanx21-Mar-15 5:14
professionalmanchanx21-Mar-15 5:14 
GeneralRe: VB.NET MYSQL DATATABLE Pin
Pauls Pauls21-Mar-15 6:16
Pauls Pauls21-Mar-15 6:16 
QuestionOracle, inner join and substr function Pin
Ludwing RS20-Mar-15 9:29
Ludwing RS20-Mar-15 9:29 
Hi everybody.

My problem: I have a query and it takes too much time to fetch, when I use substr funtion to create an inner join between a table and a view... my code:
SQL
select *
from myview@rs T
inner join myTable D on T.CODE_ONE= substr(D.NUM,0,3) and T.CODE_TWO=substr(D.NUM,3,15) 
where D.NUM='1344628596434'

The problem is:
SQL
on T.CODE_ONE= substr(D.NUM,0,3) and T.CODE_TWO=substr(D.NUM,3,15)

The query doesn't take too long time, when I do this:
SQL
select *
from myview@rs T
inner join myTable D on T.CODE_ONE= '134' and T.CODE_TWO='4628596434' 
where D.NUM='1344628596434'

But I cannot use static values... thanks for the help

modified 20-Mar-15 16:03pm.

AnswerRe: Oracle, inner join and substr function Pin
Eddy Vluggen20-Mar-15 10:21
professionalEddy Vluggen20-Mar-15 10:21 
AnswerRe: Oracle, inner join and substr function Pin
Jörgen Andersson20-Mar-15 13:20
professionalJörgen Andersson20-Mar-15 13:20 
GeneralRe: Oracle, inner join and substr function Pin
Ludwing RS23-Mar-15 8:02
Ludwing RS23-Mar-15 8:02 
QuestionSSRS merging main header of two columns into one and then splitting subheadings Pin
indian14316-Mar-15 12:39
indian14316-Mar-15 12:39 
QuestionSSRS Report not allowing to edit name of the field Pin
indian14316-Mar-15 11:44
indian14316-Mar-15 11:44 
AnswerRe: SSRS Report not allowing to edit name of the field Pin
Richard Deeming17-Mar-15 3:42
mveRichard Deeming17-Mar-15 3:42 
GeneralRe: SSRS Report not allowing to edit name of the field Pin
indian14318-Mar-15 12:46
indian14318-Mar-15 12:46 
QuestionHelp with SSAS project Pin
rafael.avaria16-Mar-15 7:10
rafael.avaria16-Mar-15 7:10 
QuestionProblem executing backup script in Sql Server 2012 Pin
delgaillo12-Mar-15 6:38
delgaillo12-Mar-15 6:38 
AnswerRe: Problem executing backup script in Sql Server 2012 Pin
Mycroft Holmes12-Mar-15 14:51
professionalMycroft Holmes12-Mar-15 14:51 
GeneralRe: Problem executing backup script in Sql Server 2012 Pin
delgaillo12-Mar-15 22:12
delgaillo12-Mar-15 22:12 
GeneralRe: Problem executing backup script in Sql Server 2012 Pin
Mycroft Holmes12-Mar-15 22:14
professionalMycroft Holmes12-Mar-15 22:14 
GeneralRe: Problem executing backup script in Sql Server 2012 Pin
delgaillo28-Sep-15 0:17
delgaillo28-Sep-15 0:17 
QuestionCreating SQL statements in Access Databases Pin
Member 115083508-Mar-15 14:25
Member 115083508-Mar-15 14:25 
AnswerRe: Creating SQL statements in Access Databases Pin
Richard Andrew x648-Mar-15 15:33
professionalRichard Andrew x648-Mar-15 15:33 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 15:42
Member 115083508-Mar-15 15:42 
AnswerRe: Creating SQL statements in Access Databases Pin
Richard Andrew x648-Mar-15 15:48
professionalRichard Andrew x648-Mar-15 15:48 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.