w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
How to retrieve hashtaged tweets from a list of users
Note: I've updated the library so I suggest you grab the newly updated version before trying this - I've made it so you don't need to manually encode each individual character. This page shows you how to use search, and has a number of operators down toward the bottom of the page. One of these is the OR operator: Getting tweets for multiple users OR - Either this or that love OR hate - containing either "love" or "hate" (or both) From - From this user from:twitterapi sent from the user @twitterapi So, armed with the above knowledge, I'm guessing your query would look like this: Translated into a GET request: ?q=from:user1+OR+from:user2 Getting tweets for specific hashtags So that's how you get tweets for multiple users. The next step you want is for certain hashtags. #

Categories : Twitter

How can I retrieve list of Active Directory users
You can use a PrincipalSearcher and a "query-by-example" principal to do your searching: // create your domain context using (PrincipalContext ctx = new PrincipalContext(ContextType.Domain)) { // define a "query-by-example" principal - here, we search for a UserPrincipal // and with the first name (GivenName) of "Bruce" UserPrincipal qbeUser = new UserPrincipal(ctx); qbeUser.GivenName = "Bruce"; // create your principal searcher passing in the QBE principal PrincipalSearcher srch = new PrincipalSearcher(qbeUser); // find all matches foreach(var found in srch.FindAll()) { // do whatever here - "found" is of type "Principal" - it could be user, group, computer..... } } If you haven't already - absolutely read the MSDN article Managing

Categories : Dotnet

SQL Query in Oracle SQL Developer
Don't join the tables. as you require to get the data from only one table and table structure are same then you can have multiple unions -- In oracle database you can not have column name as date, I am assuming that date column name is c_date- select ItemID, c_Date, and UserCode from Jul1 where UserCode = 'Automation' AND c_date = trunc(sysdate) -1 union all select ItemID, c_Date, and UserCode from Jul2 where UserCode = 'Automation' AND c_date = trunc(sysdate) -1 union all select ItemID, c_Date, and UserCode from Jul3 where UserCode = 'Automation' AND c_date = trunc(sysdate) -1 union all select ItemID, c_Date, and UserCode from Jul4 where UserCode = 'Automation' AND c_date = trunc(sysdate) -1 *sysdate is system function which will return the current date with time value.

Categories : SQL

facebook android sdk - Only developer account can share posts but other users can't
I assume you might have forgotten to add the tester privileges to the facebook accounts that you tried other than the developer account. As you are developing your app it will be in Sandbox mode in which only developer account and tester accounts will be having access.Go to your apps in developer.facebook.com and add tester accounts.

Categories : Android

iOS Developer Enterprise program - can device users install the app directly?
From Distributing Enterprise Apps for iOS Devices: About deploying apps (which requires Apple developer login) it describes 4 different ways of distributing Apps including over the air: Distribute the app for your users to install using iTunes. Have an IT administrator install the app on devices using iPhone Configuration Utility or Apple Configurator. Post the app on a secure web server; users access and perform the installation wirelessly. Use your MDM server to instruct managed devices to install an in-house or App Store app, if your MDM server supports it.

Categories : IOS

Once your updated app is uploaded to the Developer Console, how long will it take for users be notified
1.. For me it usually took anything from 24h to 3,4 days for a notification to show in users phones. ---Sometimes it wouldnt show as a single notification, rather it would pop on a regular check for updates that the google play services app does by it self, when all apps that have updates show up in noifications. 2.. You cant push the notification officially through google play. But you can push the notification using other means when you update your app. (GCM for ex.) . But still this doesnt mean the user will update the app. You cant force them to update, only offer it to them. You arent also forced to do software updates for your phone ;)

Categories : Java

Joining Tables in Oracle SQL Developer
If you want to output the rows from all the tables, and if the columns are the same in each table, UNION ALL will work. Note that this isn't a JOIN in the database sense, though it kind of is in an English sense: SELECT * FROM JNL1 UNION ALL SELECT * FROM JNL2 UNION ALL SELECT * FROM JNL3 UNION ALL SELECT * FROM JNL4 You can add an ORDER BY to the end if needed. UNION is similar to UNION ALL, but it will omit rows where all of the values are duplicates.

Categories : SQL

oracle sql developer not storing unicode
I figured this out myself. I just had to force the utf8 flag on all the data being pushed into the oracle database. code as follows: $description = Encode::decode_utf8($description); Cheers for everyones help.

Categories : Mysql

BRIDGE command in Oracle SQL Developer
This is a bug in SQL Developer 4.0 Beta1 & Beta2. The workaround is to start SQL Developer , Tools > Migration > Scratch Editor .Then open the worksheet and run your BRIDGE command. In this way the migration plugin is loaded which provides the BRIDGE functionality. A fix is being worked on Regards, Dermot.

Categories : SQL

Using Source Code Control in Oracle SQL Developer
Firstly, your question talks about two un-related concepts - using source control in SQL Developer and the other about PL/SQL. Hence here is a response that will hopefully disambiguate everything for you: Oracle SQL Developer does provide a way to integrate with source control. Refer this link for instructions. It talks about Subversion, howver the same must be applicable to any other source control repository like Perforce or Clearcase. Whether this is a better solution to doing version control to Oracle - there is no definitive Yes/No for this; however the approach is definitely recommended (why else would they provide it in the first place? :) ). Keeping your code editor integrated with version control will save the pain associated with manually checking out every file that you are e

Categories : Oracle

How do I get the console output visible in Oracle Developer IDE?
I assume that you mean "Oracle SQL Developer" application. If yes, the in SQL Developer click on View option, then select Dbms output DBMS Output window (panel) should appear somewhere on the screen. Then, click on green plus sing in the DBMS-Output panel, and select a session you want to spy.

Categories : Oracle

Creating a new database and new connection in Oracle SQL Developer
This tutorial should help you: Getting Started with Oracle SQL Developer See the prerequisites: Install Oracle SQL Developer. You already have it. Install the Oracle Database. Download available here. Unlock the HR user. Login to SQL*Plus as the SYS user and execute the following command: alter user hr identified by hr account unlock; Download and unzip the sqldev_mngdb.zip file that contains all the files you need to perform this tutorial. Another version from May 2011: Getting Started with Oracle SQL Developer For more info check this related question: How to create a database after installing oracle database 11g Express Edition?

Categories : SQL

How to switch sql worksheet display in oracle sql developer 3.2
ctrl-up and ctrl-down navigate your query history in SQL Worksheet, at least by default. That doesn't sound quite like what you're seeing, but possibly you're going back through old versions of partial statements that you've now combined in a single script, in which case you can just ctrl-up until you get back to the current state (though it only seems to keep things you've executed, so if you change something and then hit ctrl-down before running, I think your changes are gone...). I don't think you can disable that behaviour, but you can make it harder to trigger by accident, if that is what's happening. From the Tools->Preferences->Shortcut Keys option, search for ctrl-down, and highlight the entry for category 'Other'. Click in the 'new shortcut' area at the bottom and type a more obs

Categories : Oracle

Oracle sql developer - export DDL - only create table sql
It's some work, but you can implement your own tool to create the DDL. All you need is stored in the Oracle database catalogue. To create just tables (without index and constraints) you need these 2 tables: USER_TAB_COLUMNS USER_TABLES You will find a detailed documentation of these tablese here: Oracle Database Reference Other usefull Oracle tables are USER_CONSTRAINTS USER_INDEXES

Categories : SQL

Unable to connect to Oracle database from SQL Developer
The SID is the name of the database instance. The error message indicates you've got it wrong. Edit the default value for the port is 1521, for the SID is ORCL. Both parameters are configured in the tnsnames.ora file on the database server.

Categories : Asp Net

Show Full SDO_DIM_ARRAY in Oracle SQL Developer
The best answer seems to be to join the array cast to the source table so that it expands each element of the array to a different row: SELECT META.TABLE_NAME, META.COLUMN_NAME, META.SRID, DIM.* FROM USER_SDO_GEOM_METADATA META, TABLE(META.DIMINFO) DIM; The results look something like this: TABLE_NAME COLUMN_NAME SRID SDO_DIMNAME SDO_LB SDO_UB SDO_TOLERANCE TABLE1 GEOM 3857 X -20037700 20037700 0.1 TABLE1 GEOM 3857 Y -20037700 20037700 0.1 TABLE2 GEOM 3857 X -20037700 20037700 0.1 TABLE2 GEOM 3857 Y -20037700 20037700 0.1

Categories : Oracle

Unknown SQL coding issue in Oracle SQL Developer
try something like this: WHERE TRUNC(CR.GCR_RECEIVED_DT) = TO_DATE('01-JAN-00','DD-Mon-YY') TRUNC without parameter removes hours, minutes and seconds from a DATE.

Categories : SQL

ORA-00911: invalid character in C#, but not Oracle SQL Developer
At a minimum, you don't want the trailing semicolon in the SQL statement you send from C#. I would strongly advocate as well that you use bind variables rather than concatenating together a string with your SQL statement. That will be more efficient, it will prevent shared pool related errors, it will make your DBA much happier, and it will protect you against SQL injection attacks.

Categories : C#

Connection Information for Oracle SQL Developer database
The reason why you are getting the error is because you have not specified service name or SID as it doesn't know to which instance it should connect. I suppose you are using one of the latest versions of SQL Developer available for download. Right click connections and choose New Connection from context menu, you will get a window like one is pasted below, there you enter connection details and do not forget to enter either service name or SID. Hope this helps.

Categories : Oracle

Multi-column search in lov of oracle forms developer 6i
An Oracle Forms LOV only searches the first column - so you might need to concatenate 2 or more columns into the first column to get what you want. Otherwise, you may need to make your own custom LOV form.

Categories : Oracle

Get the names of all Triggers currently in the database via SQL statement (Oracle SQL Developer)
What you have is pretty close: select owner, object_name from all_objects where object_type = 'TRIGGER' Or more usefully: select owner, trigger_name, table_owner, table_name, triggering_event from all_triggers all_triggers has other columns to give you more information that all_objects does, like when the trigger fires. You can get more information about this and other useful data dictionary view in the documentation.

Categories : SQL

How to extract only Time from a DateTime field in Oracle SQL Developer?
Assuming your goal is to generate a string representing the time (which is what the query you posted returns despite the extraneous to_number calls) SELECT to_char( <<column_name>>, 'HH24:MI:SS' ) FROM table_name If you want to return a different data type, you'd need to tell us what data type you want to return. If, for example, you really want to return an INTERVAL DAY TO SECOND SELECT numtodsinterval( <<column name>> - trunc(<<column name>>), 'day' ) FROM table_name

Categories : Oracle

Oracle Forms Developer 6i: EXECUTE_QUERY do not working after ENTER_QUERY Mode
The problem probably is that there are a few options with your trigger. One of them is if it will fire when in enter query mode. Because you are in enter-query mode right now this switch should be true. Then it will work. The default for the switch is false, so no trigger will fire in enter-query mode.

Categories : Oracle

Bypassing Chrome/FF developer tools security issue (enabling users to access hidden forms)?
You can never 'trust' input from your users. Whatever you do. With developer tools you can easily add HTML into a website and post the values to the server. You could even edit the POST itself and add whatever data you want. Security and checks need to be done server-side. You can simply use your jQuery show/hide and do the validation server-side.

Categories : Javascript

Retrieve a users GPS coordinates over a website
Assuming that you are using a Android App from your tag. You would want to pull the GPS location through a single update. Pass that to the webview through the URL parameters and then pass those along through the form submit. If you are using just a webpage opened by a mobile browser on a phone I would suggest looking into HTML5 which has some handy resources. This however will only work on the more modren browsers and is not a 100% pinpoint location. http://www.w3schools.com/html/html5_geolocation.asp

Categories : Android

Why can't I retrieve the users email from Google Plus API after getting permission
There's an open issue for that since a while that you can star. In the meantime you can use an authenticated request against the OAuth2 Userinfo API instead. require_once '../../src/contrib/Google_Oauth2Service.php'; (...) $oauth2Service = new Google_Oauth2Service($client); (...) $userinfo = $oauth2Service->userinfo->get(); $email = $userinfo["email"];

Categories : PHP

How to use associative array in JavaScript to retrieve users?
var roomsMap = { room1: [], room2: [], room3: [] }; roomsMap.room1.push(user1); or if you need the key to be dynamic: roomsMap[roomKey].push(someUser); EDIT: almost good. But how to make roomsMap Dynamic as well and not be restricted to room1, room2, room3 ? You could do it this way to dynamically add new key/array to the roomsMap. (roomsMap[roomKey] = roomsMap[roomKey] || []).push(user1); Complete example: var roomsMap = {}, user1 = {"username":"john","sex":"male"}, roomKey = 'room1'; (roomsMap[roomKey] = roomsMap[roomKey] || []).push(user1); console.log(roomsMap[roomKey]); //[Object { username="john", sex="male"}]

Categories : Javascript

Wordpress Users Request to Retrieve Username by email address
get_userdata() Returns a WP_User object with the information pertaining to the user whose ID is passed to it. - http://codex.wordpress.org/Function_Reference/get_userdata $user_info = get_userdata(1); echo 'Username: ' . $user_info->user_login . " "; echo 'User level: ' . $user_info->user_level . " "; echo 'User ID: ' . $user_info->ID . " "; So you could create a form that utilizes the above code to grab what you need. If you can give more info such as if the user wil be currently logged in or not, only the logged in user's username, or anyone can get any username with an email address are all questions I'd have. Gluck.

Categories : Wordpress

Oracle Forms 10g or 11g for users with limited vision
You can try the ClientDPI parameter in webforms.cfg I've used it to fix form size (you could say "zoom level") on linux and mac clients. It's not user configurable, but you could offer your users several zoom options through the calling url Check this out: http://docs.oracle.com/cd/E15523_01/web.1111/e10240/configure.htm Hope it helps.

Categories : Oracle

String loses last character when concatenated with empty string in Oracle SQL Developer
When you're playing with RAWs and VARCHARs, it's mandatory that you provide us with the character set that you're using (database character set and client cs). The reason is that every byte value is legal for a raw byte, from 0x00 to 0xFF. Whereas most character sets have illegal values: byte values that correspond to no character. When Oracle encounters such values, the consequences can be unpredictable. This is likely what happens here. For instance in UTF-8, a byte whose binary representation starts with '110...' is the first byte of a two-byte character. And it's exactly your situation: a byte that starts with a C has a binary representation that starts with 1100 and can only be the first byte of a two-byte character. The second byte has to start with 10.. (8 to B). So if I had to

Categories : SQL

how do you retrieve the latest value from an oracle table
Try this, might actually be faster than the sub-select (even if it was correct): SELECT T."Node", T."Timestamp", T."MAX_User_CPU_Pct", T."MAX_System_CPU_Pct" FROM ( SELECT p.*, row_Number() over (partition by p."Node" order by p."Timestamp" desc) as rn FROM DW.KPX_CPU_DETAIL_HV p ) t where rn = 1;

Categories : SQL

Oracle SQL Query to retrieve metadata
I have done it before for someone else. If you like it feel free to use it. CREATE PROCEDURE copy_prc AS BEGIN NULL; END; CREATE FUNCTION copy_fun RETURN BOOLEAN AS BEGIN RETURN TRUE; END; CREATE PACKAGE copy_pkg AS PROCEDURE pkg_prc; END copy_pkg; CREATE PACKAGE BODY copy_pkg AS PROCEDURE pkg_prc AS BEGIN NULL; END; END copy_pkg; CREATE TABLE source_codes ( s_database VARCHAR2(30) , s_package_name VARCHAR2(30) , s_source_code CLOB ); DECLARE CURSOR objects_cur IS SELECT object_name, DBMS_METADATA.GET_DDL(object_type, object_name) r_source_code FROM dba_objects WHERE owner = USER AND object_type IN ('PROCEDURE', 'FUNCTION', 'PACKAGE') AND object_name IN ('COPY_PRC',

Categories : Oracle

WP8 In-App list in the Developer Dashboard
Go to your application profile on the Dashboard, select "Products", then click the "Add in-app product" link:

Categories : Windows

SQL Developer: Joining tables from connected SQL Server DB and connected Oracle DB
Oracle has the concept of a DBLink, and SQL Server has the concept of a Linked Server. Both these features let you query data from two separate databases. Here's a link with instructions for setting up an Oracle DBLink to a SQL Server DB... http://www.dba-oracle.com/t_database_link_sql_server_oracle.htm And here's a link with instructions for setting up a SQL Server Linked Server to an Oracle DB... http://support.microsoft.com/kb/280106 See also this SO post... SQL statement joing Oracle and MS SQL Server

Categories : SQL

retrieve the latest timestamp value from the oracle table
Do not cast it to char or do cast it to YYYYMMDD rather than dd-Mon-yyyy as you do. SELECT max(CAST((FROM_TZ(CAST(GET_UTC_TIMESTAMP(T."Timestamp", TMZDIFF) AS TIMESTAMP),'+00:00') AT TIME ZONE 'US/Eastern') AS DATE) as DATETIME FROM DW.KPX_PHYSICAL_MEMORY_DV T where T."Node" like 'server%'

Categories : Oracle

How to retrieve Oracle Clob more than 4000 characters ODP.NET
Actually the code works correctly and gets the data it supposed to get. I just didn't realize that my data is incomplete and appeared to be a retrieval problem at the first look. Sorry. The following is the good code. using (OracleConnection oConn = new OracleConnection()) { oConn.ConnectionString = pConnstr; oConn.Open(); using (OracleCommand oCmd = new OracleCommand("select varchar_column, clob_column from test", oConn)) { oCmd.InitialLOBFetchSize = -1; string key, value; var rd = oCmd.ExecuteReader(); while (rd.Read()) { if (rd.IsDBNull(1)) { value = ""; } else { key = rd.GetValue(0).ToString(); value = rd.GetValue(1).ToString(); } } } }

Categories : C#

How to retrieve all recursive children of parent row in Oracle SQL?
You are close: select connect_by_root parent_id base, parent_id, child_id, qty from md_boms connect by prior child_id = parent_id order by base, parent_id, child_id; BASE PARENT_ID CHILD_ID QTY ---------- ---------- ---------- ---------- 25 25 26 1 25 25 27 2 25 26 28 1 25 26 29 1 25 26 30 2 25 27 31 1 25 27 32 1 25 27 33 2 26 26 28 1 26 26 29 1 26 26 30

Categories : SQL

Oracle APEX format a cell based on users input
Give the region a static ID. Put these style rules somewhere, for example page heading: <style> .annual{ background-color:yellow; } .ex{ background-color:grey; } .trainingcourse{ background-color:peach; } </style> Run this javascript but replace the STATICID with the static id of your report. Add cases and classes where required. The advantage here is that you steer the look from your CSS and not by using jquery. You could assign a backgroundcolor straight away if you do prefer that, but my own preference is to keep this separated. $("#report_STATICID td[headers]").each(function(){ var lTest = $(this).text(), lClass; switch(lTest){ case 'AL': lClass = "annual"; break; case 'X': lClass = "ex"; break; case 'C':

Categories : Javascript

Can Oracle's regular expression substring be used to retrieve "n" words before or after another string?
OK I think I understand what you want: given a string, you specify a position or a word and you want a predefined number of words after or before that word. Let's assume the input string: this is a test of a moderately long group of words. I am assuming the words contain only alphanumeric characters and underscores _. I am assuming the words are separated by spaces. Warning: I think your functions will be more efficient than using regular expressions. Case 1: Before the word If you want to get the 3 words right before moderately in the sentence then you can use: (?:w+|s){6}(?=moderately) ^^ ^^^ ^^^^^^^^^^^ | double number| of words you need | | | the word you want to look before the separator, if there is more than one possibl

Categories : Regex

How to list all events from a particular folder which are going on today? And email the list to users
You can use a collection to get all events which contain today in their daterange and for the mail-sending you can use colective.contentrules.mailtotogroup. It is capable to send the body-text-field, too. If that's what you were looking for.

Categories : Email



© Copyright 2017 w3hello.com Publishing Limited. All rights reserved.