Search results for query: *

Good day everyone. I am not an expert in MS Access and just started using it. I have figured how to calculate time difference but as it is it only appear on my table while I add the time start and time stop. My next step is to store this data into a column so that I can see the the value when I...

Good day I am new to MS Access and I need to create a table where the value that should be inserted in the column is the time calculation of two other columns. So I have a table with 3 columns. Start_time, Stop_time, TIME_SPENT When I insert my start time and stop time I want the Time_SPENT...

Good day Guys I hope someone can help me on that one. I am trying to copy documents that has the folder structure and document name stored in tables and the actual document is store on a document server. I take the path and files name using TSQL and copy the files to a new location including...

Good day Everyone. As you probably guess I am not the best in Oracle but I have to perform a task where I require to compare data in one table for the same data in an other table but the data I require to compare is a CLOB in the first table and a number in an other table. So on my table 1 the...

Good day everyone I hope someone can help me here. I have to convert some data information from column to rows but I am not sure how i should do this. Bellow you will see an example of what I want to do. The data in my table appear as follow first row being the columns of course. ENTITYID...

Good day Everyone. I an new to Oracle PL/SQL and I am trying to insert a date including time in a DATE column. When I select the SYSDATE option it insert the date but not the time. How can I insert the system Date add the time on to the same column and the time should be in UTC time?. Meaning...

Good day Every one. I would like your assistance to resolve my issue. I have a table that has 3 columns and display as it appear bellow: ID NUMBER Title 103470114 0 Training 103470114 1 Corporate 103470114 2 Documents 103470114 3 Articles I would like to be able to show the ID...

Good day Everyone. I have a table that include sequence value from different tables. I have created a query that does show me all the values for all entries in the table and I have query showing me individual entries if I know the entry does have a broken value. I would like to create a query...

Good day Guys. I would like you expertise on my issue. I have a table that include tree columns. COl1, Col2, Col3 Col2 can be linked to different tables, Table 1 and Table 2 Lets assume that Table 1 include the name of a user and Table 2 include group name Sometime the value in COL2 can be...

Guys I require to extract information from a long column but the value is not always the same. How can I run a script that would return the information every time. What I am trying to do is as follow: CMP=WIN-ASO4LB0DDV6;MULTIIDX=0.500;VER the string above is always in the column. The value I...

Good day everyone. Here is my situation. I have a table with 3 columns The first column is a link column the second column is called name and the third is called data. The column called name include different name like name, description, type and so on. The data is the result of these column...

Good day Guys I hope that someone can help me on that one. I have to restore a database that does not yet exist in my environment and I was provided a backup with a damage transaction log file. Does anyone know if that backup can still be restored even if the transaction log is damaged?

Good day everyone! I hope that you can help me on that one. I am running Oracle 11G and I am not to familiar with the queries. I am trying to run the following to search all tables and columns and I am getting an error. here is the code: DECLARE match_count integer; v_search_string...

Good day guys I have one question here and hope this is possible. I would like to know if it is possible to run a query that would switch to a different database. I know that if select the command use db GO; db being the database I want to use would go to that database but in my case it is a...

Good day everyone. I do not know if anyone can help me on this but here is my question. Does anyone know of a way that you can calculate the maximum number of character being use on a database row in SQL Server? For instance let say I have a table with 5 columns. COL1, col2, col3, col4,col5...

Good day I am new to MS Excel and I would like to know if some one can help me on what I am trying to achieve here. I have an excel document with two worksheet. In worksheet 1 I have two column worksheet also. In worksheet column has a value that match column 1 in my worksheet 2 but the...

Good day everyone I have been task in restoring an oracle database 10 dump from an AIX server into a Windows Oracle 10 database. I have tried the IMPDP command but it always fail. Would anyone have a solution for me. By the was the Oracle database already include a schema with the same name and...

You have all being of a great help.

Good day everyone. I hope that anyone can help me on that one. I would like to know if anyone would have a solution for this. I have been requested to create a function in SQL Server to convert the value of an integer value to a Base 10 or a Base 2 depending on some other value set. Could any...

Good day everyone. I have started playing with function and I would have a question for the best. In the past I have created a store procedure to extract the information from a backup dump and use that information to restore the databases. In my function I was using the following command...