General GD Topics
- How to deal with international terrorism.
- Should we pursue our policy of dialogue with Pakistan?
- Is peace and non-violence outdated concepts?
- The rise of regional blocs threatens independent nations like India
- Six billion and one bronze!
- Is dependence on computers a good thing?
- Should the public sector be privatised?
- China and India are similar nations with contrasting ways
- Is India a Soft Nation?
- Value based politics is the need of the hour
- Religion should not be mixed with politics
- How to deal with high oil prices
- Our cricketers are not to blame for match fixing
- Why cant we be world players in industry as we are in software?
- Multinational corporations: Are they devils in disguise?
3 comments:
Hi There,
Thank you SO MUCH! I was actually holding my breath as I followed these directions. It worked beautifully!
It's great to utilize the power of internet with the available free blogs.
Appreciate your effort for making such useful blogs and helping the community.
Regards,
Mike
Hi There,
Interesting piece!Great to see someone write general-gd-topics-topics-set-1.html who is not a fanatic or a complete skeptic.
I'm a beginner in oracle and I need some help. I have a table tha would look like below.
LOT WFID
G3AR95 G3AR95_01
G3AR95 G3AR95 _02
G3AR95 G3AR95_03
H4AR96 H4AR96_12
H4AR96 H4AR96_20
Basically I just wanted to count the number of WFID associated to a LOT:
The report would look like this. How to achieve this using sql?
LOT WF_Count
G3AR95 3
H4AR96 2
Thanks a lot. This was a perfect step-by-step guide. Don’t think it could have been done better.
Regards,
Preethi.
Marhaba,,
Fully agree on #topic. We’re seeing a lot of projects tackle big complex problems but few seem to have taken into consideration and in particular reasons to adopt.
I want to execute the different files at the run time in the SQL PLUS
Ex: I have two different files like ABC.SQL, XYZ.SQL,
I had declared one bind variable to hold file_name .
var file_name VARCHAR2(200);
DECLARE
sr VARCHAR2(20) :='ABC';
BEGIN
IF sr ='ABC' THEN
:file_name :='ABC.SQL';
ELSE
:file_name :='XYZ.SQL';
END IF;
END;
/
PRINT file_name
Now i want to execute the file which is there in :file_name bind variable
SQL>@:file_name
It was cool to see your article pop up in my google search for the process yesterday. Great Guide.
Keep up the good work!
Post a Comment