Posts by Cleber Teixeira • 321 points
9 posts
-
0
votes3
answers124
viewsA: Return only the time in Select
Try this: SELECT TO_CHAR(SYSDATE, 'HH24') Hora, TO_CHAR(SYSDATE, 'HH24:MM:SS') Completo FROM dual;…
oracle11ganswered Cleber Teixeira 321 -
2
votes4
answers177
viewsQ: How to get the entire HTML of the last Fieldset into a dynamic page?
I have a div where multiple are added fieldsets and just below a hr: The content of div is dynamic and may have 3 or more fieldsets. In my code I could only get the contents inside the first. How…
-
2
votes2
answers5403
viewsA: Cut the last character of a string C#
Try to use the Substring: foreach (DataRow row in dt.Rows) { foreach (DataColumn column in dt.Columns) { txt += row[column.ColumnName].ToString() + ";"; txt = txt.Substring(0,txt.Length - 1); } txt…
-
2
votes3
answers5944
viewsA: CSS - Align image inside table with inline css
Remove the padding-top:10px; of the second TD and try this; <html><head><title></title></head> <body> <table style="border: solid 1px black"> <tbody>…
-
1
votes1
answer622
viewsQ: Error Case and Group by - Oracle SQL Developer
Hello, I’m trying to group the results of a query with case as follows: select case when sal BETWEEN 0 and 100000 then 1 when sal BETWEEN 100001 and 200000 then 2 when sal BETWEEN 200001 and 300000…
-
6
votes1
answer2655
viewsA: My project no longer opens
Using version control If you are using some code versioner you can try to uncheck your current project and map it again. (Do this only if you have no pending changes) No version control If the…
-
0
votes1
answer418
viewsQ: How to get bank reports through web application?
Where I work there are some procedures in the database (SQL Server 2008) that take hours to run and return large amounts of information that are always copied to a spreadsheet and sent to the end…
-
2
votes1
answer718
viewsQ: Convert string in parameter to arrayToDataTable(varString)
Hello, I’m starting to use ajax and the Google API (Chart) to create charts. I use a Generic Handler I called 'Collaboratorsempresa.ashx', in it I make a query in the database and return a string…
-
1
votes2
answers6591
viewsA: Error trying to establish connection between SQL Server 2014 and Visual Studio
Pegasus, try this on; Make sure the instance name is correct. (EX: Database Name) Make sure that the machine used as the server is accessible. (You can use ping at the command prompt to check that…