This forum is currently locked. You can't register or post questions at this time. (read more)

1235761575/10471/69:1/0/0 1236211418/5589/83:1/0/0 123636909

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

quyenpn318
Member
Posts: 2
Joined: Thu Apr 05, 2012 4:43 am

1235761575/10471/69:1/0/0 1236211418/5589/83:1/0/0 123636909

Postby quyenpn318 » Thu Apr 05, 2012 4:52 am

1235761575/10471/69:1/0/0 1236211418/5589/83:1/0/0 1236369092/411/4:0/0/0 1239920321/1198721/2535:14/0/0
1241119850/1223936/7895:65/0/0 1244574991/7826/27:1/0/0 1244583176/255213/10:0/0/0 1245367704/503/0:0/0/0
1245368503/1637619/584:6/0/0 1247007255/1188964/200:5/0/0 1248196496/2595770/4011:34/0/0 1250813571/2853801/743:11/0/0
1253910772/29700/559:5/0/0 1253940725/2057788/584:7/0/0 1259871934/10243/440:5/0/0 1261432430/1395920/111:4/0/0
1262828913/2318429/20:1/0/0 1265147659/1472720/4434:25/0/0 1266633171/935663/1:0/0/0 1267569167/252959/580:5/0/0
1267823877/6664/827:2/0/0 1267831342/5462/2956:2/0/0 1267837105/190/2:0/0/0 1267838655/1919/13:0/0/0
1267840914/5745/5:0/0/0 1267847083/125/0:0/0/0 1267848275/494098/79:2/0/0 1268344010/4765521/1333:17/0/0
1273109876/1210772/0:0/0/0 1274320991/1707187/0:0/0/0 1276028636/9075199/355:3/0/0 1285113456/1294047/61:1/0/0
Last edited by quyenpn318 on Fri Apr 06, 2012 1:50 am, edited 1 time in total.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Electric fee example

Postby Tim... » Thu Apr 05, 2012 9:17 am

Hi.

1) It is not clear what the relationship between the two tables is, or what the rules you have to work by are.

2) The way you've phrased your question, requiring 1 SQL and 2 PL/SQL solutions, suggests this has been set as some sort of question or assignment for you to complete. As a result, even if I understood your question, it would be wrong of me to give you an answer as you would not have learned the lesson.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle SQL and PL/SQL Development”

Who is online

Users browsing this forum: No registered users and 0 guests

cron