« first day (2904 days earlier)      last day (1957 days later) » 

7:20 AM
Morning
 
Morning
I'm voting to close this question as off-topic because it has been cross-posted and answered over at Database Administrators. Please don't cross-post. — Andriy M 12 secs ago
 
7:42 AM
Morning
 
8:08 AM
Morning
 
 
1 hour later…
9:23 AM
Morning
 
821
A: Jon Skeet Facts

Jon SkeetThese are written in the third person so as not to disrupt the style of the thing. But hey, as we all know, Jon Skeet can make 1 == 3 anyway, so it makes no difference. Jon Skeet is immutable. If something's going to change, it's going to have to be the rest of the universe. Jon Skeet's additio...

 
 
3 hours later…
11:58 AM
0
Q: Question with multiple tags - which tag gets credited?

dbdemonIf I ask a question with multiple tags on it, which tag gets "credited" with that question in the stats? On the tags page, do all the tags I use increase their count, or only one of them? If only one, how do you decide which? If all of them, will tags added later through edits also be credited?

 
 
3 hours later…
2:46 PM
Hi
how to input value inside string
i am passing input parameter inside procedure the input parameter i need to use inside string
how to use that
like sample
create or replace procedure Sample( rowsize number )
is
v_result varchar2(100);
v_str varchar2(200);
begin
v_str := 'Select rtrim(legl_ent_name) || '' | '' ||rtrim(legl_ent_prd_grp) as heirarchy from legl_ent_regn where rownum < rowsize';
EXECUTE IMMEDIATE v_str ;
DBMS_OUTPUT.PUT_LINE(rowsize);

end;
/
this i am testing in pl/sql
i want to use without bind variable, because i have requirement like such
 
@ashutosh I suggest you post a question at our site
There are a few Oracle users at the chat room but they not respond soon. Writing a question exposes the issue to many more eyes.
 
3:14 PM
Agreed. Almost always better to post a question.
 
3:52 PM
👀
 
4:19 PM
I don't think he's going to post a question lol
 
5:03 PM
Well look at that. It never poped up on the new question feed.
Or it did and I'm blind.
 
 
3 hours later…
8:04 PM
0
Q: single or multiple databases advice needed

MacsicarrI know there are a few of these posts, but not in relation to my specific quandary. I've always gone the 'per user' SQL Server DB rather than 'one DB for all' because: a) I thought speed wise it's better for a lite user to only work within their small DB rather than all users being possibly aff...

One of those. I've crafted a maintanance nightmare for myself because I'm scared of having a "large" database kind of questions.
 
 
2 hours later…
9:58 PM
@Zane we had a zillion of those questions already but unfortunately no canonical answer
 
@TomV For sure. Been seing a ton of them lately
 
@EvanCarroll Have a look: meta.stackexchange.com/a/319976/351450
 
Sweet.
 
Someone should check when JOIN LATERAL was added to the standard, and when CROSS APPLY was introduced in SQL Server
 
Well, it's Christmas!!
 
10:22 PM
Is there a hat for: Trying to keep everybody happy?
 
10:52 PM
In this case it's called Oracle
 
11:38 PM
@McNets My GF does Cross Stitch, that's cool.
 
Surely you mean lateral stitch
 
bwahhaha
CROSS LATERAL
 
😃
 

« first day (2904 days earlier)      last day (1957 days later) »