Posts by Renato Afonso • 540 points
26 posts
-
2
votes1
answer37
viewsA: I cannot put result in SQL table
You have to use the clause into: SELECT (VA * VB) / VC into RESULT1 FROM (SELECT 5 AS VA, 10 AS VB, 5 AS VC, X AS RESULT1 FROM DUAL UNION SELECT 1 AS VA, 1 AS VB, 1 AS VC, X AS RESULT1 FROM DUAL…
oracleanswered Renato Afonso 540 -
2
votes2
answers426
viewsA: View Mapping with Entity Framework
If you’re exposing the view with these aliases, you don’t have the ID_TRANSPORTE column, but ID Ship (Be very careful with these spaces, I wouldn’t recommend doing that). And replace to the correct…
-
6
votes1
answer405
viewsA: DELETE in SQL does not run
You need to see if you have other sessions in management studio with pending operations blocking delete. Try clicking on the icon Activity Monitor or Ctrl + Alt + To and see the Processes tab, and…
-
1
votes2
answers235
viewsA: Ensure query result random sorting
You only have 3 columns to sort. Try to force the Random limits to generate a number between 1 and 3 dbms_random.value(1,3) Of course being only 3 hypotheses, it is quite likely to come out some…
-
0
votes1
answer973
viewsA: How to put a color in ONLY one variable in C?
Try this: #include <stdio.h> #define RED "\x1B[31m" #define GRN "\x1B[32m" #define YEL "\x1B[33m" #define BLU "\x1B[34m" #define MAG "\x1B[35m" #define CYN "\x1B[36m" #define WHT "\x1B[37m"…
canswered Renato Afonso 540 -
1
votes2
answers106
viewsA: Doubt Update Panel Gridview
There is no need to associate the name of the event in the updatePanel Trigger? ex: <Triggers> <asp:AsyncPostBackTrigger ControlID="GridView1" EventName="SelectedIndexChanged" />…
-
1
votes2
answers48
viewsA: Use Firefox to run ASP.NET application
If you do Browse With, does Firefox not appear? If it appears, try to put it as default, to see if it appears in that list.
visual-studio-2015answered Renato Afonso 540 -
2
votes2
answers282
viewsA: Regular Expressions in Oracle
I’m going to assume we do this check for the number of spaces... select * from cidades where regexp_count(cidade,' ')=1
-
-2
votes3
answers167
viewsA: Inherited Form comes with no editing option on the whole. Use C# and VS 2017
Right click on the form -> Lock Controls
-
2
votes3
answers1531
viewsA: Validate field after typing in ASP.NET MVC
You can put the following attribute in the username field template [Remote("validaExiste", "Account", HttpMethod = "POST", ErrorMessage = "User name already exists. Please enter a different user…
-
-3
votes3
answers15292
viewsA: VARCHAR2 field boundary size in Oracle
Just one note: if you have Oracle 12c, you can extend this limit to 32767 bytes. To do this, you need to change the parameter MAX_STRING_SIZE = EXTENDED. In this link you have some more information:…
-
1
votes1
answer233
viewsA: Reportviewer does not load in Internet Explorer 11
I already had this problem. I managed to solve it by adding the tag <meta http-equiv="X-UA-Compatible" content="IE=11"> Within the <head> on the page. I found this in the MSDN forums.…
-
2
votes2
answers222
viewsA: How to show the Getall data I performed in an HTML table? MVC C# HTML
Ok. So what you have to do is make a foreach and create one for each column: @foreach (var clientes in Model) { <td> clientes.Nome </td> <td> clientes.Email </td> ...... }…
-
2
votes2
answers314
viewsA: How to restore a database backup from a c#application?
Based on what you did for the backup, do the same for the Restore. The only precaution is that to do the Restore, all connections have to be disconnected. SqlConnection cs = new…
-
2
votes2
answers1924
viewsA: Create Trigger for Quence in Primary key
What is your Oracle version? If it is 12c, there is now identiy column, which does the increment for you, without triggers, nor sequences: CREATE TABLE identity_test_tab ( id NUMBER GENERATED ALWAYS…
oracleanswered Renato Afonso 540 -
1
votes1
answer192
viewsA: What is the difference between freetexttable and containstable
The containstable allows you to specify and build in more detail what you want to look for (it is usually more useful when I have more control in the select I do) Freetexttable allows freetext…
sql-serveranswered Renato Afonso 540 -
-1
votes3
answers7469
viewsA: Connect to oracle database by command line after installation
One thing you can try is if the same user does the installation, try to make: conn / as sysdba
oracleanswered Renato Afonso 540 -
1
votes1
answer116
viewsA: The Entity type 'Personal' is part of a Hierarchy, but does not have a discriminator value configured
What is happening, it seems to me, is that when using the TPH(Table Per Hierarchy) method you have to mention the value of the breakdown column. ex:…
-
1
votes1
answer2183
viewsA: List all Synonyms in Oracle
select * from all_synonyms; There’s a view for every kind of object you create. example: all_tables, all_views, all_procedures......
-
0
votes1
answer53
viewsA: Display a list of fields, reporting movies and associates using CROSS JOIN
Are you sure it’s cross Join you need? cross Join makes no connection between the tables. And you have the links. Try this query: select f.id_filme, f.nome_filme, a.id_ator, a.nome_ator from…
oracleanswered Renato Afonso 540 -
1
votes1
answer131
viewsA: Filter last 3 ratings Oracle sql
From what I understand, you want this subquerie to return only the first three. Then you must turn to rownum. (If you were Oracle12c, there is now a more effective way). ex: (select * from (select…
-
0
votes1
answer27
viewsA: Configure Firewal SQL Server
The most direct solution (if possible) is to set as wide a range as possible: 0.0.0.0 - 255.255.255.255
-
0
votes1
answer80
viewsA: Publish multiple projects in Visual Studio 2012
As far as I know, there’s no direct solution. The options I found or is by Powershell:…
-
1
votes1
answer798
viewsA: Invalid Types of Data
There is no Time data type in Oracle. Date fields keep century, day, month, year , hours minutes and seconds.
-
2
votes3
answers1184
viewsA: Read an Array or Bulk Collect as a table in an Oracle PLSQL
I think what you need to fill the array is this in DECLARE: type tab01_type is table of tabela01%rowtype; (NO INDEX BY INDICATION) then create a variable based on this type: v_tab01_array…
-
0
votes2
answers62
viewsA: last table record change using MAX function
But if you execute the subquerie: (SELECT MAX(T.PPC_DT_ALT) FROM preco_produto_contrato t WHERE T.con_codigo = c.con_codigo AND t.PPC_DT_EXC IS NULL AND U.CON_CODIGO = C.CON_CODIGO AND U.CON_CODIGO…
oracle11ganswered Renato Afonso 540