Search Results

Search found 55092 results on 2204 pages for 'oracle add category'.

Page 508/2204 | < Previous Page | 504 505 506 507 508 509 510 511 512 513 514 515  | Next Page >

• How do I return count and not count in a SQL query?

  - by Gribbler

  Hi, If I have a table AgentID | IsNew | TeamID 1 N 1 2 Y 2 3 Y 2 4 N 2 5 Y 1 I want to return the following from a query: Team | CountIsNew = N | CountIsNew = Y 1 1 1 2 1 2 Is there a way I can do this? Using Oracle 10

  Read the article

• Free tool to watch database for changes?

  - by 01

  Im looking for a tool that can watch database(mysql and oracle) for changes. When someone inserts or updates something in any table i want to get to know about it. I know that it can be done using triggers(http://stackoverflow.com/questions/167254/watching-a-table-for-change-in-mysql), but im more interested in some tool that can do it. free tool.

  Read the article

• QueryTables error

  - by ktm5124

  I have the following VBA code inside an Excel macro: With ActiveSheet.QueryTables.Add( _ Connection:=ConnStr, _ Destination:=ActiveSheet.Range("A1"), _ Sql:=SqlStr) .Refresh End With And yet I am getting the error: "Run-time error '1004': Application-defined or object-defined error." The debugger points to this code as the source of error. Assuming that my ConnStr and SqlStr are correct, why am I getting this error? I am using Excel 2007 and I am querying an Oracle database.

  Read the article

• Update multiple table column values using single query

  - by Dave Jarvis

  How would you update data in multiple tables using a single query? In MySQL it would be: UPDATE party p LEFT JOIN party_name n ON p.party_id = n.party_id LEFT JOIN party_details d ON p.party_id = d.party_id LEFT JOIN incident_participant ip ON ip.party_id = p.party_id LEFT JOIN incident i ON ip.incident_id = i.incident_id SET p.employee_id = NULL, c.em_address = '[email protected]', c.ad_postal = 'x', n.first_name = 'x', n.last_name = 'x' WHERE i.confidential_dt IS NOT NULL What is the equivalent SQL statement using Oracle 11g? (Is ANSI SQL possible?) Thank you!

  Read the article

• SQL Express vs SQL Plus

  - by Bruce227

  Hi, I'm wondering what the difference is if any between SQL Express and SQL Plus. I know SQL Plus is used with Oracle but not sure if SQL Plus is a modification of SQL Express or a totally different installation. Thanks

  Read the article

• read consistency in transaction Vs locks?

  - by trojanwarrior3000

  In oracle are these concepts- read consistency and locks related or independent ? why read consistency is needed? My assumption is that read consistency is achieved by locks.Is it ?

  Read the article

• Checking values in this array, JQuery

  - by Felix Guerrero

  Hi. I have this array (JQuery) where I add all my form's controls, it looks like: var name = $("#name"), surname = $("#surname"), address = $("#address"), phone = $("#phone"), photo = $("#photo"), grade = $("#grade"), profession = $("#profession"), email = $('#email'), title = $('#title'), allFields = $([]).add(name) .add(surname) .add(address) .add(phone) .add(photo) .add(grade) .add(profession) .add(email) .add(title) .add(grade); I want to check the values of each element into the 'allFields' array with function checkingFieldsArentEmpty(){ var valid = true; for (var f in allFields){ if(allFields[f].val() === null) //if any val is null just return false return false; } //true return valid; } I need ideas in order to improve the last function. Thanks.

  Read the article

• Is it good to add line-height in body?

  - by metal-gear-solid

  Is it good to add line-height in body{line-height:1.5} or it would be better if i add separately for tag by tag like p{ line height:1em} etc. Edit: body {line-height:in em} create problem with if we put image with float inside Edit: 24 April 2010: If i have to add different line heights to elements like p { 1.4} h1 {1.6} h2 { 1.2} ul li { 1.1} then shouldn't i use line height in body { 1.4} if body { 1.4} and h1 {1.6} then what would be line height for h1?

  Read the article

• Question About SQL Query

  - by Ameer

  I am using the below statement to generate age of a person in Oracle SQL and my question is below. SELECT TO_NUMBER(TO_CHAR(CURRENT_DATE,'YYYY'))-TO_NUMBER(TO_CHAR(BIRTH_DATE,'YYYY')) FROM NAME WHERE NAME_ID =NAME_ID This statement is only correct upto so far that I need a statement which could count months and even days in order to get the age.

  Read the article

• How to Add a Dynamic Layer to an Esri Map Control Programatically in WPF?

  - by Scott

  Just as the question asks. I have an Esri map control and want to add a Rastor image to the control in WPF and don't know how to do it. I see that I can add layers to the Map control, but is there a way to add a Raster image to a map control? I did find this code to turn the raster image into a Dynamic layer, but Im still lost on how to add a dynamic layer to the control it self. http://resources.esri.com/arcgisserver/apis/silverlight/index.cfm?fa=codeGalleryDetails&scriptID=16723 Thank you!

  Read the article

• How do I add categories from another user in outllook 2003 to my list of categories in 2007?

  - by Ernst

  Hi, I'm sharing a contact list with another user on the network, but I'm using outlook 2007 and the other user is using outlook 2003. The other user has assigned many different categories, but I do not get those categories added to the list of categories I can choose from when adding/editing contacts, I can see certain contacts have those categories. How do I add those categories so I can also add them? The shared contacts originate from the other user. Thanks

  Read the article

• What is the benefit to add W3C logo in site?

  - by jitendra

  http://www.w3.org/QA/Tools/Icons If my code is valid then Should i add logo to all my personal and client sites.? Should i add logo to client sites and tell to client these are good to have? If code is valid but semantically correct even can we use logo? What is benefit and purpose to add these logos for XHTML, CSS accessibility. And what is the difference between Gold and Blue logo Why W3C provide these logos?

  Read the article

• How to add custom location is Save As dialog box?

  - by Ram

  Hi, I want to add a custom folder location in "Save As" and "Save" dialog box. Currently it shows "My Computer" , "Desktop" , "My Documents" and "My Recent Documents" option on the LHS of the dialog box. I want to add a custom location "C:\Test" there. How can I do that?

  Read the article

• What's an easy way of storing an array of numbers in Javascript that I can add/remove from?

  - by SLC

  In C# I would create a List then I could add and remove numbers very easily. Does identical functionality exist in Javascript, or do I have to write my own methods to search and remove items using a loop? var NumberList = []; NumberList.Add(17); NumberList.Add(25); NumberList.Remove(17); etc. I know I can use .push to add a number, so I guess it's really how to remove an individual number without using a loop that I'm looking for. edit: of course, if there's no other way then I'll use a loop!:)

  Read the article

• How can I add a keyboard shortcut for Find-In-Files in SQL Server Management Studio?

  - by Eric H.

  I'd like to make it Ctrl-Shift-F to match Visual Studio. I realize to do that I need to remove that binding from the Query-Save to File item. But, I can't even add ANY shortcut. When I pull up the Tools/Customize box, pick Edit in the Categories and then Find-in-Files in the Commands, the box for "Modify Selection", where I assume I could add a shortcut, is greyed out. Any clues?

  Read the article

• Is there a nvl() function in Ruby or do I have to write it myself?

  - by jva

  I want to use an equivalent of Oracle's nvl() function in Ruby. Is there a built in function or do I have to write one myself?

  Read the article

• Foreign Keys and Primary Keys at the same time

  - by Bader

  hello , i am trying to create table (orderdetails) , the table has two FKs and PKs at the same keys here is my code create table OrderDetails2 ( PFOrder_ID Number(3) PFProduct_ID Number(3) CONSTRAINT PF PRIMARY KEY (PFOrder_ID,PFProduct_ID), CONSTRAINT FK_1 FOREIGN KEY (PFProudct_ID) REFERENCES Product(Product_ID), CONSTRAINT FK_2 FOREIGN KEY (PFOrder_ID) REFERENCES Orderr(Order_ID) ); i am using Oracle express , a problem pops when i run the code , here is it ORA-00907: missing right parenthesis what is the problem ?

  Read the article

• manipluation of date in vb

  - by banita

  how can we extract system time in vb and do calculation ie. adding or subtracing time then store change time in oracle database table in earlier format .

  Read the article

• need help with a simple SQL update statement.

  - by Tony

  There's a field with type of varchar. It actually stores a float point string. Like 2.0 , 12.0 , 34.5 , 67.50 ... What I need is a update statement that remove the ending zeros of fields like 2.0 , 12.0 , change them to their integer representation , that is 2 , 12 ...,and leave 3.45 , 67.50 unchanged . How should I do this ? I am using oracle 10.

  Read the article

• optimizing the sql query by not repeating the math..

  - by user333747

  Here is the query in Oracle I was trying to remove the redundant math operation from: SELECT name, CASE when nvl(num1,0) + nvl(num2,0) - nvl(num3,0) > 0 THEN nvl(num1,0) + nvl(num2,0) - nvl(num3,0) ELSE 0 END as result, .... from .... How do I not repeat the summation above?

  Read the article

• android dev: how to implement for add method in menu interface?

  - by wsgjj

  who knows about the method "add" in menu interface? how to implement exactly? which is it's imlementation class? i couldn't find detail implementation in source code of sdk. i want to check how to implement in android source code for "add" method. e.g. public boolean onCreateOptionsMenu(Menu menu) { menu.***add***(0, MENU_NEW_GAME, 0, "New Game"); menu.add(0, MENU_QUIT, 0, "Quit"); return true; } thanks in advance!

  Read the article

• Want to add a new property to a class, can I use anonymous functions for this?

  - by Blankman

  I have 2 Lists: List<User> List<UserStats> So I want to add a property Count to User (it doesn't have one now, and I can't change the implementation at this point). For a web service call, that returns json, I want to modify the User object. Basically I add the Users to a collection. So I want to add a modified user class (via anonymous functions?) to the collection before I serialize it to json. So something like: loop users { user.Count = userstats[user.ID].Count; list.Add(user); } is this possible? how?

  Read the article

• How do I add the "Date Created" sort-by option to the shell in Windows 7?

  - by Daniel

  I know how to add it via the context menu, but it never seems to be a permanent option. I would like it to show in all folders without having to continually go back through and add it. How can I make Windows Explorer show file modified date instead of created date? I've looked at this question, so I assume it is the same as going through the context menu seen by right clicking inside the folder.

  Read the article

• Create web application with ajax from the begining or add ajax later?

  - by klew

  I'm working on my first Ruby on Rails aplication and it's quite big (at least for me ;) - database has about 25 tables). I'm still learning Ruby and Rails and I never wrote anything in Javascript nor Ajax. Should I add Ajax to my application from the begining? Or maybe it will be better to add it latter? Or in the other words: is it (relatively) easy to add ajax to existing web application?

  Read the article

• How to select a row with a missing entry in historization?

  - by Viper

  from the following data basis i need to select all IDQ's which do not have an entry for the 11.11.2011. IDQ | DATE ---------------- 1 | 08.11.2011 1 | 09.11.2011 1 | 10.11.2011 1 | 12.11.2011 1 | 13.11.2011 i can't figure out how to express the sql select IDQ from TBL_WITH_IDQ T where not exists ( DATE = '11.11.2011' ) // sql does not the job Database is a Oracle 11g. maybe someone can help me?

  Read the article

< Previous Page | 504 505 506 507 508 509 510 511 512 513 514 515  | Next Page >