Oracle 11g SQL select max integer value of varchar column -

-

myTable 

 UNID 9 10

UNID एक VARCHAR2 है

मेरीटेबल से अधिकतम (यूएनआईडी) का चयन करें यूएनआईडी को उच्चतम लेक्सिकोग्राफिक मान (9) के साथ देता है।

मैं सबसे अधिक पूर्णांक मान (10) के साथ यूएनआईडी कैसे चुनूं?

नहीं 

  अधिकतम चुनें (to_number (UNID)) से अपनेटेबल

काम?


Comments

Post a Comment

Popular posts from this blog

SQL/PHP: Table design question -

-
I have two tables, called a "cart" and what I call "items" That the cart be able to store a "item" and a list of quantities. That's why I have created another table "cart_items" which contains the ID of the template, the ID of the item and the quantity. Is this a good design, or should I add another area for the ID of "cart_itim"? Or is there a better way to do it all together? When I try to update my car, I am just running in trouble, my cart items do not update properly, what am I going to do all "cart_times" by car Is connected and then to re-add each "cart_item" and I can not help but it seems that there should be a better way This is a very good design. In the words ER (unit relationship) there are many relationships between objects and cart, through this I mean that an item can appear in many different trains and many different in a cart - Different items may be included In this context ...
Read more

c# - PInvoke of NetUserAdd returns 24 -

-
I am calling NetUserAdd and it is returning 24 for each call. Does anyone know 24 stands for? When I do not know what the error is, it is very difficult to debug it. I'm calling it a Windows XP machine running as a local administrator. I am also a local administrator on the target computer. I tried to do it with USER_INFO_1 and it worked fine. I need a level of control given by USER_INFO_2. This shows the return value for this call. They are further defined by numeric values. Unfortunately none of these values ​​= 24 I know this is a very specific question. I think I'm hoping to find a PInvoke / NetAddUser expert who can help me out there Here in case my code matters. [StructLayout (LayoutKind., Choracet = charset.unycode)] Public structure USER_INFO_2 {name of the public string; Public string password; Public int password_age; Public entities Private; Public string home_dir; Public string comment; Public integer flags; Public string script_path; Public int auth_...
Read more

NHibernate Passing Session to the Repository -

-
How do I go about passing a session for a repository class? We say that I have two projects 1) TestSite 2) Business Objects The Republican Business Objects Project is included in the project. The NHibernate session has been opened in the test site project. Now, I want to use the same session because the test site initiates the transaction on that session. Currently, I am using the following: var repository = New Customer Resor (_session); Of course, it looks ugly! I'm thinking in some way that a dependency injection frame can be tilted and I can be provided without entering the repository with the ejection object. In our WCF service, we actually use a unitofwork that wraps an operation and stores ISSN for that operation. . The repositories know how they are receiving a hint from the current unit of work under which they are running In case of testing we have a base test class, Those who are included in any test class, who touch the test database, we then control t...
Read more