|
More site info...
SQL and PL/SQL
| Forum profile
|
|
Forum profile page for SQL and PL/SQL
on http://www.oracle.com.
This report page is the aggregated overview from a single forum: SQL and PL/SQL
, located on the Message Board at http://www.oracle.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "SQL and PL/SQL
" on the Message Board at http://www.oracle.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on SQL and PL/SQL
:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
593
|
2,260
|
6,513
|
|
Post:
|
2,608
|
10,194
|
30,193
|
|
|
SQL and PL/SQL
Posting activity graph:
|
Top authors during last week:
user's latest post:
Help with a PL/SQL assignment
Published (2009-11-08 05:27:00)
may be you could also give us the table structures and any other information that how those tables are to be logically linked we can give you a hint how can proceed so you also learn PL SQL very fast
user's latest post:
want some logical queries
Published (2009-11-07 07:09:00)
Hi, Welcome to the forum! For more, search for Pagination Query A more common topic is Top-N Query . Once you understand Top-N Queries, doing what you want is easy.
user's latest post:
encountered the symbol create
Published (2009-11-08 11:26:00)
Hi, Although I'm not using SQL DEveloper at the moment: try this (and spot the difference) CREATE or replace TYPE Complex AS OBJECT ( rpart REAL, ipart REAL, MEMBER FUNCTION plus (x Complex) RETURN Complex ); CREATE or replace TYPE BODY Complex AS MEMBER FUNCTION plus (x Complex) RETURN Complex IS BEGIN RETURN Complex(rpart + x.rpart, ipart + x.ipart); END plus; end; CREATE or replace TYPE Complex AS OBJECT ( rpart REAL, ipart REAL,...
user's latest post:
Is posible execute script PLSQL...
Published (2009-11-07 03:37:00)
Welcome to the forum! user7028121 wrote: How is the procedure for execute script PL/SQL on clic a button in a visual basic 2008 form. Coud you help me please. You might get lucky and find someone here who uses Visual Basic 2008, but you might stand a better change at an Visual Basic forum. This forum is dedicated to "how to do stuff in SQL and PL/SQL". I'm sorry for my english but i only speak spanish. Your English is fine....
user's latest post:
ORA-24247: network access denied...
Published (2009-11-08 22:34:00)
Hi, It worked for me. Not sure. Can you post the version? select banner from v$version; Also, try creating a different xml file. Something like, begin dbms_network_acl_admin.create_acl ( acl => 'myaccesslist.xml' , description => 'Normal Access' , principal => 'CONNECT' , is_grant => TRUE, privilege => 'connect' , start_date => null, end_date => null );...
user's latest post:
Trend function?
Published (2009-11-06 14:54:00)
user570142 wrote: Yes, your'e right that I want the quantity on the Y axis and the date on the X axis. We have the forecast in weeks, so the best is to sum quantities in weeks. I do not really understand what you mean by the measure of the accuracy of the regression. The best i if you can show a example. Here is an example of calculating a linear regression: WITH sales_history AS ( SELECT 'label10' AS MATERIAL, 183 AS QUANTITY,...
user's latest post:
Reg:-profiler.
Published (2009-11-08 09:09:00)
Massimo Ruocchio wrote: Each user can alter his own session, while only an administrator can alter the system. Well, there are more ways to trace a session. SY.
user's latest post:
no data found
Published (2009-11-07 21:22:00)
MAX can return NULL values, so you would have to check that the value (if you select it into a PL/SQL variable) IS NULL and raise an error if it was. If you are using this in a different manner (not using an INTO with a variable) then please provide an example and we can go from there.
user's latest post:
NULL Values
Published (2009-11-08 14:21:00)
Try this other approach: Select count(0) records, count(0)-count(month_1) nulls_1, count(0)-count(month_2) nulls_2, count(0)-count(month_3) nulls_3, count(0)-count(month_4) nulls_4, count(0)-count(month_5) nulls_5, count(0)-count(month_6) nulls_6, count(0)-count(month_7) nulls_7, count(0)-count(month_8) nulls_8, count(0)-count(month_9) nulls_9, count(0)-count(month_10) nulls_10, count(0)-count(month_11) nulls_11, count(0)-count(month_12)...
user's latest post:
how to keep a sequence inside a...
Published (2009-11-08 23:02:00)
As said already max + 1 approach is not nice at all. Why? You gave the answer!! I guess my question would be how to write this UPDATE within a function and make sure no other entity is doing it while I am retrieving this value and adding 1 Ok, Now can we lock the table, Yes you can, but thats not going to stop some one else from selecting the value from the table. So forget about max + 1 approach. If you want a unique value in a column go for...
|
|
|
|
Latest active threads on SQL and PL/SQL
::
Started 4 days, 6 hours ago (2009-11-06 12:51:00)
by Massimo Ruocchio
Do you mean this?
Link: http://download.oracle.com/docs/cd/B14117_01/serve r.101/b10759/intro005.htm
( recursive SQL internally used by oracle)
or this?
Link: http://download.oracle.com/docs/cd/E11882_01/serve r.112/e10592/queries.htm#g2080389
(Subquery)
Max
Started 1 day, 5 hours ago (2009-11-09 14:06:00)
by Frank Kulash
Hi, Santhosh,
Whenever you have a question, it helps to post a little sample data (CREATE TABLE and INSERT statements), and the results you want from that data.
In a case like this, where you have a parameter, you should post a couple of different parameters, and the results you want from each one.
Remember that the operands to LIKE are case-sensitive....
Started 1 day, 5 hours ago (2009-11-09 13:33:00)
by Peter Gjelstrup
eeh, why are you posting pseudo code when asking about syntax errors?
One thing though nothing equals null, you can ask if something IS NULL.
Regards
Peter
Started 1 day, 17 hours ago (2009-11-09 02:08:00)
by Cyn
-- START OF TEST DATA
WITH salary AS
(
SELECT 1 as SalaryId, 1 as jobType, 100 as Salary, 1 as maxyear FROM dual UNION ALL
SELECT 2, 1, 200, 5 FROM dual UNION ALL
SELECT 3, 1, 300, 10 FROM dual UNION ALL
SELECT 4, 1, 400, 20 FROM dual UNION ALL
SELECT 5, 2, 1000, 1 FROM dual UNION ALL
SELECT 6, 2, 2000, 5 FROM dual
)
-- END OF ...
Started 2 days, 2 hours ago (2009-11-08 16:42:00)
by Justin Cave
A query like
SELECT *
FROM AWDBT1M4.B2TECDOC
WHERE documentname = <<some value>>
AND documenttype = <<some value>
AND organizationid = <<some value>>
AND organizationtype = <<some value>>
AND revision = <<some value>>
AND sequence = <<some value>>
AND versionnumber = <<some value>>
should use the index.
An index is a more ...
Started 3 days, 6 hours ago (2009-11-07 12:50:00)
by Tubby
Well, within the query (is it one single query?) you should be able to code your logic.
You have analytic functions like COUNT(*) OVER () which would give you the complete count of the number of rows in a result set of a query. ROW_NUMBER() OVER() which will tell you the current row number within a result set, DENSE_RANK, etc....
Using your set of ...
Started 1 day, 10 hours ago (2009-11-09 09:16:00)
by Frank Kulash
Hi,
Apparantly you have some bad data.
See this thread for help in finding it.
I load_date a string also?
If so, you should use TO_DATE in the WHERE clause, also.
Dates belong in DATE columns. Once you find and correct (or remove) all the bad data, you should add a DATE column (or two, depending on load_date) and remove the old VARCHAR2 column(s...
Started 4 days, 12 hours ago (2009-11-06 07:09:00)
by Lakmal Rajapakse
I think pro*c does not support long double. See following article for a workarond:
https://metalink2.oracle.com/metalink/plsql/f?p=13 0:14:7566508511460411162::::p14_database_id,p14_do cid,p14_show_header,p14_show_help,p14_black_frame, p14_font:NOT,167585.1,1,1,1,helvetica
Started 1 day, 7 hours ago (2009-11-09 12:14:00)
by Tubby
If your query returns a single value (which it seems to since your example doesn't like that record to anything in the table you're merging in to or the data you are using to perform the merge) why wouldn't you just select that in to a variable outside the MERGE statement?
SELECT
ts.VALUE
INTO
l_variable
FROM term_scope ts
JOIN campus_term ct ...
Started 1 day, 6 hours ago (2009-11-09 12:32:00)
by Massimo Ruocchio
You're probably using some & character in your script...
Max
|
|
Hot threads for last week on SQL and PL/SQL
::
Started 4 days, 11 hours ago (2009-11-06 07:42:00)
by Vikas Bulchandani
Hiii,
Remove Commit keyword as you are not doing any DB changes!!!
Cheers!!!
Vikas
Started 1 week, 1 day ago (2009-11-02 19:09:00)
by damorgan
Oracle has a built in capability that handles this with ease:
http://www.morganslibrary.org/reference/convert_fu nc.html
Scroll down to the word "Quarter" and run the demo.
Started 4 days, 17 hours ago (2009-11-06 02:14:00)
by Alex Nuijten
instead of showing an image of your table, post the CREATE TABLE statement, and sample data using INSERT statements... makes it a lot easier for us trying to help you..
Started 4 days, 17 hours ago (2009-11-06 01:58:00)
by ravikumar.sv
how many leading zeroes you want......as from observing your data there is no logic for it.
Then why don't just leave it as in varchar2 itself to preserve the formatting
Ravi Kumar
Started 1 week ago (2009-11-03 05:40:00)
by Centinul
Peter Gjelstrup wrote:
My problem is, how do I get rid of that 2009 in the query, so I can have all bank days at once.
Hi Peter.
Can you clarify this statement please? Do you mean you want to remove the YEAR column and possibly CALENDAR_DATE column from the query?
Started 4 days, 11 hours ago (2009-11-06 08:08:00)
by Tubby
posted too soon
Edited by: Tubby on Nov 6, 2009 8:09 AM
Started 5 days, 11 hours ago (2009-11-05 07:49:00)
by Buga
Second One is better.
Less Consistent GETS.
Not sure if the second one is a affected one i. e. may be some data was in the memoery due to first query being run
Cheers!!!
Bhushan
Started 1 week, 1 day ago (2009-11-02 08:08:00)
by Tubby
Well you would have to replace the IIF function with either CASE or DECODE.
And SUBSTR to replace the RIGHT command.
Started 6 days, 6 hours ago (2009-11-04 13:00:00)
by Toon Koppelaars
From what you write I understand that you want to delete the parent (automagically) using a delete trigger on the child table, that detects that the child being deleted happens to be the last child for that parent?
I would advise you not to do this with triggers.
Instead embed the deleting of a child row in a stored procedure, and ensure that all child ...
Started 1 day, 10 hours ago (2009-11-09 08:49:00)
by Sundar M
something like this ?
select * from <tablename> t1
where not exists
(select null from <tablename> t2
where t1.legal_name = t2.legal_name
and t2.flag_1 = 'false'
)
|
|
Size: 815 bytes
