|
Hi
have you found a solution for this issue?
|
|
|
|
|
anyone can guide me that how to read & write data in queue in sql server.
do i need to create queue first like table ?
queue is persistent object in db like table ?
please post a small example for read & write data in queue in sql server.
tbhattacharjee
|
|
|
|
|
|
The member is question seems to have a pathological aversion to using Google for themselves. 
|
|
|
|
|
Good Morning Sir,
I am willing to install oracle database on my computer. So I have downloaded the database from here Oracle Database Software Downloads | Oracle Technology Network | Oracle[^] I found 12c is the latest database and I have downloaded it. Mine is a Windows 10 64 bit Operating System based on x-64 processor so the database will work in my computer since Microsoft Windows x64 (64-bit) is only present.
I created the oracle account and started installing the database, there were few steps prompted to me before installing the database, I've chosen the default settings and moved on. But I got this error,
Failed to add VISWESWARAN\Visweswaran install user to %2% group
I have searched the internet for this error and referred this Configuring Users, Groups and Environments for Oracle Database[^] thread but I found nothing.
Sir, could you please help me
Thank you for your time sir.
|
|
|
|
|
Have a look at Oracle 12c Install on Windows
It is for Windows 7, but I guess, the installation process on Windows 10 should not differ too much.
|
|
|
|
|
Thank you sir for your kind reply. But I have tried that and I see the same error message 
|
|
|
|
|
Can you elaborate on this one
I created the oracle account and started installing the database, there were few steps prompted to me before installing the database, I've chosen the default settings and moved on
|
|
|
|
|
Sir,
I mean the initial steps for installing the database like
[radio-button] [selected] Install and configure database
[radio-button] Install database
[Back] [Next]
here Install and configure is the default selected option, all I did is clicked next. since I am a beginner in Oracle database, I've selected the default options without modifying various values.
No, sir there is no guest user account in my computer, I have only one account in my PC which is admin
Thank you sir for your time and kind help
|
|
|
|
|
I believe that you are installing the software as an Administrator. Right?
|
|
|
|
|
After you have registered all the required data show me this message
|
|
|
|
|
These are not the data you are looking for... move along.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
|
Member 13161516 wrote: After you have registered all the required data show me this message |
- Could you post the exact message?
- Could you explain what and how you did?
- Was it in MS SQL Server or in some other DBMS?
|
|
|
|
|
give me code to how to get metadata of table from database in php.
naveen kumar
|
|
|
|
|
We do not provide free code or projects. You should help yourself and try to find the code from here. You are most likely to get a project sample, and work for that.
Try searching, "mysql data definition sql php" on the top right corner.
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
Member 13143024 wrote: give me
No.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hi,
I want to avoid dynamic sql but my Table name varies for different run, is there any better way to avoid the dynamic sql in this situation?
I am trying my best, searching, asking and implementing different approaches etc, if anybody can give me some suggestion, link or even code snippet that would very helpful.
Hi,
I have a table (Table123) that has Columns ColA, ColB, ColC, ColD, ColE, ColF, ColG, I have many rows entered in the same table but want to check for two rows RowA, RowB, if for example I have three columns that are different in these two rows, I want to select those Column Names, like if ColA, ColC and ColE are changed then my query should return me as below
TableName, ChangedColumnName, OldValue, NewValue
Table123 , ColA, 123 Greetings 123 New Greetings
Table123 , ColC, 123 World 123 Hello World
Table123 , ColE, 123 Test World 123 New World
etc.
Is there anyway I can do it, but without using dynamic sql any help would be greatly helpful, thanks in advance.
Thanks in advance
Thanks,
Abdul Aleem
"There is already enough hatred in the world lets spread love, compassion and affection."
-- modified 17-Apr-17 16:04pm.
|
|
|
|
|
If you have only a few possibilities for the tables and they are known beforehand then you could do a simple case structure to decide the query.
But before you jump into solutions, few questions you should consider:
- Why do you want to avoid dynamic SQL? When done properly, it has it's place.
- Is the table name the only thing that varies in the queries. If it is, I would suggest reconsidering the structure of the database, because in such situation it sounds that the different tables could be replaced with a single table with proper categorizing fields.
|
|
|
|
|
- I saw Dynamic Sql is taking lot of time for execution, even if I use it with most possible ways when Data becomes little bit, the difference in execution time is too huge.
- No I saw now that I have use Columns as well randomly - is there any way like compare with sysColumns and then get its type then join with it etc? Anything works for me without using dynamic sql.
Thanks,
Abdul Aleem
"There is already enough hatred in the world lets spread love, compassion and affection."
|
|
|
|
|
Hi,
I have a table (Table123) that has Columns ColA, ColB, ColC, ColD, ColE, ColF, ColG, I have many rows entered in the same table but want to check for two rows RowA, RowB, if for example I have three columns that are different in these two rows, I want to select those Column Names, like if ColA, ColC and ColE are changed then my query should return me as below
TableName, ChangedColumnName, OldValue, NewValue
Table123 , ColA, 123 Greetings 123 New Greetings
Table123 , ColC, 123 World 123 Hello World
Table123 , ColE, 123 Test World 123 New World
etc.
Is there anyway I can do it, but without using dynamic sql any help would be greatly helpful, thanks in advance.
Thanks,
Abdul Aleem
"There is already enough hatred in the world lets spread love, compassion and affection."
|
|
|
|
|
You lost me with the "three columns that are different in these two rows" - how can you have different columns in specific rows of a single table?
You've also mentioned that your dynamic SQL is taking a long time to run - I don't believe that is because it is dynamic SQL. It's more likely to be the way you have constructed the actual query.
If you share the code you use to build the dynamic query it might help me to understand what you are trying to achieve (and we might also be able to solve your performance problem)
|
|
|
|
|
Chilli is right, dynamic sql is unlikely to be your problem, query design is almost certainly the cause of slow processing.
You need to create a temp table that hold all the field from the various sources and feed the records into that table to make the structure the same.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Yeah Could be but most of the times I used Dynamic Sql if the rows are in like 10000s or 100000s then performance of the Stored Procedure decreased even after enabling and disabling the Query plans in both situations it decreased heavily, but I was able to bring that up 10 or 20 minutes, which is not bad for ETLs. But then the Politics involve and make us inferior just for that reason. That's what happens most of the times. But yes normal queries I ran so far run within couple of minutes but the dynamic sql took 10s or 20s of minutes and I could not able to minimize it more than that.
Any help would be greatly helpful - thanks for all help my friends.
Thanks,
Abdul Aleem
"There is already enough hatred in the world lets spread love, compassion and affection."
|
|
|
|
|
Have you taken the script of the dynamic query and run a query profile on it to see if there are indexes that can be tuned.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
