Posts by Melanie Ribeiro • 101 points
10 posts
-
1
votes1
answer81
viewsA: Removing data with TRUNCATE wouldn’t be DDL command?
I talked to a friend who is studying for certification, he said that in some cases really only exists the concept DDL and DML. Eliminating the initial idea that answer B would be for DCL. I think C…
-
1
votes1
answer307
viewsA: Name columns with value returned from Select
declare @sql varchar(300) select @nome = 'QTD_' + cast ( MONTH(getdate()) as varchar) print @nome select @sql = 'select id, nome ' + @nome + ' from bot_arquivo ' print @sql exec(@sql) I confess to…
-
0
votes2
answers509
viewsA: How to map multivariate attributes?
I would make a new table for these keywords. It would be: note that P is Primary Key, F Foreign Key, the red asterisk is null (mandatory).…
-
0
votes1
answer128
viewsA: Type of relationship between tables (Laravel)
I see some relationships... Following the business idea (correct me if you need to adapt): **Users** (contém Cliente e Fotográfo) id nome cpf login senha ft_perfil > outros dados, se necessário…
-
1
votes2
answers870
viewsA: What are the differences between a PL/SQL programmer and an Oracle DBA?
I believe they are different specializations within the Data Bank aspect in informatics, but complementary. As I work in Software Factory, each project the focus is one: sometimes SQL programming…
-
2
votes3
answers280
viewsA: Log tables should have Foreign Keys?
Instead of me being totally without log logging, it would be better if I create the log tables without Fks, and thus be able to delete the records without generating Foreign key error? William, I…
-
0
votes1
answer550
viewsA: Update oracle with separate information
It seems that in the select below, it is returning more than one id_campus = 1... Believing that in this "table1" it is Foreign of a table "campus", for example. (SELECT t2.Description, t2.flag FROM…
-
0
votes1
answer289
viewsA: Synchronize the server database with a localhost
If you can not change the settings of the computer, you can try to make a Linked Server and have a routine in the "daughter" database to from time to time gather information from this Linked Server…
-
0
votes1
answer207
viewsA: String problem in oracle
execute 'ALTER TABLE BALANCE ADD TYPE varchar2(255 char) default PRIMARIO not null'; Try two quotes, for example: (I don’t have Oracle on my machine, but it works the same on Oracle!)…
-
2
votes5
answers2275
viewsA: How to reduce the search time in a table with more than 200,000 records?
200,000 are not many records, but you can try to break the result per page by limiting the logical id of the lines. Ie, return from 1 to 10, 11 to 20, 21 to 30.... To do this has the rownumber in…