Advertisement

05.30.2008 at 04:06AM PDT, ID: 23444168
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!
8.3

ORA-00923 (FROM keyword not found where expected) on a larger sql statement

Asked by Tolomir in Oracle 10.x

Tags: , ,

Hi, I could need some help on this sql statement i got.

I'm not that familar with case so I suspect a simple syntax error here.

Any ideas?

Thank you.

TolomirStart Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:

SELECT DTREEACL.DATAID "Object ID", CASE DTree.SubType WHEN 0 THEN 'Folder' WHEN 1 THEN 'Alias' WHEN 2 THEN 'Generation' WHEN 128 THEN 'Workflow Map' 
WHEN 130 THEN 'Topic' 
WHEN 131 THEN 'Category' WHEN 132 THEN 'Category Folder' WHEN 133 THEN 'Categories Volume' WHEN 134 THEN 'Reply' WHEN 136 THEN 'Compound Document' 
WHEN 137 THEN 'Release Volume' WHEN 138 THEN 'Release' WHEN 139 THEN 'Revision' WHEN 140 THEN 'URL' WHEN 141 THEN 'Enterprise Workspace' 
WHEN 142 THEN 'Personal Workspace' WHEN 143 THEN 'Discussion Volume' WHEN 144 THEN 'Document' WHEN 145 THEN 'Text Document' WHEN 148 THEN 'System Volume' 
WHEN 150 THEN 'Livelink' WHEN 153 THEN 'Workflow Step' WHEN 154 THEN 'Workflow Attachments' WHEN 161 THEN 'Workflow Volume' WHEN 162 THEN 'Workflows Edit Volume' 
WHEN 180 THEN 'Domain Workspace' WHEN 188 THEN 'Workflow Status' WHEN 189 THEN 'Workflow' WHEN 198 THEN 'Classifications' WHEN 201 THEN 'Project Workspace' 
WHEN 202 THEN 'Project' WHEN 204 THEN 'Task List' WHEN 205 THEN 'Task Group' WHEN 206 THEN 'Task' WHEN 207 THEN 'Channel' WHEN 208 THEN 'News' 
WHEN 209 THEN 'Channel Volume' WHEN 210 THEN 'Task List Volume' WHEN 211 THEN 'Reports Volume' WHEN 212 THEN 'Milestone' WHEN 215 THEN 'Discussion' 
WHEN 218 THEN 'Poll' WHEN 223 THEN 'Form' WHEN 226 THEN 'HTML View' WHEN 230 THEN 'Form Template' WHEN 231 THEN 'Submit Version' WHEN 257 THEN 'Livelink Search Engine' 
WHEN 258 THEN 'Query' WHEN 259 THEN 'Enterprise Extractor' WHEN 260 THEN 'Proxy' WHEN 268 THEN 'Template Folder' WHEN 269 THEN 'Search Manager' 
WHEN 270 THEN 'Data Flow Manager' WHEN 271 THEN 'Process' WHEN 272 THEN 'Enterprise Search Engine' WHEN 275 THEN 'Slice Folder' WHEN 276 THEN 'Data Source Folder' 
WHEN 277 THEN 'Directory Walker' WHEN 278 THEN 'Search Result Snapshot' WHEN 280 THEN 'Spider' WHEN 281 THEN 'Index Engine' WHEN 282 THEN 'HTML Conversion' 
WHEN 285 THEN 'XML Activator Producer' WHEN 286 THEN 'XML Activator Consumer' WHEN 287 THEN 'XML Activator Intermediate' WHEN 288 THEN 'XML Activator Filter' 
WHEN 289 THEN 'XML Activator' WHEN 290  THEN 'Backup Manager' WHEN 291 THEN 'Backup Process' WHEN 292 THEN 'Search Template' WHEN 293 THEN 'Enterprise Importer' 
WHEN 294 THEN '2 Way Tee' WHEN 299 THEN 'LiveReport' WHEN 301 THEN 'Personal Workspace' WHEN 302 THEN 'Projects' WHEN 303 THEN 'News' WHEN 304 THEN 'Reports' 
WHEN 305 THEN 'Assignments' WHEN 306 THEN 'Favorites' WHEN 307 THEN 'Queries' WHEN 308 THEN 'Snapshots' WHEN 309 THEN 'LiveReports' WHEN 335 THEN 'XML DTD' 
WHEN 336 THEN 'XML DTD Volume' WHEN 385 THEN 'Prospector' WHEN 387 THEN 'Prospector Snapshot' WHEN 391 THEN 'Collector' WHEN 392 THEN 'Collector Folder' 
WHEN 400 THEN 'External Project' WHEN 401 THEN 'Installation' WHEN 402 THEN 'Deleted Documents Volume' WHEN 410 THEN 'Livelink Physical Object Module' 
WHEN 411 THEN 'Livelink Physical Object Module' WHEN 412 THEN 'Livelink Physical Object Module' WHEN 550 THEN 'Records Management' WHEN 552 THEN 'Hold Maintenance' 
WHEN 553 THEN 'RSI' WHEN 554 THEN 'Disposition' WHEN 556 THEN 'Table Maintenance' WHEN 666 THEN 'MeetingZone Meeting Room' 
WHEN 120374 THEN 'Appearance HTML' ELSE 'Unknown' END 'Object Type', DTree_1.Name AS [Object Location],DTree.Name AS [Object Name], 
CASE DTREE.CATALOG WHEN 0 THEN 'List' WHEN 1 THEN 'Catalog' WHEN 2 THEN 'Hidden' END 'Object Display Type', CASE DTREEACL.RIGHTID WHEN '-1' THEN 'Public Access' 
WHEN '-2' THEN 'System Administrators' ELSE 'User ID: ' + STR(DTREEACL.RIGHTID) END [Privileges Assigned To], CASE DTreeACL.Permissions WHEN 128 THEN 'No Rights' 
WHEN 130 THEN 'S' WHEN 36995 THEN 'S/SC' WHEN 36999 THEN 'S/SC/AI' WHEN 62666 THEN 'S/M' WHEN 65670 THEN 'S/M/AI' WHEN 102531 THEN 'S/SC/M' WHEN 102535 THEN 'S/SC/M/AI' 
WHEN 102547 THEN 'S/SC/M/EP' WHEN 102551 THEN 'S/SC/M/EP/AI' WHEN 118915 THEN 'S/SC/M/DV' WHEN 118919 THEN 'S/SC/M/AI/DV' WHEN 118923 THEN 'S/SC/M/DV/D' 
WHEN 118927 THEN 'S/SC/M/AI/DV/D' WHEN 118931 THEN 'S/SC/M/EP/DV' WHEN 118939 THEN 'S/SC/M/EP/DV/D' WHEN 118935 THEN 'S/SC/M/EP/AI/DV' 
WHEN 118943 THEN 'S/SC/M/DP/AI/DV/D' WHEN 127107 THEN 'S/SC/M/DV/R' WHEN 127111 THEN 'S/SC/M/AI/DV/R' WHEN 127115 THEN 'S/SC/M/DV/D/R' 
WHEN 127119 THEN 'S/SC/M/AI/DV/D/R' WHEN 127123 THEN 'S/SC/M/EP/DV/R' WHEN 127127 THEN 'S/SC/M/EP/AI/DV/R' WHEN 127131 THEN 'S/SC/M/EP/DV/D/R' 
WHEN 127135 THEN 'S/SC/M/EP/AI/DV/D/R' WHEN 233603 THEN 'S/SC/M/EA' WHEN 233607 THEN 'S/SC/M/EA/AI' WHEN 233619 THEN 'S/SC/M/EP/EA' WHEN 233623 THEN 'S/SC/M/EP/EA/AI' 
WHEN 249987 THEN 'S/SC/M/EA/DV' WHEN 249991 THEN 'S/SC/M/EA/AI/DV' WHEN 249995 THEN 'S/SC/M/EA/DV/D' WHEN 249999 THEN 'S/SC/M/EA/AI/DV/D' 
WHEN 250003 THEN 'S/SC/M/EP/EA/DV' WHEN 250007 THEN 'S/SC/M/EP/EA/AI/DV' WHEN 250011 THEN 'S/SC/M/EP/EA/DV/D' WHEN 250015 THEN 'S/SC/M/EP/EA/AI/DV/D' 
WHEN 258179 THEN 'S/SC/M/EA/DV/R' WHEN 258183 THEN 'S/SC/M/EA/AI/DV/R' WHEN 258187 THEN 'S/SC/M/EA/DV/D/R' WHEN 258191 THEN 'S/SC/M/EA/AI/DV/D/R' 
WHEN 258195 THEN 'S/SC/M/EP/EA/DV/R' WHEN 258199 THEN 'S/SC/M/EP/EA/AI/DV/R' WHEN 258203 THEN 'S/SC/M/EP/EA/DV/D/R' WHEN 258207 THEN 'Full Permissions' 
WHEN 16777215 THEN 'Admin' ELSE 'New: ' + STR(DTreeACL.Permissions) END Permissions, KUAF.FirstName + ' ' + KUAF.LastName as [User Name], KUAF.Name "Group Name/Login" 
FROM DTreeACL INNER JOIN DTree ON DTreeACL.DataID = DTree.DataID 
INNER JOIN KUAF ON DTreeACL.RightID = KUAF.ID 
INNER JOIN DTree DTree_1 ON DTree.ParentID = DTree_1.DataID 
WHERE (DTreeACL.ACLType = 0) AND (DTreeACL.ParentID <> -1) AND (DTreeACL.Permissions <> 128) and kuaf.deleted=0 and DTree.ParentID = 4653640 
ORDER BY DTree_1.Name, DTree.Name
[+][-]05.30.2008 at 04:08AM PDT, ID: 21676659

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 06:46AM PDT, ID: 21677650

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 06:47AM PDT, ID: 21677660

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Oracle 10.x
Tags: oracle, oracle, 10g
Sign Up Now!
Solution Provided By: angelIII
Participating Experts: 2
Solution Grade: B
 
 
[+][-]05.30.2008 at 07:15AM PDT, ID: 21677914

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 07:37AM PDT, ID: 21678141

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]05.30.2008 at 07:51AM PDT, ID: 21678287

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 08:10AM PDT, ID: 21678504

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]05.30.2008 at 08:18AM PDT, ID: 21678578

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 08:32AM PDT, ID: 21678714

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 08:45AM PDT, ID: 21678854

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 10:01AM PDT, ID: 21679511

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
 
Loading Advertisement...
20081112-EE-VQP-42 / EE_QW_2_20070628